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: Change Schema name???

Re: Change Schema name???

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1997/01/26
Message-ID: <olseNDAFPz6yEw2O@jimsmith.demon.co.uk>#1/1

In article <32e5331f.3453565_at_news.netway.at>, Rainer Hoerbe <rhoerbe_at_netpromote.co.at> writes
>On Wed, 15 Jan 97 19:01:13 EST, "Angelito Dizon" <adizon_at_mail.us.net>
>wrote:
>
>>Is it possible to change the name of a schema?
>>
>>Thanks,
>>Lito
>>
>>Lito Dizon
>>adizon_at_us.net
>>
>Try export, hack the dump file, import. (Mybee not the best way, but
>better than tweaking the SYS tables)

If you are going to use export and import then there is no need to hack. You just have to use the fromuser and touser parameters on the import command line.

-- 
Jim Smith
Received on Sun Jan 26 1997 - 00:00:00 CST

Original text of this message

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