Data files recovered by performing an open recovery - EXP,IMP - Oracle Tablespaces

Q.  Data files of which tablespaces can be recovered by performing an open recovery?
- Published on 28 Jul 15

a. TEMP
b. INDEX
c. SYSAUX
d. ALL MENTIONED ABOVE

ANSWER: ALL MENTIONED ABOVE

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 01 Oct 15
    Index
    - An index is a schema object that contains an entry for each value that appears in the indexed column(s) of the table or cluster and provides direct, fast access to rows.

    - Oracle Database supports several types of index: Normal indexes. (By default, Oracle Database creates B-tree indexes.)

    Temp
    - Use the CREATE TEMPORARY TABLESPACE statement to create a locally managed temporary tablespace, which is an allocation of space in the database that can contain schema objects for the duration of a session.

    - If you subsequently assign this temporary tablespace to a particular user, then Oracle will also use this tablespace for sorting operations in transactions initiated by that user.

    Sysaux
    - SYSAUX is the name of the compulsory tablespace, introduced in Oracle 10g, to support optional database components (called occupants) like AWR, Statspack, Oracle Streams, etc.

    - You can query v$sysaux_occupants, to get the list of SYSAUX occupants.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