I tried to use the transportable tablespace feature to transport a tablespace from a v9.0.1 DB to a v8.1.7 DB and ran into the same issue (IMP-00010).

1) On v9.0.1 export the metadata (using v9's exp)
2) On v8.1.7 import the metadata (using v8's imp)
-- Import failed with IMP-00010
3) On v8.1.7 export via net8 (connect sys/pw@v9db as sysdba)
-- Export failed due to export view inconsistencies
4) On v9.0.1 run catexp.sql (copied from v8.1.7)
5) On v8.1.7 repeat step 3
-- Export died with a core dump (not IMP-00010)

Unfortunately, even when I ran v8's catexp.sql in the v9 DB I was still not able to run the v8 export against the v9 DB.
The fact that this was a metadata export may account for it not working. I didn't try any other exp/imp combinations.

As regards to TTS you also have to follow the DB Version and OS version.

Quote: You can run catexp7 in the 8i instance and then use the 7.x export tool over sqlnet to perform the
export.

We Know this script creates a bunch of views which the
version 7 export utility needs to see before it can function properly.

Is it required to run any other script after completing the export to bring back the 8i Instance to allow the use of 8.x export tool.

Hi Tom,
Is it possible to export data created using EXP ver8.1.7 from 8.1.7 database into 9.2 database using EXP 9.2.

I have tons of data in the server machine (oracle 8.1.7). My plan is to create the dump file, write it onto a couple of CD's, take home, and export them into 9.2 ver database in my personal computer. (ie No NET 8 connection is available).

Thanks Tom
regars

Praveen

Hello Tom,

I have installed Designer9i and trying to create a repository in 8.1.6 database and ending up with this error:

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully

*************
Are heighr version imp utility is not compitable to take an import of lower version database.

What could be solution in my case.

"I have installed Designer9i and trying to create a repository in 8.1.6 database..."

Why would you even try that? Have you read the installation guide?

- Mark

Tom,
Regarding...
"you need to use the 816 EXPORT against the 9i database to create a dmp file that the 816 IMPORT tool can read" mentioned above,
could you please let me know the name of the executable in 9.2 to do export for 8.1.6?
Thanks.

Hi Tom,
I looked in the 9.2.0.4 <xx>/rdbms/admin/ and found there ate two catexp.sql and catexp7.sql scripts. This is the database I have to take an export from and import into a 8.1.5 database where also I find the same two above mentioned files.
Now from all the previous threads I have gathered that for backward compatiblity thingy I have to run a 8.1.5 version on 9.2.0.4. But the same files exist in both databases and which one should I run in 9.2.0.4 ???
Do I take the 8.1.5 one across and run in9.2.0.4 and then what???
Please explain according to the two scenerios:-
a) if there is a network connection between the two databases.
b) there is no network connection between the two separate databases.

Basically all I have found is useful information about how export/import should work between versions but no where does anyone actually tell where to find what and how to do it.
God help if some one reads the oracle docs and tries to figure it out.

Thanks much in advance Tom.
Regards,RD.

Hi Tom,

I did as was told and the following problems are cropping up:- Please guide,

C:\>exp system/abcd@oraphase10

Export: Release 8.1.5.0.0 - Production on Thu Aug 5 09:22:07 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Enter array fetch buffer size: 4096 > 10000

Export file: EXPDAT.DMP > cms.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) > cmsdev10

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CMSDEV10
. exporting object type definitions for user CMSDEV10
About to export CMSDEV10's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CMSDEV10's tables via Conventional Path ...
. . exporting table ACT 720 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table ADDRESS_TYPE 7 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table ADOPTION_APPLICATION 6 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table ALCOHOL_DRUG_ADDICTION_APP 1 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table ALERT 2628 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table ALERT_TYPE 0 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table APPEALED_CASE_TYPE 5 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table APPEAL_FILING_PARTY_TYPE 3 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table APPLICATION 11375 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table APPLICATION_CASE_EVENT

Regards,
RD

Hi Tom,

I did as was told and the following problems are cropping up:- Please guide,

C:\>exp system/abcd@oraphase10

Export: Release 8.1.5.0.0 - Production on Thu Aug 5 09:22:07 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Enter array fetch buffer size: 4096 > 10000

