Database Administration (MOSC)

MOSC Banner

How to Migrating 3tb database through export/import

Hi 

We are in the process of migrating 12c database which is 3TB to 19c . 

Question :

1. should we be doing full export and full import , or should we be doing only application schema.

2.Will there be an impact if we import only the schemas , will something be missed. 

3. Apart from profiles and roles , do we need to create anything before hand. 

4.Do we need to set any environment variables before exporting /importing to make the migration smooth /flawless . 

5. What other ways can this process be made fast 


My sample export /Import is like below . Kindly let me know if any changes 

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center