Shulou(Shulou.com)06/01 Report--

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

Import a single table: 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. Create a DIRECTORY

Create directory db_bak as 'DRAPUDULAGDBANGBAK'

2. Authorization

Grant read,write on directory db_bak to system

-- View directories and permissions

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: object type PACKAGE_BODY: "SDE". "PINFO_UTIL" has been created with compilation warnings

ORA-39082: object type PACKAGE_BODY: "SDE". "LOCK_UTIL" has been created with compilation warnings

ORA-39082: object type PACKAGE_BODY: "SDE". "VERSION_USER_DDL" has been created

Solution:

Log in to sqlplus as sys as sysdba and execute

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.