1.打开cmd命令行,输入:sqlplus
2.管理员登陆,用户名:SYSTEM。密码:123456
3.创建表空间,输入:
create tablespace XFCP_YWXT
DATAFILE 'D:/app/A/oradata/orcl/XFCP_YWXT.DBF'
SIZE 100M AUTOEXTEND ON
next 100m maxsize unlimited;
4.创建账户
CREATE USER XFCP_YWXT
IDENTIFIED BY XFCP_YWXT
DEFAULT TABLESPACE XFCP_YWXT;
5.然后,我们需要给自己的用户赋予权限来管理自己的表空间
GRANT CREATE SESSION,CREATE ANY TABLE,CREATE ANY VIEW ,CREATE ANY INDEX,CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,DROP ANY TABLE,DROP ANY VIEW,DROP ANY INDEX,
DROP ANY PROCEDURE,SELECT ANY TABLE,INSERT ANY TABLE,UPDATE ANY TABLE,DELETE ANY TABLE TO XFCP_YWXT;
6.也是授权
GRANT DBA TO XFCP_YWXT;
7.把*.dmp文件放入D:\app\A\admin\orcl\dpdump下。此处有两种方法都可以:
[1]输入:
imp XFCP_YWXT/XFCP_YWXT@localhost/orcl file=D:\app\A\admin\orcl\dpdump\EXPDP_XFCP_YWXT_20181115.DMP full=y
[2]输入:
impdp XFCP_YWXT@ORCL DUMPFILE=EXPDP_XFCP_YWXT_20181115.DMP REMAP_SCHEMA=XFCP_YWXT:XFCP_YWXT FULL=Y;
导出sql:
EXPDP XFCP_YWXT@ORCL DUMPFILE=EXPDP_XFCP_YWXT_20181122.DMP ESTIMATE=STATISTICS