expdp/impdp

select owner,count(*) from all_tables group by owner order by owner;

-------------------------------------------------------------------
set lines 128
set pages 999

select * from dba_datapump_jobs;
select * from dba_datapump_sessions;

impdp kiban_sys/kiban_sys attach='SYS_IMPORT_SCHEMA_01'
$ Import> stop_job=immediate

impdp kiban_sys/kiban_sys attach=SYS_IMPORT_SCHEMA_01
stop_job=immediate

sqlplus kiban_sys/kiban_sys

expdp U0047/U0047 attach=SYS_IMPORT_FULL_01

select owner,count(*) from all_tables group by owner order by owner;

-------------------------------------------------------------------

set lines 128

set pages 999

select * from dba_datapump_jobs;

select * from dba_datapump_sessions;

impdp kiban_sys/kiban_sys attach='SYS_IMPORT_SCHEMA_01'

$ Import> stop_job=immediate

impdp kiban_sys/kiban_sys attach=SYS_IMPORT_SCHEMA_01

stop_job=immediate

sqlplus kiban_sys/kiban_sys

expdp U0047/U0047 attach=SYS_IMPORT_FULL_01

テンプレートサイト

－サンプル、テンプレート－

コメントを残す