Hello dear community,
Please help me to find a response for my questions.
This is my scenario :
On the Machine A , I have Source database which contains :
- Schema X : default tablespace for this schema named MY_X_TABSPACE (DataFile stored in this location : "D:/oradata_machine_A/MY_X_TABSPACE_01.dbf")
- Schema SYS, SYSTEM (+ other default schemas)
On the Machine B, I have Target database (newly created) which contains :
- Schema SYS, SYSTEM (+ other default schemas)
Now,
1/ On machine A, I execute the command
exp system/my_pass@my_source_db FULL=Y FILE=FULL.DMP
2/ On machine B, I execute the command
imp system/my_pass@my_target_db FULL=Y FILE=FULL.DMP
==> I choose FULL=y because I want to Import schema X from source to target alongwith roles, privilges, synonyms... etc and I want to make sure that I'm not missing anything in target.
Question1 :
In step (2) above what would happen to the Objects ( owned by SYS, SYSTEM ... ) already existing in target databases (may be replaced, appended, .. ) :
- Having the same Oracle DB Version on machine A & B (11gR2 for example) ?
- Having Oracle 9i on machine A 11gR2 on machine B (I guess, System tables are changed between 9i and 11g) ?
Question2 :
I used a full import ==> X schema will be created on target base, also the tablespace MY_X_TABSPACE;
Datafile location of tablespace MY_X_TABSPACE will change automatically (for example "D:/oradata_machine_B/MY_X_TABSPACE_01.dbf")?
or it will stay like source DB ("D:/oradata_machine_A/MY_X_TABSPACE_01.dbf")?
Thanks for help,
best regards.