Home » RDBMS Server » Backup & Recovery » how to import full 10g dmp file in oracle 11g using imp
how to import full 10g dmp file in oracle 11g using imp [message #663584] Fri, 09 June 2017 05:38 Go to next message
qanita786
Messages: 223
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
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 Go to previous messageGo to next message
John Watson
Messages: 7150
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.
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 Go to previous messageGo to next message
qanita786
Messages: 223
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
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 Go to previous message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Have you not noticed that there is some output generated by imp?
Previous Topic: Auto Backup ArchiveLogs
Next Topic: RMAN connection
Goto Forum:
  


Current Time: Tue Nov 21 08:05:08 CST 2017

Total time taken to generate the page: 0.11081 seconds