Import/Export Schema
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
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
0