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;