Home » RDBMS Server » Server Utilities » Import database to UNIX
Import database to UNIX [message #237840] Tue, 15 May 2007 23:40 Go to next message
newtooracle123
Messages: 24
Registered: May 2007
Junior Member
Hi,
I have a data dump taken from oracle 8i running on Windows. I have to import it into oracle 10g running on Unix machine. But create script for tablespace datafile points to windows directory in the dump. How can I resolve this issue?
Re: Import database to UNIX [message #237842 is a reply to message #237840] Tue, 15 May 2007 23:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Precreate your tablespace.

Regards
Michel
Re: Import database to UNIX [message #238417 is a reply to message #237842] Thu, 17 May 2007 23:24 Go to previous messageGo to next message
newtooracle123
Messages: 24
Registered: May 2007
Junior Member
Thank u..

Is there any tool available for the same..
Re: Import database to UNIX [message #238424 is a reply to message #237840] Fri, 18 May 2007 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
vi
Re: Import database to UNIX [message #238738 is a reply to message #238424] Sat, 19 May 2007 14:27 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
i guess for moving one platform to another you must convert the Endian format

http://www.dell.com/downloads/global/power/ps1q05-20040267-Muirhead.pdf
Re: Import database to UNIX [message #238741 is a reply to message #238738] Sat, 19 May 2007 14:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again read carefully the question.
This one has no relation with transportable tablespace but with a standard dump.
There is no endian issue in this case.
The problem is in the name of the datafiles.

Moreover the document you posted is for 10g, OP said he works with 8i.

Most of your posts are useless and/or out of the question. Please take a little care and don't try to play the post number.

Regards
Michel
Re: Import database to UNIX [message #238746 is a reply to message #237840] Sat, 19 May 2007 15:32 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>i guess for moving one platform to another you must convert the Endian format
Once again a Ready, Fire, AIM response from you.
You seem to know many buzzwords.
Files created by EXPORT are 100% OS independent files; regardless of Endian or 32vs.64 bit OS.
The only "restriction" is that a file can NOT be imported into a lower version database.

Please get your facts straight, before you distort reality again.
Re: Import database to UNIX [message #238756 is a reply to message #238746] Sat, 19 May 2007 16:55 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks for correction
Previous Topic: how to not load some records while loading in sqlloader
Next Topic: import error
Goto Forum:
  


Current Time: Fri Dec 09 15:47:34 CST 2016

Total time taken to generate the page: 0.30299 seconds