No, you cannot Remane an Oracle Schema, rather try to use the Import
and Export utility , to do that.
Faheem Rao
"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:<3bd472f0_at_news.iprimus.com.au>...
> Do you mean rename a database? Or rename a schema?
>
> If its rename a database, then the procedures are similar to when you clone
> a database: basically, you blow away the control files and edit a control
> file trace script, and run that to re-create the control files with a new
> database name set within them. You also need to do some poking around in
> the init.ora (see the tip on cloning a database at the site below if you're
> interested).
>
> If you mean rename a schema -so that scott.emp becomes mary.emp, along with
> every other table scott owns- then no, there's no SQL command to do that.
> You can use export and import to do the deed (import with FROMUSER=Scott and
> TOUSER=Mary), but that would also require you to eventually drop user Scott
> cascade.
>
> Regards
> HJR
> --
> Resources for OracleT: www.geocities.com/howardjr2000
> =========================================
>
>
> "Huy Vu" <huyv_at_usa.net> wrote in message news:3bd45026$1_3_at_aeinews....
> > Hi all,
> >
> > I'm curious if I can rename an Oracle schema without drop it and recreate
> it
> > with another name. It took very long to drop our oracle schema (8.1.x).
> >
> > Is there the equivalent of Informix statement "rename database x to y" in
> > Oracle instance?
> >
> > Thanks in advance for any advise.
> >
> > DH
> >
> >
Received on Tue Oct 23 2001 - 03:16:27 CDT
