Home » RDBMS Server » Server Administration » Importing datafiles from oracle 8 into oracle 10 (Solaris / Oracle 10.2 and Oracle 8.1.7.4)
Importing datafiles from oracle 8 into oracle 10 [message #317723] Fri, 02 May 2008 15:37 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
i was reading a lot of manuals (maybe i didn´t find the correct one) but when i search for a method that allow me to import the datafiles on a oracle 10 from another database using oracle8

I don´t know if this does exist but doing a replication from a database i can "get" the datafiles from another installation.

Sorry for my english but i tryed to explain what want i trying to do... i don´t know if this way does exist or not...

Re: Importing datafiles from oracle 8 into oracle 10 [message #317732 is a reply to message #317723] Fri, 02 May 2008 16:58 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Assuming you are on the same platform, you can follow the process indicated in Transporting Tablespaces Between Databases.
Re: Importing datafiles from oracle 8 into oracle 10 [message #317733 is a reply to message #317723] Fri, 02 May 2008 17:10 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You might try with Export/Import utilities (if that's an option); export 8i using the lowest involved database version Export utility (it would be 8i) and import it into 10g using target database Import utility (and that's 10g).

If you are interested in viewing the Compatibility Matrix for Export And Import Between Different Oracle Versions, it can be found in Metalink Note 132904.1.
Previous Topic: Table size not visible
Next Topic: ora-00600 error in alert log file
Goto Forum:
  


Current Time: Fri Sep 06 16:20:38 CDT 2024