oracle10g的oe表,关于Oracle10g跨平台传输表空间

3.导出要传输的表空间

$ pwd

/opt/oracle

$ cd dpdata

$ ls

$ expdp eygle/eygle dumpfile=trans.dmp directory=dpdata transport_tablespace=trans

LRM-00101: unknown parameter name 'transport_tablespace'

$ expdp eygle/eygle dumpfile=trans.dmp directory=dpdata TRANSPORT_TABLESPACES=trans

Export: Release 10.1.0.2.0 - 64bit Production on Tuesday, 27 April, 2004 14:07

Copyright (c) 2003, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Starting "EYGLE"."SYS_EXPORT_TRANSPORTABLE_01":  eygle/******** dumpfile=trans.dmp directory=dpdata TRANSPORT_TABLESPACES=trans

ORA-39123: Data Pump transportable tablespace job aborted

ORA-29335: tablespace 'TRANS' is not read only

Job "EYGLE"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 14:08

注意:传输表空间必须置为只读状态

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 27 14:08:13 2004

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> alter tablespace trans read only;

Tablespace altered.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

$ expdp eygle/eygle dumpfile=trans.dmp directory=dpdata TRANSPORT_TABLESPACES=trans

Export: Release 10.1.0.2.0 - 64bit Production on Tuesday, 27 April, 2004 14:08

Copyright (c) 2003, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Starting "EYGLE"."SYS_EXPORT_TRANSPORTABLE_01":  eygle/******** dumpfile=trans.dmp directory=dpdata TRANSPORT_TABLESPACES=trans

Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

Processing object type TRANSPORTABLE_EXPORT/TABLE

Processing object type TRANSPORTABLE_EXPORT/TTE_POSTINST/PLUGTS_BLK

Master table "EYGLE"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for EYGLE.SYS_EXPORT_TRANSPORTABLE_01 is:

/opt/oracle/dpdata/trans.dmp

Job "EYGLE"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 14:09