Oracle RMAN Interview Question:

Tell me can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?

Submitted by: Administrator

RMAN gives the command to find all the tablespaces and hence the datafiles belonging to different schemas as:REPORT SCHEMA;This command lists all the schemas, tablespace names and the corresponding data files. After listing, we can restore the datafiles or the tablespaces corresponding to a particular schema.
Submitted by: Administrator