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