An empty table cannot be exported using exp in Oracle11g. expdp and impdp can be used for heterogeneous platform migration.

In Oracle11g, exp cannot export empty tables by default. Using traditional exp, imp Migration to heterogeneous platform databases is troublesome. However, you can use expdp and impdp for migration.

In Oracle 11g, exp cannot export empty tables by default. Using traditional exp, imp Migration to heterogeneous platform databases is troublesome. However, you can use expdp and impdp for migration.

In Oracle 11g, exp cannot export empty tables by default. Using traditional exp, imp Migration to heterogeneous platform databases is troublesome. However, you can use expdp and impdp for migration.

Migrate the 64-bit windows 2003 Oracle11gR2 database to 64-bit Linux RedHat Enterprise 5. You can use expdp and impdp for data migration.

For example, if Windows is server A, Linux is server B, and database users are test, data of server A is migrated to server B.

On server:

1,

SQL> create directory expdp_dir as 'd: \ mzl \ backup ';

SQL> grant read, write on directory expdp_dir to test;

2. Create the Directory D: \ mzl \ backup in the windows directory

3. Export in the doscommand window:

Expdp test/test DIRECTORY = expdp_dir DUMPFILE = test. dmp logfile = testexpdp. log

Operate on server B:

4. SQL> create directory impdp_dir as '/home/oracle/impdp_dir ';

SQL> grant read, write on directory impdp_dir to test;

1. The/home/oracle/impdp_dir directory must be available in the system. The impdp_dir directory must have read and write permissions.

(Chmod 777 impdp_dir)

5. Use ftp to upload the data exported by server A to the/home/oracle/impdp_dir directory of server B.

Configure the server name of server B in server A and import data to server.

6. Export in the doscommand window:

Imppdp test/test @ B _database DIRECTORY = impdp_dir DUMPFILE = test. dmp logfile = testimpdp. log

(Note the case sensitivity. If test. dmp is capitalized in linux, it must be changed to uppercase. Linux case sensitive)