Oracle user creation and database backup and restoration operations
-- 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-serif;" >;</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 any table to XX; grant create any 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 tablespace to XX; --- When deleting a user, the system prompts that the current user link user cannot be deleted. select 'alter system kill session ''' | to_char (. sid) | ',' | to_char (serial #) | ''' from v $ session awhere. username = XX; -- execute the query result and then delete the user --- select job, broken, what, interval, t. * from user_jobs t; begin dbms_job.remove (63); end; -- Export (exclusion TABLE T_ATTACHMENT) expdp switch40/switch40 @ orcl dumpfile = fig schemas = switch40 EXCLUDE = TABLE: \ "IN ('t_xx') \" -- import, from the user switch40 just backed up to the new user SWITCH52impdp SWITCH52/SWITCH52 @ orcl dumpfile = switch40_0606_00007.dmp remap_schema = switch40: SWITCH52