SQL> conn /as sysdba
已连接。
SQL> select property_value from database_properties where property_name='NLS_CHARACTERSET';
PROPERTY_VALUE
---------------
AL32UTF8
SQL> create tablespace tbs_transport datafile 'E:\oracle\product\10.2.0\oradata\winorcl2\tbs_transport01.dbf' size 10M;
表空间已创建。
SQL> create table hr.t04311_trans (a number) tablespace tbs_transport;
表已创建。
SQL> insert into hr.t04311_trans values (1000);
已创建1 行。
SQL> commit;
提交完成。
SQL> create directory dir01 as 'e:\data';
目录已创建。
SQL> alter tablespace tbs_transport read only;
表空间已更改。
C:\>expdp 'sys/123456 as sysdba' directory=dir01 dumpfile=1.dmp transport_tablespaces=tbs_transport
Export: Release 10.2.0.1.0 - Production on 星期三, 03 8月, 2011 13:39:08
Copyright (c) 2003, 2005, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
启动"SYS"."SYS_EXPORT_TRANSPORTABLE_01": 'sys/******** AS SYSDBA' didirectory=di
r01 dumpfile=1.dmp transport_tablespaces=tbs_transport
处理对象类型TRANSPORTABLE_EXPORT/PLUGTS_BLK
处理对象类型TRANSPORTABLE_EXPORT/TABLE
处理对象类型TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
已成功加载/卸载了主表"SYS"."SYS_EXPORT_TRANSPORTABLE_01"
******************************************************************************
SYS.SYS_EXPORT_TRANSPORTABLE_01 的转储文件集为:
E:\DATA\1.DMP
作业"SYS"."SYS_EXPORT_TRANSPORTABLE_01" 已于13:40:13 成功完成
C:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三8月3 13:42:02 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
已连接。
SQL> alter tablespace tbs_transport read write;
表空间已更改。
目的端：
[root@rhel6 ~]# mount -t cifs -o username=yang //192.168.50.195/data /mnt
Password:
[root@rhel6 ~]# ls /mnt
1.DMP export.log TBS_TRANSPORT01.DBF
[oracle@rhel6 ~]$ cp /mnt/* /home/oracle/data/
[oracle@rhel6 ~]$ ls /home/oracle/data/
1.dmp export.log tbs_transport01.dbf
[oracle@rhel6 ~]$ cp /home/oracle/data/tbs_transport01.dbf /u01/app/oradata/ora10g/
[oracle@rhel6 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 3 13:50:59 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> create directory dir01 as '/home/oracle/data';
Directory created.
[oracle@rhel6 data]$ impdp \'sys/123456 as sysdba\' directory=dir01 dumpfile=1.dmp transport_datafiles='/u01/app/oradata/ora10g/tbs_transport01.dbf'
Import: Release 10.2.0.1.0 - 64bit Production on Wednesday, 03 August, 2011 14:16:46
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01": 'sys/******** AS SYSDBA' directory=dir01 dumpfile=1.dmp transport_datafiles=/u01/app/oradata/ora10g/tbs_transport01.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYS"."SYS_IMPORT_TRANSPORTABLE