Hi,
I inherited an 11g R2 installation with about 10 databases but no documentation. Now I have to clone one database in order to test a migration.
I read somewhere that exp and imp refer internally to a device and not to an oracle_sid. Is that true?
My assertion is that the ORACLE_SID in the environment routes the data to the correct database. But I don't want to test that assumption at our Prod-system...
I would exp and imp the data with the "full" attribute as sysdba in order to clone the database.
Is that correct?
Best regards and TIA
Marc