Home » RDBMS Server » Server Administration » Urgent! nt server to solaris server oracle import
Urgent! nt server to solaris server oracle import [message #57509] Thu, 19 June 2003 16:00 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Hi,
Recently one of our oracle 8.1.7 servers on NT went down and they wanted me to take the oracle NT export file (full export) and then import it into a solaris 8.1.7 database. I'm doing a full import, into a fresh database. But during the import process, the solaris oracle import is trying to create the tablespaces. However its using the windows directory locations to create the tablespaces (such as e:oracledatadat1.dat and so on) and fails. How do I make the import use the solaris path for creating tablespaces???
Thanks

Report message to a moderator

Re: Urgent! nt server to solaris server oracle import [message #57510 is a reply to message #57509] Thu, 19 June 2003 17:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create the tablespaces in solaris DB with the same name like the ones in windows DB.
then do the import.

Report message to a moderator

Re: Urgent! nt server to solaris server oracle import [message #57511 is a reply to message #57510] Thu, 19 June 2003 18:35 Go to previous message
Tony
Messages: 190
Registered: June 2001
Senior Member
I manually created the tablespaces. Everything went ok. thanks.

Report message to a moderator

Previous Topic: Undo Tablespace & omf
Next Topic: Oracle DATE datatype internal structure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:37:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.