OraFAQ Forum: Backup & Recovery » how to import full 10g dmp file in oracle 11g using imp

Home » RDBMS Server » Backup & Recovery » how to import full 10g dmp file in oracle 11g using imp

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

how to import full 10g dmp file in oracle 11g using imp [message #663584]

Fri, 09 June 2017 05:38

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Normally we use this command

imp system/manager@main file=d:\full.dmp full=yes

we generaly import data from this command but when we transfer my 10g dmp file to 11g database 64 bit we can't succeeded please guide me how to import full database from 10g dmp to 11 g

Thanks and Regards
Faheem

Report message to a moderator

Re: how to import full 10g dmp file in oracle 11g using imp [message #663585 is a reply to message #663584]

Fri, 09 June 2017 05:45

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

"can't succeeded" is not a well documented ORacle error message. You need to provide a bit more detail if you want any assistance.

Report message to a moderator

Re: how to import full 10g dmp file in oracle 11g using imp [message #663586 is a reply to message #663585]

Fri, 09 June 2017 06:03

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Generally we use this command to backup in oracle 10g

exp system/manager@main file=d:\backup.dmp full=yes

This command generate dmp file and we will import this file in 10g with no errors but when we import 10g dump file to 11g database then tables and roles not transfer to 11g it only creates schemas instead of tables,roles

Report message to a moderator

Re: how to import full 10g dmp file in oracle 11g using imp [message #663587 is a reply to message #663586]

Fri, 09 June 2017 06:06

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Have you not noticed that there is some output generated by imp?

Report message to a moderator

Previous Topic:	Auto Backup ArchiveLogs
Next Topic:	RMAN connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 21:52:12 CST 2025