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: I need to duplicate a database under new name?

Re: I need to duplicate a database under new name?

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Tue, 18 May 1999 17:00:06 -0400
Message-ID: <3741D4D6.BA646108@bigfoot.com>


I second that advice. You should refer to synonyms, not schema names, then when you are trying to do what you are doing, all you have to do, is re-create synonyms aimed at different schema names.

Gerard H. Pille wrote:

> I would advise against using schema names in PL/SQL coding, so that when you
> import into a new schema, the procedures would refer to the objects of the
> schema/owner.
>
> Otherwise you will never be 100% sure if you modify the script.
>
> bozo heeft geschreven in bericht <37406042.5ED8FAF9_at_clown.com>...
> >I need to set up 3 identical copies of a database (schema) within a
> >single Oracle instance.
> >
> >The fastest way I have been able to figure out how to do this, is to
> >build the first database and export it. If I then import it under a new
> >
> >name, everything gets converted, except references that are imbedded
> >within PL/SQL.
> >
> >From Unix, I can run a perl script to globally search/replace the schema
> >
> >name within the export file. When I then import this converted export
> >file, everything is fine and valid, as long as the schema names are the
> >same length. If the schema names are a different length, then I get a
> >lot of errors on the import.
> >
> >Has anyone got any ideas about this fastest way to do this or what else
> >needs to be done to finish converting the export file, when the schema
> >names are a different length?
> >
Received on Tue May 18 1999 - 16:00:06 CDT

Original text of this message

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