gistfile1.txt

Oracleのスキーマをコピーするスクリプト
（実際に動作するかは試していない）

create user [DEST_SCHEMA] identified by [DEST_SCHEMA] default tablespace USERS temporary tablespace TEMP profile DEFAULT;
grant create session,create table,create view,create sequence,create trigger,create synonym,unlimited tablespace to [DEST_SCHEMA];

expdp system/manager SCHEMAS=[SRC_SCHEMA] DIRECTORY=DATA_PUMP_DIR DUMPFILE=[SRC_SCHEMA].dmp
impdp system/manager DIRECTORY=DATA_PUMP_DIR DUMPFILE=[SRC_SCHEMA].dmp REMAP_SCHEMA=[SRC_SCHEMA]:[DEST_SCHEMA]