Re: Renaming a Database

Hi

The following script is an example of renaming a database to TEST:

Create Controlfile

	Set Database TEST
	Logfile   Group 1 ('logfile1A','logfile1B'....) size XK,
		Group 2 ('logfile2A','logfile2B'....) size xK
	Noresetlogs
	Datafile 'datafile1' size .....	All the datafiles in the database
	Maxlogfiles x
	Maxlogmembers x
	Maxdatafiles x
	Maxinstances x
	Archivelog;

BE SURE TO GET A LIST OF ALL THE DATAFILES AND LOGFILES. IT IS SAFER TO TAKE A FULL BACKUP BEFORE RENAMING YOUR DATABASE. BEWARE THAT IF YOU OMIT ANY DATAFILE OR LOGFILE YOU WILL HAVE PROBLEMS AND YOU MIGHT NOT BE ABLE TO RECOVER. I hope this is helpful enough.

Cheers
akader_at_health.sanlam.co.za

Neil Boemio <nboemio_at_bway.net> wrote in article <34399325.ABA6D0D6_at_bway.net>...
> 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 Tue Oct 07 1997 - 00:00:00 CDT