0.Oracle数据库相关:
需开启服务:OracleServiceLfgstest和xxxListener
数据库,如:lfgstest(和SID保持一致)
表空间,如:LFGS
创建用户:lfgs(一般和表空间保持一致)
给用户授权:
--------------------------------------------------------------------------------------
1.使用database configuration assistant 创建lfgstest数据库(SID和数据库名称一致),详细步骤可百度
设置管理员账号的密码>>
账户:sys和system
密码:kys511
--------------------------------------------------------------------------------------
2.使用管理员账号登陆:
sqlplus sys as sysdba
kys511
--------------------------------------------------------------------------------------
3.创建临时表空间:
create temporary tablespace LFGS_TEMP tempfile ‘D:\app\Administrator\oradata\lfgstest\LFGS_TEMP.DBF’ size 100M autoextend on next 100m maxsize unlimited extent management local;
--------------------------------------------------------------------------------------
4.创建数据表空间:
create tablespace LFGS logging datafile ‘D:\app\Administrator\oradata\lfgstest\LFGS.DBF’ size 800M autoextend on next 100m maxsize unlimited extent management local;
--------------------------------------------------------------------------------------
5.创建用户:
create user lfgs identified by 12345678 account unlock default tablespace LFGS temporary tablespace LFGS_TEMP;
--------------------------------------------------------------------------------------
6.给用户授权
grant connect,resource,dba to lfgs;
--------------------------------------------------------------------------------------
7.导入数据库
7.1:将要导入的文件放在以下文件夹中>>
D:\app\Administrator\admin\lfgstest\dpdump
7.2:打开cmd黑窗口>>
7.3:使用impdp导入数据库时,dumpfile=后面直接写文件名就可以了>>
impdp lfgs/12345678@lfgstest dumpfile=20190822-010000.DMP
--------------------------------------------------------------------------------------
8.如果导入数据库报错了,使用SQL developer登陆sys账号,删除用户lfgs,删除用户命令如下
drop user lfgs cascade;
删除以后,可以重新进行数据库的导入
--------------------------------------------------------------------------------------
9.数据库导出语句
expdp lfgs/12345678@lfgstest dumpfile=lf-dp20190822.dmp logfile=lf-dp20190822.log
注意事项:
转自:https://blog.csdn.net/whxlovexue/article/details/82378389
--------------------------------------------------------------------------------------