Re: Renaming a Database

backup control file to trace, edit the trace file as appropriate, shutdown the database, the startup the database using the backup control file. you could also export and import the whole thing. then again, you have to ask yourself why are you renaming in the first place.

as far as index usage, it depends - run an explain plan and find out for sure.

enjoy.

Neil Boemio wrote:
>
> No takers on this one? :(
>
> *************************
> Neil Boemio wrote:
>
> > Hello,
> >
> > I know this question has already been asked and answered, but I don't
> > remember what it was. So could someone be so kind as to tell me the
> > general procedure for renaming a database. BACKUP
> > CONTROLFILE TO TRACE is involved somewhere, no?
> >
> > And a totally unrelated question .... if you have an index on column X
> >
> > and you do a SELECT with a
> > GROUP BY clause on column X, and there is no WHERE clause, will Oracle
> >
> > use the index?
> >
> > Thanks a bunch!
> >
> > \\|// \\\|///
> > (0-0) ( o o )
> > +===oOO===(_)===========================oooO==(_)==Oooo=======+
> > | |
> > | Neil Boemio |
> > | nboemio_at_bway.net |
> > | http://www.bway.net/~nboemio/ ooo0 |
> > | ( ) Oooo. |
> > +================oOO=====================\ (====( )=========+
> > |__|__| \_) ) /
> > || || (_/
> > ooO Ooo
>
> --
> \\|// \\\|///
> (0-0) ( o o )
> +===oOO===(_)===========================oooO==(_)==Oooo=======+
> | |
> | Neil Boemio |
> | nboemio_at_bway.net |
> | http://www.bway.net/~nboemio/ ooo0 |
> | ( ) Oooo. |
> +================oOO=====================\ (====( )=========+
> |__|__| \_) ) /
> || || (_/
> ooO Ooo
Received on Mon Oct 06 1997 - 00:00:00 CDT