Re: Cloning a Database

From: James Williams <JKWMSGA_at_YAHOO.COM>
Date: Thu, 1 Aug 2002 07:48:33 -0700
Message-ID: <aib78f$jdr$1@slb3.atl.mindspring.net>

Daniel,

Can you tell me more about transportable tablespaces or point me to where I can read about them?

Export/Import is what I was thinking about using. Here's what I've come up with, but I'm pretty sure I'm missing some steps.

• connect to the live database
• export to a file (I assume there's no way to harm the live database via the export command?)
• disconnect
• connect to the test database
• get a list of every owner (I'm not sure how to do this from a script. If necessary, I can get this data from DBA Admin. I can get the owner of objects from ALL OBJECTS. Where can I get the owner of every table?)
• delete everything in the schema not owned by SYS or SYSTEM
• commit
• import the file
• commit
• recompile the stored procedures
• disconnect
• manually delete the import file

Thanks
James Williams

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D484B7E.3FA3FA88_at_exesolutions.com...

> James Williams wrote:
>
> > I have two databases in Oracle 8i.  One is my live database; the other

is
> > used for testing. About once a week, I need to copy my live database over

> > to the test database.  Any pointers to tools or SQL commands to do this
> > would be appreciated.
> >
> > Thanks
> > James Williams
> > JKWMSGA_at_YAHOO.COM
>
> Transportable tablespaces
> or
> Export/Import
>
> quickly come to mind.
>
> Daniel Morgan
>

Received on Thu Aug 01 2002 - 09:48:33 CDT