Oracle Create user and backup restore database operations

Source: Internet
Author: User

--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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.