Test the table space function for Oracle transmission (including detailed procedures)

Recently, Oracle data migration was conducted. There was an article about migration ideas. Here we will continue the specific test. The topic is about table space transmission. Read more: Oracle transmission tablespace

Recently, Oracle data migration was conducted. There was an article about migration ideas. Here we will continue the specific test. The topic is about table space transmission. Read more: Oracle transmission tablespace

Recently, Oracle data migration was conducted. There was an article about migration ideas. Here we will continue to perform specific tests. The topic is about table space transmission.

Related reading:

Oracle transfer tablespace

Upgrade Oracle 9i to 10 Gb using a writable tablespace

Summary of Oracle transmission tablespace migration data

Exp/expdp transfers tablespaces and rman convert for fast migration of large data volumes

1. Export tablespace on the source server
Source server: 10.1.122.55
Target Server: 10.1.122.54

0. Set character sets
Note: If the character set is not set here, an error will be reported during import. For details, see the end of the article.
SUSE11sp2 :~ # Export LANG = AMERICAN_AMERICA.AL32UTF8
Suse11sp2: ~> Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Suse11sp2: ~> Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Wed Jul 24 14:45:47 2013

Copyright (c) 1982,201 1, Oracle. All rights reserved.

1. Prepare the tablespace to be transmitted
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace aaa datafile '/oracle/oradata/aa. dbf' size 100 M;

Tablespace created.

SQL> CREATE USER aaa IDENTIFIED BY aaa
Default tablespace aaa
Temporary tablespace temp; 2 3

User created.

SQL> GRANT CONNECT, RESOURCE TO aaa;

Grant succeeded.

SQL> REVOKE UNLIMITED TABLESPACE FROM aaa;

Revoke succeeded.

SQL> ALTER USER aaa QUOTA UNLIMITED ON aaa;

User altered.

SQL> conn aaa/aaa;
Connected.
SQL> create table a1 (id varchar2 (10), name varchar2 (20 ));

Table created.

SQL> insert into a1 values ('01', 'lurou ');

1 row created.

SQL> insert into a1 values ('02', 'Hello, DBA! ');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> select * from a1;

ID NAME
------------------------------
01 lurou
02 hello, DBA!

SQL>
SQL>
SQL>

2. Pre-transmission check
SQL> conn/as sysdba
Connected.
SQL>
SQL> execute sys. dbms_tts.transport_set_check ('aaa', true );

PL/SQL procedure successfully completed.

SQL>
SQL> select * from sys. transport_set_violations;

No rows selected

SQL>

3. Set the tablespace to read-only.
SQL>
SQL> alter tablespace aaa read only;

Tablespace altered.

SQL>
SQL> commit;

Commit complete.

SQL>