Home » RDBMS Server » Server Utilities » Importing into Oracle 8.06
Importing into Oracle 8.06 [message #71089] Fri, 06 September 2002 10:01 Go to next message
Eddy Confer
Messages: 17
Registered: January 2002
Junior Member
I have a dump file from an oracle 8.17 database created by using the oracle 8.17 export. I need to get this data into an oracle 8.06 database. Can I use import? When I try using the 8.17 import I get the following error messages:

IMP-00003:Oracle ERROR 2248 ENCOUNTERED
ORA-02248: invalid option for ALTER SESSION
IMP-00000: import terminated unsuccessfully
Re: Importing into Oracle 8.06 [message #71090 is a reply to message #71089] Fri, 06 September 2002 19:45 Go to previous messageGo to next message
Arfat
Messages: 25
Registered: August 2002
Junior Member
Try using SQL LOADER.
much more faster and reliable utility
Re: Importing into Oracle 8.06 [message #71092 is a reply to message #71089] Fri, 06 September 2002 22:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i beleive, its an error with date formats or NLS settings.
check that out!
Re: Importing into Oracle 8.06 [message #71096 is a reply to message #71089] Sun, 08 September 2002 19:35 Go to previous messageGo to next message
sunil bhola
Messages: 58
Registered: July 2002
Member
for this you have to run the script first named exp7..sql b'coz ypi want to import the data to the previous version so first run the file exp7..sql(if am not sure about the name of the file) and then import the data back to the 8.1.6
Re: Importing into Oracle 8.06 [message #71105 is a reply to message #71089] Mon, 09 September 2002 08:45 Go to previous message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Eddy,

Use 8.06 export on 817 database to create the dump file and then use 806 import to import into your 806 database.

Suresh
Previous Topic: Mutation problem in Triggers....
Next Topic: password for "connect internal"
Goto Forum:
  


Current Time: Sat May 04 04:22:45 CDT 2024