expdb 操做方法 - 关系型数据库

expdp system/oracle directory=DB_BAK dumpfile=zhzy.dmp schemas=zhzy

expdp system/SYSTEM directory=DB_BAK dumpfile=sde__zyyh_zhzy.dmp schemas=(sde,zyyh,zhzy) logfile=expdp_all.log

expdp system/SYSTEM directory=DB_BAK dumpfile=sde__zyyh_zhzy.dmp schemas=(sde,zyyh,zhzy) logfile=expdp_all.log

expdp system/SYSTEM directory=DB_BAK dumpfile=zyyh.dmp schemas=zyyh logfile=expdp_zyyh.log

expdp system/SYSTEM@ZGDB_TEST directory=DB_BAK dumpfile=zyyh.dmp schemas=zyyh logfile=expdp_zyyh.log

=======================================================================================================================================================

impdp zhzy/zhzy@cqdb directory=DB_BAK dumpfile=ZHZY20140304.DMP schemas=zhzy logfile=impdp_zhzy.log

impdp system/oracle@zgdb_test directory=DB_BAK dumpfile=sde__zyyh_zhzy.DMP schemas=sde logfile=impdp_sde.log

impdp system/oracle@zgdb_test directory=DB_BAK dumpfile=zyyh.DMP schemas=zyyh logfile=impdp_zyyh.log

==================================================================================================================================================================

expdp zhzy/zhzy directory=DB_BAK dumpfile=zhzy.dmp schemas=(zhzy) logfile=expdp_zhzy.log

impdp system/oracle@zgdb directory=DB_BAK dumpfile=zhzy.DMP schemas=(zhzy) logfile=impdp_zhzy.log

导入单个表：impdp zyyh/zyyh directory=DB_BAK DUMPFILE=SDE_ZYYH_ZHZY.DMP TABLES= (res_inspect_model,RES_INSPECT_MODEL_OTHER_PRO)

=========================================================================================================================================

select * from dba_directories;

1、创建DIRECTORY

create directory db_bak as ’D:/DB_BAK’;

2、授权

Grant read,write on directory db_bak to system;

–查看目录及权限

SELECT privilege, directory_name, DIRECTORY_PATH FROM user_tab_privs t, all_directories d

WHERE t.table_name(+) = d.directory_name ORDER BY 2, 1;

drop directory db_bak;

=================================

ORA-39082: 对象类型 PACKAGE_BODY:”SDE”.”PINFO_UTIL” 已创建, 但带有编译警告

ORA-39082: 对象类型 PACKAGE_BODY:”SDE”.”LOCK_UTIL” 已创建, 但带有编译警告

ORA-39082: 对象类型 PACKAGE_BODY:”SDE”.”VERSION_USER_DDL” 已创建

解决方式：

以sys as sysdba登陆到sqlplus,然后执行

Grant execute on dbms_pipe to sde;

Grant execute on dbms_lock to sde;

========================================

select table_name, ’alter table ’||table_name||’ allocate extent;’ from user_tables where num_rows=0;

select table_name,’alter table ’ || table_name || ’allocate extent size 64K;’

from user_tables t where table_name not in        (select segment_name from user_segments where segment_type = ’TABLE’)

order by 1;