--Create the user create user XX identified by "", default tablespace USERS temporary tablespace TEMP profile default Password expire;--grant/revoke role privileges Grant connect to Xx<span style= "font-family:arial, Helvetica, Sans-se RIF; " >;</span>grant Ctxapp to Xx;grant dba to Xx;grant exp_full_database to xx;--grant/revoke System privileges Grant Alter ANY index to xx;grant alter all table to xx;grant create all index to xx;grant create any table to xx;grant create Session to Xx;grant drop any index to xx;grant drop any table to xx;grant Select any table to Xx;grant unlimited TABLESPAC E to XX;---Delete user, prompt cannot delete current user link user select ' Alter system kill session ' | | To_char (a.sid) | | ', ' | | To_char (serial#) | | "" from v$session awhere a.username=xx;--run the query results, and then delete the user---scheduled task select Job,broken,what,interval,t . * from User_jobs t; Begin Dbms_job.remove (63); End --Export (exclude table T_attachment) EXPDP switch40/[email protected] DumpFile = switch40_0606_1907.dmp schemas=switch40 Exclude=tabLe:\ "in (' t_xx ') \"--import. From the user switch40 just backed up to the new user SWITCH52IMPDP switch52/[email protected] dumpfile = switch40_0606_1907.dmp remap_schema= switch40:switch52
Oracle Create user and backup restore database operations