OraFAQ Forum: Server Utilities » Import database to UNIX

Home » RDBMS Server » Server Utilities » Import database to UNIX

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

Import database to UNIX [message #237840]

Tue, 15 May 2007 23:40

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?

Report message to a moderator

Re: Import database to UNIX [message #237842 is a reply to message #237840]

Tue, 15 May 2007 23:47

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Precreate your tablespace.

Regards
Michel

Report message to a moderator

Re: Import database to UNIX [message #238417 is a reply to message #237842]

Thu, 17 May 2007 23:24

newtooracle123
Messages: 24
Registered: May 2007

Junior Member

Thank u..

Is there any tool available for the same..

Report message to a moderator

Re: Import database to UNIX [message #238424 is a reply to message #237840]

Fri, 18 May 2007 00:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Report message to a moderator

Re: Import database to UNIX [message #238738 is a reply to message #238424]

Sat, 19 May 2007 14:27

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

Report message to a moderator

Re: Import database to UNIX [message #238741 is a reply to message #238738]

Sat, 19 May 2007 14:44

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Import database to UNIX [message #238746 is a reply to message #237840]

Sat, 19 May 2007 15:32

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Import database to UNIX [message #238756 is a reply to message #238746]

Sat, 19 May 2007 16:55

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Thanks for correction

Report message to a moderator

Previous Topic:	how to not load some records while loading in sqlloader
Next Topic:	import error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 00:53:19 CDT 2024