| Import from Oracle 7.3.3 to Oracle 8.1.7 errors [message #113617] |
Wed, 24 January 2001 13:07  |
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  |
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 |
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 |
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 |
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 |
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 |
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).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
