Jonathan Gennick wrote:
>
> >I was wondering if any of you could provide some help here. I am new to
> >Oracle DB Administration, and I have a need to create a exact duplicate of
> >an Oracle 7.3 database under a different schema name. I am wondering if
> >anyone could explain how to accomplish this, or point me out to a good
> >reference.
>
> If you are just trying to duplicate one schema, you could do
> it with an export/import. First export the user you wish to
> duplicate, then import it under a different name. If you
> have access to the "Oracle7 Server Utilities" manual you can
> read up on the commands.
>
> exp73 system/manager_at_dbname owner=XXXXX file=expfile
>
> should give you an output file with everything owned by that
> user. Then you could do:
>
> imp73 system/manager_at_dbname from=XXXXX to=YYYYY file=expfile
>
> to import all that back into the YYYYY schema.
>
> If you want to create an exact duplicate of your entire
> database, then that is a bit more involved. What you want to
> do is to create another instance. I've only done this a few
> times, and I don't have a good step-by-step description of
> the procedure handy. Perhaps someone else will.
>
> regards,
>
> Jonathan Gennick
> ------------------------------------
> gennick_at_worldnet.att.net
> http://home.att.net/~gennickDon't forget to export the grants, indexes, consistency etc. Check the
options of how to built a parameter file for the export. It is cool!
Received on Tue Nov 04 1997 - 00:00:00 CST
