Transport tablespace Set (iii)----Transport single tablespace

Source-side Character set and endian view:
Sql> Select Userenv (' language ') from dual;
USERENV (' LANGUAGE ')

Simplified Chinese_china. Zhs16gbk
Sql> SELECT D.platform_name, Endian_format
2 from V T RAN S P ORT ABL EP LAT F ORM TP,V DATABASE D
3 WHERE TP. Platform_name = D.platform_name;
Platform_name Endian_format

Microsoft Windows IA (32-bit) Little
On the target side character set with endian view:
Sql> Select Userenv (' language ') from dual;
USERENV (' LANGUAGE ')

American_america. Zhs16gbk
SELECT D.platform_name, Endian_format
From V T RAN S P ORT ABL EP LAT F ORM TP,V DATABASE D
3 WHERE TP. Platform_name = D.platform_name;
Platform_name Endian_format

Linux 64-bit for AMD Little
From the above information can be seen note set are Zhs16gbk,endian types are little, in line with Transpor tablespace set requirements.

The following content is operated on the source side:

sql> Create tablespace Keke datafile ' C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\keke_01.dbf ' size 10M autoextend on;
The tablespace has been created.
Sql> create user Keke identified by Oracle default Tablespace Keke;
The user has created.
Sql> Grant CONNECT,RESOURCE,DBA to Keke;
Authorization is successful.
Sql> Conn Keke/oracle
is connected.
Sql> CREATE TABLE Keke as SELECT * from Dba_objects;
The table is created.
Sql> commit;
Submit complete.
Sql> Conn/as SYSDBA
is connected.
sql> exec dbms_tts.transport_set_check (' KEKE ', TRUE);
The PL/SQL process has completed successfully.
Sql> select * from Transport_set_violations;
Row not selected
Sql> Select Tablespace_name,status from dba_tablespaces where tablespace_name= ' KEKE ';
Tablespace_name STATUS

KEKE ONLINE
has selected 10 rows.
sql>
sql> alter tablespace Keke Read only; The
table space has changed.
C:\Documents and SETTINGS\ADMINISTRATOR>EXPDP system/oracle directory=mydump dumpfile=keke.dmp logfi
le= Keke.log Transport_tablespaces=keke
Export:release 10.2.0.1.0-production on Monday, 09 September, 13:28:18
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
with the partitioning, OLAP and Data M Ining options
Start SYSTEM. " Sys_export_transportable_01 ": system/ * * directory=mydump dumpfile=keke.dmp log
file= Keke.log Transport_tablespaces=keke
Handles object types TRANSPORTABLE_EXPORT/PLUGTS_BLK
handles the type of objects transportable_export/ Table
Processing Object Type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
has successfully loaded/unloaded the main table "SYSTEM". " Sys_export_transportable_01 "

SYSTEM. The sys_export_transportable_01 dump file set is:
C:\MYDMP\KEKE. DMP
Job "SYSTEM". " Sys_export_transportable_01 "was successfully completed at 13:28:33

The following content operates on the target side:

Sql> create user Keke identified by Keke;
User created.
[Email protected] ~]$ IMPDP system/oracle Dumpfile=keke. DMP directory=dmp transport_datafiles=/test/mydump/keke_01.dbf
Import:release 10.2.0.1.0-64bit Production on Monday, September, 2013 13:38:39
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 "SYSTEM". " Sys_import_transportable_01 "Successfully loaded/unloaded
Starting "SYSTEM". " Sys_import_transportable_01 ": system/* * Dumpfile=keke. DMP directory=dmp

Transport_datafiles=/test/mydump/keke_01.dbf
Processing Object Type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing Object Type Transportable_export/table
Processing Object Type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
The Job "SYSTEM". Sys_import_transportable_01 "successfully completed at 13:39:12
Sql> Select Tablespace_name,status from dba_tablespaces where tablespace_name= ' KEKE ';
Tablespace_name STATUS

KEKE READ only
Sql> alter Tablespace Keke Read write;
Tablespace altered.
Sql> Select Tablespace_name,status from dba_tablespaces where tablespace_name= ' KEKE ';
Tablespace_name STATUS

KEKE ONLINE
7 rows selected.
sql> alter user Keke identified by Oracle default Tablespace Keke; # # # # #由于权限及密码保存在oracle数据字典里, so these letters

Need to be updated.
User altered.
Sql> Conn Keke/oracle
Connected.
Sql> Select COUNT (*) from Keke;
COUNT (*)

 49781

End

Transport tablespace Set (iii)----Transport single tablespace