Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Import/Export Schema

edited Apr 26, 2013 1:30AM in Database Install/Upgrade/Opatch (MOSC) 12 commentsAnswered
Dear Community,
        This will be my first time exporting whole database schema, Our current database is 10gR2 running on AIX 5.3 my plan is to export it and import to10gR2 which is running on Oracle Enterprise Linux 5.3. The following is my question.

       1. On the target database which is on OEL 5.3 do we need to create a schema first same with the source database? or it will automatically created upon importing?
          
          ex: 
           source > Database SID : RMSPRD                                        target > Database SID : RMSPRD
                          Schema          : rms13prd                                                    Schema         : rms13prd

      2. Does it need to have the same file system structure?
       
        ex:
           source > /u01                            target > /u01

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