How do I duplicate an Oracle 184.108.40.206 production database ?
assuming that the duplicate "environment" will be
the "same" as the production environment ..
-- the same operating system as the production database
-- the same hardware as the production database
-- at a user level instead of the whole database
using the export and import utility ....
i export user1 from the production database
what are the things to specify in the export clause
when I import what are the things I need to have done
before doing the import ?????
do I just need to have the user and password created !!!
and the import will do the rest like creating the appropriate
tablespaces and datafiles etc ...
You have to create the database first in your duplicate environment with all the datafiles and tablespaces as in the original database and then you can do an export full=y and then import it to the new database.