If the schema is separate tablespace-wise, you can use transportable tablespaces.
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Friday, January 30, 2004 5:33 AM
To: LazyDBA.com Discussion
Subject: Cloning/Copying a schema in Oracle 9i
Hi,
Does anyone know of an easy way to copy/clone an Oracle9i database schema
anoher database other than using import/export. I would like to know this
so that our salesmen can use this technique.
It's come to my attention that this can be done using OEMs change
management pack. As I do not have OEM installed yet, can anyone tell me if
this is an easier method of copying a schema from one database to another.
Regards
Julius
****************************************************************************
XLfit 4 is now available. Powerful curve fitting, statistics and results
presentation
for Excel. Trial XLfit 4 for 30 days free of charge and without obligation:
http://www.id-bs.com/xlfit4
*****************************************************************************
The information contained in this email may contain confidential or legally
privileged information. If you are not the intended recipient any
disclosure, copying, distribution or taking any action on the contents of
this information may be unlawful. If you have received this email in error,
please delete it from your system and notify us immediately. Any views
expressed in this message are those of the individual sender, except where
the message states otherwise. IDBS takes no responsibility for any
computer virus which might be transferred by way of this email and
recommends that you subject any incoming E-mail to your own virus checking
procedures. We may monitor all E-mail communication through our networks.
If you contact us by E-mail, we may store your name and address to
facilitate communication.
*****************************************************************************
--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page