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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is it possible to rename a schema??

Re: Is it possible to rename a schema??

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Thu, 24 Jun 1999 11:13:48 +0200
Message-ID: <7ksssj$m27$1@mail.messe.de>


No , it isn't possible.
You have to use export/import with fromuser/touser. to change the schema-name.
Reiner

fred <frederic.servais_at_advalvas.be> schrieb in im Newsbeitrag: 7ksmhg$h5q$1_at_news1.skynet.be...
> I have 2 schemas, the old-schema and the new-schema, i'd like to replace
the
> old one with the new one.
> The solution now is to copy the old one in a copy-schema, then copy the
> new-schema in the old-schema.
> But it would more efficient just to rename the schema:
> 1. rename the oldschema as copy-schema;
> 2. rename the new-schema as old-schema;
>
> If you know anything about that issue i'll appreciate very much any
> information.
>
>
Received on Thu Jun 24 1999 - 04:13:48 CDT

Original text of this message

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