OraFAQ Forum: Server Utilities » Importing into Oracle 8.06

Home » RDBMS Server » Server Utilities » Importing into Oracle 8.06

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing into Oracle 8.06 [message #71089]

Fri, 06 September 2002 10:01

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

Report message to a moderator

Re: Importing into Oracle 8.06 [message #71090 is a reply to message #71089]

Fri, 06 September 2002 19:45

Arfat
Messages: 25
Registered: August 2002

Junior Member

Try using SQL LOADER.
much more faster and reliable utility

Report message to a moderator

Re: Importing into Oracle 8.06 [message #71092 is a reply to message #71089]

Fri, 06 September 2002 22:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i beleive, its an error with date formats or NLS settings.
check that out!

Report message to a moderator

Re: Importing into Oracle 8.06 [message #71096 is a reply to message #71089]

Sun, 08 September 2002 19:35

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

Report message to a moderator

Re: Importing into Oracle 8.06 [message #71105 is a reply to message #71089]

Mon, 09 September 2002 08:45

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 00:58:08 CDT 2025