OraFAQ Forum: Server Utilities » importing from .dmp file taken from different edition

Home » RDBMS Server » Server Utilities » importing from .dmp file taken from different edition (oracle 10.2.0.1.0,Redhat Linux 4)

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

importing from .dmp file taken from different edition [message #445477]

Tue, 02 March 2010 01:36

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.

Report message to a moderator

Re: importing from .dmp file taken from different edition [message #445480 is a reply to message #445477]

Tue, 02 March 2010 01:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: importing from .dmp file taken from different edition [message #445484 is a reply to message #445480]

Tue, 02 March 2010 02:03

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

Report message to a moderator

Re: importing from .dmp file taken from different edition [message #445488 is a reply to message #445484]

Tue, 02 March 2010 02:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which steps?

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

Regards
Michel

Report message to a moderator

Previous Topic:	help in fixing Extra space
Next Topic:	CONCAT fails in SQL*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 07:13:18 CST 2024