Essentials for Oracle Restore Database

Source: Internet
Author: User

Create tablespace dsxzfw datafile ' D:\yangk\oraclespace\DSXZFW.ora ' size 1000m; Create a tablespace, and note that if you want to restore the database, the tablespace name must be the same as the space name at the time of backup (that is, the table space name used by the customer site)

Create user EQQXZFW identified by SA default tablespace DSXZFW quota 500m on users; Create this tablespace associated user grant all privileges to EQQXZFW; Grant this user permission to log on

Commit//Submit

Alter tablespace SYX rename to DSXZFW; Modify table space Names

commit//Submit

Drop tablespace DSXZFW including contents and datafiles; Delete Table space

Drop user EQQXZFW cascade//delete users

Restore requires the same user name, the same tablespace name.

IMP Ds_xzfw/[email protected] FROMUSER=DS_XZFW TOUSER=DS_XZFW file=d:/database/xzfw_yw. DMP Ignore=y//This is the code to restore the database
fromuser= User name touser= import time

Essentials for Oracle Restore Database

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.