⟩ Tell me can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?
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.