Essentials for Oracle Restore Database

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