Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backing up Ora7.3 database

Re: Backing up Ora7.3 database

From: Matthew Arrocha <marrocha_at_belllsouth.net>
Date: 1997/11/01
Message-ID: <01bce73c$b983ae00$b9008ad1@marrocha>#1/1

Export the schema you want to DUP and import it back into the database running a FROM USER - TO USER import. This will import schema1 into schema2 and schema2 would be the owner of the duplicated objects.

Matthew Arrocha
marrocha_at_bellsouth.net

Steve Hewett <sjohn_at_bsihome.com> wrote in article <63dmpb$3bi$1_at_usenet85.supernews.com>...
> 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.
>
> Thanks,
>
>
>
>
Received on Sat Nov 01 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US