Home » Infrastructure » Other Operating Systems » Import from Oracle 7.3.3 to Oracle 8.1.7 errors
Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113617] Wed, 24 January 2001 13:07 Go to next message
Pablo Campanini
Messages: 13
Registered: January 2001
Junior Member
When I have an Export file from Oracle 7.3.3.6.3 (I used Oracle 7.3.3 export module) and I perform an Import to Oracle Instance 8.1.7 (with an import module from Oracle 8.1.7) I got the following errors:

IMP-00003: ORACLE error 911 encountered
ORA-00911: invalid character
IMP-00017: following statement failed with ORACLE error 911:

Any similar experience?
Re: Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113618 is a reply to message #113617] Thu, 25 January 2001 11:11 Go to previous messageGo to next message
Jim Gillespie
Messages: 23
Registered: January 2001
Junior Member
: When I have an Export file from Oracle 7.3.3.6.3 (I used Oracle 7.3.3 export module) and I perform an Import to Oracle Instance 8.1.7 (with an import module from Oracle 8.1.7) I got the following errors:

: IMP-00003: ORACLE error 911 encountered
: ORA-00911: invalid character
: IMP-00017: following statement failed with ORACLE error 911:

: Any similar experience?

Pablo,

I haven't done this, but I would guess that you need to run CATEXP7 from your Oracle 8.1.7 SQL library against your 8.1.7 database. Do the import and then run CATEXP from the 8.1.7 SQL library. If you look at the comments in CATEXP7 it refers do doing just what you want.
Re: Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113619 is a reply to message #113618] Fri, 26 January 2001 09:37 Go to previous messageGo to next message
Pablo Campanini
Messages: 13
Registered: January 2001
Junior Member
: : When I have an Export file from Oracle 7.3.3.6.3 (I used Oracle 7.3.3 export module) and I perform an Import to Oracle Instance 8.1.7 (with an import module from Oracle 8.1.7) I got the following errors:

: : IMP-00003: ORACLE error 911 encountered
: : ORA-00911: invalid character
: : IMP-00017: following statement failed with ORACLE error 911:

: : Any similar experience?

: Pablo,

: I haven't done this, but I would guess that you need to run CATEXP7 from your Oracle 8.1.7 SQL library against your 8.1.7 database. Do the import and then run CATEXP from the 8.1.7 SQL library. If you look at the comments in CATEXP7 it refers do doing just what you want.

: I run CATEXP7 on 8.1.7, run the Import to 8.1.7, but had the same errors doing the Import.
Help........
Re: Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113620 is a reply to message #113617] Mon, 29 January 2001 12:10 Go to previous messageGo to next message
Tom D.
Messages: 2
Registered: January 2001
Junior Member
: When I have an Export file from Oracle 7.3.3.6.3 (I used Oracle 7.3.3 export module) and I perform an Import to Oracle Instance 8.1.7 (with an import module from Oracle 8.1.7) I got the following errors:

: IMP-00003: ORACLE error 911 encountered
: ORA-00911: invalid character
: IMP-00017: following statement failed with ORACLE error 911:

: Any similar experience?

Try using Conventional Path
Re: Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113622 is a reply to message #113619] Wed, 31 January 2001 05:07 Go to previous messageGo to next message
Jim Gillespie
Messages: 23
Registered: January 2001
Junior Member
: : : When I have an Export file from Oracle 7.3.3.6.3 (I used Oracle 7.3.3 export module) and I perform an Import to Oracle Instance 8.1.7 (with an import module from Oracle 8.1.7) I got the following errors:

: : : IMP-00003: ORACLE error 911 encountered
: : : ORA-00911: invalid character
: : : IMP-00017: following statement failed with ORACLE error 911:

: : : Any similar experience?

: : Pablo,

: : I haven't done this, but I would guess that you need to run CATEXP7 from your Oracle 8.1.7 SQL library against your 8.1.7 database. Do the import and then run CATEXP from the 8.1.7 SQL library. If you look at the comments in CATEXP7 it refers do doing just what you want.

: : I run CATEXP7 on 8.1.7, run the Import to 8.1.7, but had the same errors doing the Import.
: Help........

Do you have the ORA$ENV dd card in your import jcl?
Re: Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113623 is a reply to message #113622] Thu, 01 February 2001 11:44 Go to previous messageGo to next message
Pablo Campanini
Messages: 13
Registered: January 2001
Junior Member
: : : : When I have an Export file from Oracle 7.3.3.6.3 (I used Oracle 7.3.3 export module) and I perform an Import to Oracle Instance 8.1.7 (with an import module from Oracle 8.1.7) I got the following errors:

: : : : IMP-00003: ORACLE error 911 encountered
: : : : ORA-00911: invalid character
: : : : IMP-00017: following statement failed with ORACLE error 911:

: : : : Any similar experience?

: : : Pablo,

: : : I haven't done this, but I would guess that you need to run CATEXP7 from your Oracle 8.1.7 SQL library against your 8.1.7 database. Do the import and then run CATEXP from the 8.1.7 SQL library. If you look at the comments in CATEXP7 it refers do doing just what you want.

: : : I run CATEXP7 on 8.1.7, run the Import to 8.1.7, but had the same errors doing the Import.
: : Help........

: Do you have the ORA$ENV dd card in your import jcl?

NO I DID NOT HAVE IT. I PUT THAT IN AND RUN AGAIN THE IMPORT WITH THE SAME RESULTS.
Re: Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113627 is a reply to message #113623] Tue, 06 February 2001 04:22 Go to previous messageGo to next message
Steve Wilkes
Messages: 2
Registered: February 2001
Junior Member
: : : : : When I have an Export file from Oracle 7.3.3.6.3 (I used Oracle 7.3.3 export module) and I perform an Import to Oracle Instance 8.1.7 (with an import module from Oracle 8.1.7) I got the following errors:

: : : : : IMP-00003: ORACLE error 911 encountered
: : : : : ORA-00911: invalid character
: : : : : IMP-00017: following statement failed with ORACLE error 911:

: : : : : Any similar experience?

: : : : Pablo,

: : : : I haven't done this, but I would guess that you need to run CATEXP7 from your Oracle 8.1.7 SQL library against your 8.1.7 database. Do the import and then run CATEXP from the 8.1.7 SQL library. If you look at the comments in CATEXP7 it refers do doing just what you want.

: : : : I run CATEXP7 on 8.1.7, run the Import to 8.1.7, but had the same errors doing the Import.
: : : Help........

: : Do you have the ORA$ENV dd card in your import jcl?

: NO I DID NOT HAVE IT. I PUT THAT IN AND RUN AGAIN THE IMPORT WITH THE SAME RESULTS.

Make sure that you do the export with DIRECT=N and that you are on the latest patch release (8.1.7.0.2 for OS390 MPM).
Re: Import from Oracle 8.1.7to Oracle 8.1.6 errors [message #113804 is a reply to message #113623] Tue, 22 January 2002 23:06 Go to previous message
michel sabbagh
Messages: 1
Registered: January 2002
Junior Member
anybody ..
help importing file from 8.1.7 to oracle 8.1.6 error imp-00069 national character set
thanks in advance
michel sabbagh
Previous Topic: How many Oracle OS/390 customer sites?
Next Topic: Oracle and OS/390 2.10
Goto Forum:
  


Current Time: Thu Mar 28 05:16:41 CDT 2024