Home » RDBMS Server » Server Administration » import
import [message #62974] Mon, 30 August 2004 02:41 Go to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
i want to know onething  a dump taken for oracle 9i on solaris that dump can i import for oracle 10g on windows

 

Regards

D.Dilip

Report message to a moderator

Re: import [message #62978 is a reply to message #62974] Mon, 30 August 2004 05:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yes

Report message to a moderator

Re: import [message #62980 is a reply to message #62978] Mon, 30 August 2004 05:57 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
thanks for reply

but when i am importing i am getting a error message

"Failed to make validation for export file"

pls tell help me out

dilip

Report message to a moderator

Re: import [message #62981 is a reply to message #62980] Mon, 30 August 2004 06:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
take a dump (do export) in solaris db1
use the same lower version of imp tool to do the import into windows db2.
i.e set tns entries to talk to the DB in windows box.

-- do export from solaris Box (9i)
exp dba/user@solaris_Db1 owner=yada file=yadafile.dmp

-- in solaris issue somthing like this:
-- s
imp dba/user@windows_db2 file=yadafile.dmp fromuser=yada touser=blah

---
still error?
post the exact error message.

Report message to a moderator

Re: import [message #62987 is a reply to message #62981] Mon, 30 August 2004 22:42 Go to previous message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi

my exact problem in importing is i got a Dump file of a schema in tape which is of 8 Gb and that dump has been taken in Oracle 9.0.2 and at my site i having solaris 8 and Oracle 9.0.1

when i have initially tried to import that on same system other then table/index/partition segments rest of the objects is imported with the following error messages

" DBMS_LOGREP.INSTANTIATE_SCHEMA MUST BE DECLARED"
"INVALID OPTION ENCOUNTERED ORA ERROR 922"
"INVALID OPTION ENCOUNTERED ORA ERROR 901"

i have tried many times but again i am getting same error messages

then i have installed Oracle 10g(10.0.1) on WIN 2000 server

now i am getting the error

"failed to make validation for a file"

pls help me in this regard this is an urgent task

Regards

D.Dilip

Report message to a moderator

Previous Topic: connecting Oracle8 sql*plus using Oracle9i Database - urgent
Next Topic: interface problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 04:02:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.