Re: Duplicating a Database on the same machine

To clarify, all of the datafiles for the production instance are in e:\oracle\gpro and for development they are in f:\oracle\gdev, not in various directories all over the server.. :)

Thanks,
Scott

W. Scott Moore <sirws_at_hotmail.com> wrote in message news:ufx14.114$U04.16838_at_news.uswest.net...
> Here is what I would like to do. Currently, I have a production instance
> and a development instance on the same machine, with all of the data files
> on different drives and directories.
>
> What I would like to do is come up with a way to duplicate the production
> database into the development instance, say late every night. (They
aren't
> huge databases at this point in time... full export is about 200MB), but
> there are lots of tables.
>
> Is it possible to do a full export of the production database and import
it
> to a new location, creating datafiles in a different location for the dev
> database? All of the datafiles have the same name, except for the control
> files, logfiles, etc. which are named differently based on the Oracle SID
> name - if that helps.
>
> I am able to shut down the production instance as well, if a solution
would
> require copying the datafiles. I am sure there are many ways of doing
this,
> I am just looking for something that is fairly quick, and easy to
maintain.
>
> We have 8.0.5 on NT.
>
> Sincerely,
> W. Scott Moore
> GIS Data Base Analyst
> City of Chandler, AZ
>
>
Received on Thu Dec 02 1999 - 10:43:25 CST