Home » RDBMS Server » Backup & Recovery » exp solaris / imp windwos
exp solaris / imp windwos [message #212702] Sun, 07 January 2007 19:57 Go to next message
fnguy
Messages: 39
Registered: January 2006
Member
I want to run an import to windows from solaris export. Can anyone tell me the syntax to handle the new names of the file systems in windows?

We're using 9i r2
Re: exp solaris / imp windwos [message #212704 is a reply to message #212702] Sun, 07 January 2007 20:08 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
HUH?
I would suggest to avoid using pathnames & only work with files within present working directory.
Unix is case sensitive; while Windoze is case insensitive.
Re: exp solaris / imp windwos [message #212706 is a reply to message #212702] Sun, 07 January 2007 21:07 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
Let me see if I can better explain;

On the solaris box mydb is in /db/somewhere and /db/somewhereelse

On the windoze server it needs to be d:\here\and\there and d:\here\and\notthere

How do I specify the import to put the tablespaces in a certain place?
Re: exp solaris / imp windwos [message #212708 is a reply to message #212702] Sun, 07 January 2007 21:13 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>How do I specify the import to put the tablespaces in a certain place?
If you maunally pre-create the tablespaces prior to import, Oracle won't try to create them during the actual import.
Re: exp solaris / imp windwos [message #212841 is a reply to message #212708] Mon, 08 January 2007 09:03 Go to previous message
fnguy
Messages: 39
Registered: January 2006
Member
Great anacedent!! Many thanks....
Previous Topic: how to recover database if o/s corrupted & also loss server?plz step by step with script with de
Next Topic: RMAN
Goto Forum:
  


Current Time: Tue Dec 06 10:25:57 CST 2016

Total time taken to generate the page: 0.11558 seconds