RATE THIS ANSWER
0
Click to Vote:
0
0
What tools were you using when you got the error? The only reason you would get an error is if you were doing (backup, creation of new Shema, importing data...) is that you were using Oracle DBconsole or through the GUI. If you choose not to use the GUI interface and if you dba privs, then you shouldn't get the error.
--Using SQLPLUS(W) to create a new schema
create user <username> identified by <password>
default tablespace <tablespace_name>
temporary tablespace <temp_tablespace_name>;
--grant appropriate quota on tablespace and privs
--Using DataPump or Exp/Imp Utility to import data
Imp <username/password@tns> file=<file_name> owner=<schema_to_import>
--Using Rman for backups
Please read Google backup/recover (RMAN) for prereq
--Basic backup of database
Rman target <username/password@tns>
run
{
backup database;
}
Last Answered:
May 12 2009 2:30 PM GMT by BLT 
15 pts.