you can shutdown the database. copy it, rename the logfiles, and some inita.ora parameters.
>
> From: [Email Address Removed] Date: 2004/01/30 Fri AM 08:33:28 EST
> To: "LazyDBA.com Discussion" <[Email Address Removed] 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] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>

Oracle LazyDBA home page