OraFAQ Forum: Server Utilities » Importing Oracle 8.1.7 into Oracle 9.0.2

Home » RDBMS Server » Server Utilities » Importing Oracle 8.1.7 into Oracle 9.0.2

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

Importing Oracle 8.1.7 into Oracle 9.0.2 [message #127488]

Mon, 11 July 2005 21:40

PRAVEEN HORTIKAR
Messages: 5
Registered: January 2003

Junior Member

Hi,
I am trying to import full database dump of Oracle 8.1.7 in oracle 9.0.2
Do i need to create the table space in Oracle 9i upfront or just import directly using imp utility.Also any other sqls do I need to run before I export the oracle8?(like catexp.sql)
Oralce 8.1.7 is on HPUX and Oralce 9i is Win 2003 server
If you can give me syntax for importing or for pre creating tablespaces,will be of gr8 help

Report message to a moderator

Re: Importing Oracle 8.1.7 into Oracle 9.0.2 [message #127624 is a reply to message #127488]

Tue, 12 July 2005 09:37

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

Senior Member
Account Moderator

precreate the tablesspace before importing.
Becuase by default import will create the tablespaces with original directory specificaition.
use sql methods to create the tablespace.
use lower version of export to export and same lower version of import to import
or
run catexp.sql

Report message to a moderator

Re: Importing Oracle 8.1.7 into Oracle 9.0.2 [message #127691 is a reply to message #127488]

Tue, 12 July 2005 21:40

Steve Callan
Messages: 44
Registered: January 2004

Member

You mean use import of the version you are importing into, not the lowest version. If going from 8i to 9i, you wouldn't use 8i import to import into a 9i database. But if going from 9i to 8i, you would use 8i's export and import versions.

Report message to a moderator

Previous Topic:	SqlLoader Insert Data - Automatic
Next Topic:	Load Flat File on Table using SQL LOADER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:44:45 CST 2024