Dump Import Oracle 11g Memo

Connect to: Oracle Database 11g Express Edition Release 11.2.0.2.0-64bit Production
The main Table "test" was successfully loaded/unloaded. " Sys_import_full_02 "
Start "Test". " Sys_import_full_02 ": test/******** directory=dpdir dumpfile=test_14.dmp full=y;
Working with Object Types table_export/table/table
Working with Object Types Table_export/table/table_data
Ora-02374:conversion Error loading table "test". " T_outbody "
Ora-12899:value too large for column descrition (actual:44, maximum:40)

Ora-02372:data for row:descrition:0x ' baf3cad3beb528d7f32cb5a5c7fac2ca2ccad6d5dbb5fe2cc0 '

Ora-02374:conversion Error loading table "test". " T_outbody "
Ora-12899:value too large for column descrition (actual:41, maximum:40)

Ora-02372:data for row:descrition:0x ' bbfad3cdc2cbd0be28cede3cc3dcb7e2c8a6484230302d3134 '

Import> exit

C:\users\aibair>sqlplus/nolog

Sql*plus:release 11.2.0.2.0 Production on Wednesday October 14 16:26:08 2015

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

Sql> Conn/as SYSDBA
is connected.
sql> shutdown immediate;
The database is closed.
The database has been uninstalled.
The ORACLE routine has been closed.
sql> startup Mount;
The ORACLE routine has been started.

Total System Global area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 687866800 bytes
Database buffers 373293056 bytes
Redo buffers 5517312 bytes
The database is loaded.
Sql> alter system enable restricted session;

The system has changed.

Sql> alter system set job_queue_processes=0;

The system has changed.

Sql> alter system set aq_tm_processes=0;

The system has changed.

sql> ALTER DATABASE open;

The database has changed.

Sql> ALTER DATABASE character set ZHS16GBK;
ALTER DATABASE character Set ZHS16GBK
*
An error occurred on line 1th:
ORA-12712: The new character set must be a superset of the old character set

Sql> ALTER DATABASE character set Internal_use ZHS16GBK;

The database has changed.

sql> Shutdow Immediate;
The database is closed.
The database has been uninstalled.
The ORACLE routine has been closed.
Sql> startup;
The ORACLE routine has been started.

Total System Global area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 687866800 bytes
Database buffers 373293056 bytes
Redo buffers 5517312 bytes
The database is loaded.
The database is already open.
Sql>
Sql> drop tablespace testdb including contents and datafiles cascade constraints;

Table space has been deleted.

sql> Create tablespace testdb datafile ' C:\test\testdb. DBF ' size 7024m autoextend on next 1000m UNIFORM size 128k;

The tablespace has been created.

Sql> Eixt;
sp2-0042: Unknown Command "Eixt"-the remaining rows are ignored.
Sql> exit
Disconnect from Oracle Database 11g Express Edition Release 11.2.0.2.0-64bit Production

C:\USERS\AIBAIR>IMPDP Directory=dpdir dumpfile=test_14.dmp full=y;

Import:release 11.2.0.2.0-production on Wednesday October 14 16:37:16 2015

Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.

User name: Test
Password:

Connect to: Oracle Database 11g Express Edition Release 11.2.0.2.0-64bit Production
The main Table "test" was successfully loaded/unloaded. " Sys_import_full_03 "
Start "Test". " Sys_import_full_03 ": test/******** directory=dpdir dumpfile=test_14.dmp full=y;
Working with Object Types table_export/table/table
Working with Object Types Table_export/table/table_data
. . "Test" was imported. " T_outbody "1.305 GB 25042554 Line
ORA-31693: Table Data Object "test". " C_processhead "could not be loaded/unloaded and skipped with the following error:
ORA-02354: Error exporting/Importing data
ORA-39776: Load the table "test". " C_processhead "Fatal Direct path API error
ORA-12953: request exceeds the maximum allowable database size by one GB
ORA-31693: Table Data Object "test". " C_processbody "could not be loaded/unloaded and skipped with the following error:
ORA-02354: Error exporting/Importing data
ORA-39776: Load the table "test". " C_processbody "Fatal Direct path API error
ORA-12953: request exceeds the maximum allowable database size by one GB

Dump Import Oracle 11g Memo