Re: db copy

Mark,

I would create the new database, export full on the qa database, import into newly created database. It takes a while, but works well. This way you will get all the tables, indexes, roles, constraints, packages, ...

Troy Meyerink
Oracle DBA
Raytheon
Sioux Falls, SD
meyerink_at_usgs.gov

marc bautis wrote:

> I'm trying to move a qa database environment into production. i'm not
> sure whether i have to manually create the tables in the new db, use
> sqlldr to do the import/export table by table, or is there some copy
> utility which will copy the database at once
>
> thanks,
> marc
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 24 2000 - 00:00:00 CDT