re: duplicating a database

[hreddy007]

hi! ,

How do I duplicate an Oracle 9.2.0.5 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 ....

question 1)
i export user1 from the production database
what are the things to specify in the export clause

question 2)
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 ...

thanks for your help and insights !!!
harish

[thomasp]

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.

[akhadar]

1.create required tablespace and datafile at target database.
2.create users at target.
3.From source take export of user1 with full=y.
4.At target import the user1 with full=y.

onemore alternative is by using transportable tablespaces feature.

[hreddy007]

How do I go about for

steps 1) and 2)

do I need to get the details for the all the tablespaces,datafiles
and the user tablepspace and data file file info
from the prodcution dba team ..!!!!


thanks,

Harish

[akhadar]

yes.only tablespaces and datafiles pertaining to users.

[marist89]

Originally posted by hreddy007

using the export and import utility

That's a lot of work, IMHO. See http://www.dbasupport.com/forums/sho...threadid=44964