Databases Reference
In-Depth Information
The next step is to set this tablespace in read-only mode and have the
metadata exported:
SQL> alter tablespace MIGRATE_TO_UNIX_TS read only;
SQL> create directory DATA_PUMP_DIR
2* as 'C:\Oracle\product\10.1.0\admin\alpha\dpdump';
SQL> grant read,write on directory data_pump_dir to public;
At the OS prompt the export Data Pump utility is invoked to generate a dump file
containing the metadata required to perform the tablespace transportation:
C:\>expdp system/oracle dumpfile=MigrateToLinux directory=DATA_PUMP_DIR
transport_tablespaces=MIGRATE_TO_UNIX_TS
Export: Release 10.1.0.5.0 - Production on Tuesday, 28 October, 2008 2:57
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 -
Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/********
dumpfile=MigrateToUnix direct
ory=DATA_PUMP_DIR transport_tablespaces=MIGRATE_TO_UNIX_TS
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/TTE_POSTINST/PLUGTS_BLK
Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/
unloaded
*************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
C:\ORACLE\PRODUCT\10.1.0\ADMIN\ALPHA\DPDUMP\MIGRATETOUNIX.DMP
Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at
02:58
 
Search WWH ::




Custom Search