Data Pump Export ディレクトリオブジェクトの参照 拡張子:txtvbswsfjsphpjavahtmlutf8sjis SELECT * FROM ALL_DIRECTORIES expdp LIGHTBOX/LIGHTBOX@vpc-028b/orcl parfile=LIGHTBOX_ALL.txt 拡張子:txtvbswsfjsphpjavahtmlutf8sjis DIRECTORY=R205 DUMPFILE=LIGHTBOX_ALL.dmp SCHEMAS=LIGHTBOX impdp LIGHTBOX/LIGHTBOX@vpc-028b/orcl parfile=LIGHRBOX_ALL_CHECK.txt 拡張子:txtvbswsfjsphpjavahtmlutf8sjis DIRECTORY=R205 DUMPFILE=LIGHTBOX_ALL.dmp SQLFILE=LIGHTBOX_ALL.SQL TRANSFORM=SEGMENT_ATTRIBUTES:n
SELECT * FROM ALL_DIRECTORIES
DIRECTORY=R205 DUMPFILE=LIGHTBOX_ALL.dmp SCHEMAS=LIGHTBOX
DIRECTORY=R205 DUMPFILE=LIGHTBOX_ALL.dmp SQLFILE=LIGHTBOX_ALL.SQL TRANSFORM=SEGMENT_ATTRIBUTES:n
expdp LIGHTBOX/LIGHTBOX@vpc-028b/orcl parfile=LIGHTBOX_TBL01.txt 拡張子:txtvbswsfjsphpjavahtmlutf8sjis DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL01.dmp TABLES=商% impdp LIGHTBOX/LIGHTBOX@vpc-028b/orcl parfile=LIGHRBOX_TBL01_CHECK.txt 拡張子:txtvbswsfjsphpjavahtmlutf8sjis DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL01.DMP SQLFILE=LIGHTBOX_TBL01.SQL TRANSFORM=SEGMENT_ATTRIBUTES:n
DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL01.dmp TABLES=商%
DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL01.DMP SQLFILE=LIGHTBOX_TBL01.SQL TRANSFORM=SEGMENT_ATTRIBUTES:n
expdp LIGHTBOX/LIGHTBOX@vpc-028b/orcl parfile=LIGHTBOX_TBL02.txt 拡張子:txtvbswsfjsphpjavahtmlutf8sjis DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL02.dmp SCHEMAS=LIGHTBOX INCLUDE=TABLE:"LIKE '商%'",PROCEDURE または 拡張子:txtvbswsfjsphpjavahtmlutf8sjis DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL02.dmp SCHEMAS=LIGHTBOX INCLUDE=TABLE:"LIKE '商%'" INCLUDE=PROCEDURE impdp LIGHTBOX/LIGHTBOX@vpc-028b/orcl parfile=LIGHRBOX_TBL02_CHECK.txt 拡張子:txtvbswsfjsphpjavahtmlutf8sjis DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL02.DMP SQLFILE=LIGHTBOX_TBL02.SQL TRANSFORM=SEGMENT_ATTRIBUTES:n
DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL02.dmp SCHEMAS=LIGHTBOX INCLUDE=TABLE:"LIKE '商%'",PROCEDURE
DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL02.dmp SCHEMAS=LIGHTBOX INCLUDE=TABLE:"LIKE '商%'" INCLUDE=PROCEDURE
DIRECTORY=R205 DUMPFILE=LIGHTBOX_TBL02.DMP SQLFILE=LIGHTBOX_TBL02.SQL TRANSFORM=SEGMENT_ATTRIBUTES:n