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

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 Mon May 17 1999 - 13:52:42 CDT