Export file: EXPDAT.DMP > cms.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) > cmsdev10

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CMSDEV10
. exporting object type definitions for user CMSDEV10
About to export CMSDEV10's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CMSDEV10's tables via Conventional Path ...
. . exporting table ACT 720 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table ADDRESS_TYPE 7 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table ADOPTION_APPLICATION 6 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table ALCOHOL_DRUG_ADDICTION_APP 1 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table ALERT 2628 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table ALERT_TYPE 0 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table APPEALED_CASE_TYPE 5 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table APPEAL_FILING_PARTY_TYPE 3 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table APPLICATION 11375 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: "ENDPOINT": invalid identifier
. . exporting table APPLICATION_CASE_EVENT


As one can see I did use the 8.1.5 Export utility against the 9i database but am getting error,
What am I really missing here????


Regards,
RD

I have exaclty the same problem.
Any sugestions?


Thank You
R.P.

The export gives me the folowing errors:

. . a exportar tabela PESSOAS
EXP-00008: Encontrado erro ORACLE 904
ORA-00904: "PARTNUM": invalid identifier

. . a exportar tabela STAFFS
EXP-00008: Encontrado erro ORACLE 1003
ORA-01003: no statement parsed

. . a exportar tabela TEXTOS_PROPOSTAS
EXP-00008: Encontrado erro ORACLE 1003
ORA-01003: no statement parsed
. . a exportar tabela TEXTO_MODELOS
EXP-00008: Encontrado erro ORACLE 1003
ORA-01003: no statement parsed

All this tables have BLOB columns!?

Hi

I am trying to import data from an Oracle9i database to Oracle 8i.


Destination database:

D:\>sqlplus "empower@aremdv01"

SQL*Plus: Release 9.2.0.6.0 - Production on Wed May 3 09:54:29 2006

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

Enter password:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE    8.1.7.0.0       Production
TNS for Linux: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production


Source Database:

D:\>sqlplus "empower@arlgqa01"

SQL*Plus: Release 9.2.0.6.0 - Production on Wed May 3 09:54:52 2006

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

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
PL/SQL Release 9.2.0.5.0 - Production
CORE    9.2.0.6.0       Production
TNS for Linux: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production

I check for the ORACLE_HOME Settings (since I have Oracle9i also on my system)

D:\>SET
ALLUSERSPROFILE=C:\Documents and Settings\All Users
------------------------< cut >
ORACLE_HOME=E:\ORA8I
------------------------< cut >

I take the export of source database (ARLGQA01) using 8i client

E:\ORA8I\bin\exp empower/empower@arlgqa01 file=D:\Tavant\Argenta\tasks\empower\empower.dmp log=D:\Tavant\Argenta\tasks\empower\log.log


(Export terminated successfully with warnings.)


Then I import it to the destination database (AREMDV01) using the same 8i client

E:\ORA8I\bin\imp empower/empower@aremdv01 file=D:\Tavant\Argenta\tasks\empower\empower.dmp log=D:\Tavant\Argenta\tasks\empower\implog.log fromuser=empower touser=empower


I get the following errors:

Import: Release 8.1.7.0.0 - Production on Wed May 3 11:06:25 2006

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
IMP-00017: following statement failed with ORACLE error 6550:
 "BEGIN  "
 "sys.dbms_logrep_imp.instantiate_schema(schema_name=>'EMPOWER', export_db_na"
 "me=>'ARLGQA01.INDIA.TAVANT.COM', inst_scn=>'162135219');"
 "COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 3113:
 "CREATE TYPE "AQ_MESSAGE_TYP" TIMESTAMP '2006-02-16:13:42:47' OID 'FB3237A0A"
 "40CCE09E03010AC69787DB1'                                                   "
 "                                                                           "
 "                       as object ("
 "  request_id number(10),"
 "  lnkey varchar2(20),"
 "  borr_id number(3),"
 "  request_type number(3),"
 "  error_code number(3),"
 "  trace_details blob,"
 "  xml_payload blob"
 ");"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully


Now, I followed the rule of using the client of the lowest version. What might have gone wrong in this case, and what can be the solution?

Any help would be appreciated.


Thanks and regards

Puja 

Hi

Does full move = Full Schema move?

Yes, I am doing the Full Schema move.

I am not sure if I can contact support on this, since it is not the production box. Any workaround suggested?

Thanks for the prompt reply...

Regards,

Puja