IMPORT Data dump [message #117869] |
Sat, 30 April 2005 06:57 |
rsekar
Messages: 3 Registered: April 2005 Location: India
|
Junior Member |
|
|
Hi ,
I am having a datadump from oracle10g.Is it possible to import this to oracle 9i.How to import this data dump into oracle 9i.I tried importing with oracle19g but i am getting this error
"Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export file created by EXPORT:V09.02.00 via direct path
Warning: the objects were exported by SD74, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION"
IMP-00000: Import terminated unsuccessfully
|
|
|
Re: IMPORT Data dump [message #118346 is a reply to message #117869] |
Wed, 04 May 2005 09:58 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
You cannot import a 10g datapump dump into an Oracle9i database as the file formats are different. Datapump can only be used with Oracle10g (or higher) versions of the database.
The standard imp/exp utilities can be used with 9i (and earlier) as well as 10g databases.
Best regards.
Frank
|
|
|
|
Re: IMPORT Data dump [message #118414 is a reply to message #118408] |
Thu, 05 May 2005 01:29 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
First, please read the "Oracle Database Utilities" manual (chapters 1 to 3) and try to get it working yourself. If you have any specific problems or questions, let us know.
Best regards.
Frank
|
|
|
|
Re: IMPORT Data dump [message #118504 is a reply to message #118458] |
Thu, 05 May 2005 11:40 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Ajay, no offense, but it seems like you are the one that never worked with 10g before. The file formats are different! If you can make them compatible, please let us know how.
$ oerr ora 39143
39143, 00000, "dump file \"%s\" may be an original export dump file"
// *Cause: A dump file was specified for an import operation which appears
// to have been created using the original export utility. These
// dump files cannot be processed by the Data Pump import utility.
// *Action: Try using the original import utility to process this dump file.
Best regards.
Frank
|
|
|
|