oracle(imp导入)
- 格式:docx
- 大小:13.92 KB
- 文档页数:2
(1)sqlplus sys as sysdba
(2)Create directory dp01 as ‘d:\data\’(导入的dmp文件放在此处)
(3)Grant write,read on directory dp01 to system
(4)Select name from v$tablespace
(5)Select username from dba_users
(6)Drop user chisdb_dev cascade(报错)
(7)Exit;
(8)Lsnrctl stop
(9)Sqlplus sys as sysdba
(10)Shutdown immediate
(11)Startup
(12)Drop user chisdb_dev cascade
(13)Select tablespace_name ,sum(bytes)/1024/1024/1024 gb from dba_data_files group by
tablespace_name
(14)Select name from v$datafiles
(15)Col tablespace_name for a15
(16)Select tablespace_name ,sum(bytes)/1024/1024/1024 gb,sum(maxbytes)/1024/1024/1024
maxgb from dba_data_files group by tablespace_name
(17)Create tablespace chisdb_data datafile ‘d:\oracle\chisdb_data01.dbf’ size 4g autoextend on
next 100m
(18)Alter tablespace chisdb_data add datafile ‘d:\oracle \chisdb_data02.dbf’ size 4g
autoextend on next 100m(一共创建6个)
(19)
(20)Alter tablespace cisdb_date add datafile ‘d:\cisdb_data01.dbf size 4g autoextend on next
100m’,’d:\cisdb_data02.dbf size 4g autoextend on next 100m’,...(创建6个dbf)
(21)Create temporary tablespace chisdb_temp tempfile ‘d:\chisdb_temp.dbf’ size 100m
autoextend on next 50m
(22)exit
(23)Impdp system/Founder123 directory=dp01 schemas=chisdb_dev,cisdb_dev
dumpfile=expdp_orcl1_20180314_020001_01.dmp,expdp_orcl1_20180314_020001_02.dmp,exp
dp_orcl1_20180314_020001_03.dmp,expdp_orcl1_20180314_020001_04.dmp,expdp_orcl1_201
80314_020001_05.dmp,expdp_orcl1_20180314_020001_06.dmp,expdp_orcl1_20180314_02000
1_07.dmp,expdp_orcl1_20180314_020001_08.dmp,expdp_orcl1_20180314_020001_09.dmp,ex
pdp_orcl1_20180314_020001_10.dmp,expdp_orcl1_20180314_020001_11.dmp,expdp_orcl1_20
180314_020001_12.dmp logfile=impdp_orclcs2_20180314_040002.log parallel=4
导出:
在按SCHEMA导出的基础上,指定filesize参数,并且dumpfile参数指定存储导出数据的文件名时,添加%U参例如:
expdp xxx/xxx directory=xxx dumpfile=expdp_xxx_%U.dmp filesize=1G schemas=xx compression=all logfile=xxx.log
以上命令实现导出指定SCHEMA中的对象导出,导出的文件名形如expdp_xxx_%U.dmp,每个文件最大1g
在按SCHEMA导出的基础上,指定filesize参数,并且dumpfile参数指定存储导出数据的文件名时,添加%U参例如:
expdp xxx/xxx directory=xxx dumpfile=expdp_xxx_%U.dmp filesize=1compression=all logfile=xxG schem 以上命令实现导出指定SCHEMA中的对象导出,导出的文件名形如expdp_xxx_%U.dmp,每个文件最大1g.