Home » RDBMS Server » Server Utilities » importing from .dmp file taken from different edition (oracle 10.2.0.1.0,Redhat Linux 4)
importing from .dmp file taken from different edition [message #445477] Tue, 02 March 2010 01:36 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Dear all,

i m having full export .dmp file taken from oracle 10.2.0.1 Enterprise Edition.

i need to reinstall 10.2.0.1 standard edition and want to creat database using the dump file whitch is takem from the Enterprise edition.

what will be the issue? give me the steps please.

thanks
regards.
Re: importing from .dmp file taken from different edition [message #445480 is a reply to message #445477] Tue, 02 March 2010 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 63805
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You can't create a database with a dump file, you have to create a new database

2/ If you used some EE features like partition you will not be able to directly import. In this example you'll have to precreate the table.

Regards
Michel
Re: importing from .dmp file taken from different edition [message #445484 is a reply to message #445480] Tue, 02 March 2010 02:03 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
thanks for reply,

No i did not use any EE features like partion. tell me steps now
Re: importing from .dmp file taken from different edition [message #445488 is a reply to message #445484] Tue, 02 March 2010 02:35 Go to previous message
Michel Cadot
Messages: 63805
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which steps?

1/ Create a new database
2/ Export current one
3/ Import into new one

Regards
Michel
Previous Topic: help in fixing Extra space
Next Topic: CONCAT fails in SQL*Loader
Goto Forum:
  


Current Time: Tue Sep 27 02:30:30 CDT 2016

Total time taken to generate the page: 0.09436 seconds