Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Dowgrade Oracle10gR2 enterprise edition to Oracle10gR2 standard edition and datapump

edited Jan 11, 2011 2:09AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered
Hi All,

I am planning to downgrade oracle 10gR2 enterprise edition to oracle 10gR2 standard edition and using data pump (export/import) to tranfer database.

What I am going to do tasks as follows.

1. export full database using data pump

expdp system/passwd FULL=y DUMPFILE=fullexp.dmp LOGFILE=fullexp.log

2. deinstall oracle 10gR2 enterprise edition

3. Install oracle 10gR2 standard edition binaries

4. create database

5. import full database using data pump

impdp system/passwd FULL=y DIRECTORY=dump_dir DUMPFILE=fullexp.dmp LOGFILE=import.log

 

I have some queries and not sure whether it can sucessful transfer whole database from enterprise edition to standard edition.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center