Re: Duplicate Database?

have you considered copying the datafiles themselves? i did this and it's not that hard....

make a copy of the control file from your prod environment - alter database backup controlfile to trace;

edit this file to point to the new file locations, change the instance name, change noresetlogs to resetlogs - save as a script - newDevCTRL.sql

shut down that database and copy your files to their new homes - into an existing instance in my case

start that instance up :

    srvrmgr
    connect internal
    @newDevCTRL.sql

just a thought, you may want to bounce this off someone, its been a couple weeks since i did it here - its not very hard, and it's much faster than export / import

brent douglas, ncr

>I'm having some difficulty duplicating my database so I can copy my
>development system into production. I used OEM to export my full
>database, created a new database with similar parameters to my
>development system and tried to import the database using the same
>account that I had exported my database with. I get permission errors
>for the most part indicating that account can't create some of the
>schemas in the database.
Received on Wed Aug 18 1999 - 10:06:03 CDT