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