-
re: duplicating a database
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
thanks,
harish
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|