How to import 10 Gb dmp from oracle to 9i

Oracle 10 Gb dmp how to import 9i Problem description: How to migrate database objects in oracle 10 Gb to 9i. the 10g and 9i servers are respectively built on two machines in the LAN and can access each other. problem Analysis: Some information has been found online, indicating that it is not feasible to import 10 Gb exported dmp files to 9i. only 9i can be imported to 10 Gb. if you want to import 10 Gb of data to 9i, you can configure a tnsnames on 9i server first. ora string used to access the 10 Gb database. Then, use the exp Command provided by the 9i client on the 9i server to export the database, and use the imp command to import the database. the following error may be reported when 10 Gb of exported dmp is imported to 9i. when the 9i client is installed to run the Import command, the SQL code Import started on 14:17:13 E: \ oracle \ ora92 \ bin \ IMP will be reported. EXE log = C: \ DOCUME ~ 1 \ wangzh \ LOCALS ~ 1 \ Temp \ plsimp. log file = D: \ yusj \ dqjz \ dqjz20130308.dmp userid = dqjz/dqjz @ ORCL buffer = 30720 commit = no full = yes grants = yes ignore = yes indexes = yes rows = yes show = no constraints = yes connect: oracle9i Enterprise Edition Release 9.2.0.1.0-Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0-Production IMP-00010: Invalid export file, title Verification Failed IMP-00000: import finished on failed 14:17:13 the SQL code Import started on 11:13:02 D: \ oracle \ product \ 10.2.0 \ db_1 \ bin \ imp.exe log = C: \ DOCUME ~ 1 \ ADMINI ~ 1 \ LOCALS ~ 1 \ Temp \ plsimp. log file = C: \ dqjz201308.dmp userid = dqjz/dqjz @ ORCL_232 buffer = 30720 commit = no full = yes grants = yes ignore = yes indexes = yes rows = yes show = no constraints = yes IMP-00058: ORACLE error 6550 ORA-06550: 1st rows, 33rd columns: PLS-00302: Required description 'set _ no_outlines' component ORA-06550: 1st rows, 7th columns: PL/SQL: Statement ignored IMP-00000: import finished on 11:13:03 failed to end problem solving: 1. configure tnsnames on the machine where the 9i client is installed. ora to ensure normal connection to the 10 Gb database. 2. before executing the exp command on a machine installed with a 9i client to export the dmp file, you need to solve the problem by supporting BLOB. If the table to be exported contains BLOB fields, so when executing the exp command will report EXP-00003 error, solution: need to first connect to 10 database, log on with sys user, find exu9tne view (view), back up. run the following SQL statement: CREATE OR REPLACE VIEW SYS. EXU9TNE (tsno, fileno, blockno, length) as select ts #, segfile #, segblock #, length FROM sys. uet $ WHERE ext # = 1 union all select "TSNO", "FILENO", "BLOCKNO", "LENGTH" from sys. EXU9TNEB; note that after the data is exported, a view must be restored to the initial value. my local initial value is: SQL code CREATE OR REPLACE VIEW SYS. EXU9TNE (tsno, fileno, blockno, length) as select ts #, segfile #, segblock #, length FROM sys. uet $ WHERE ext # = 1; 3. execute the imp command on the machine where the 9i client is installed to complete the import operation (note that the corresponding tablespace and user must be created before the import ).