Re: Question! Rename a datebase.

Actually Michael talks in a different language. He probably thinks the maximum database size is about several dozens of megabytes and import/export is only going to take minutes.

I fully agree with you Sybrand that this is rather easy to accomplish by recreating the controlfile. That is what I have been doing many times before. However, from my classes several years ago, I remember that the instructor talked about changing the global name and also editing sys.props$. Do you know how all this fits together?

Regards
Karen Abgarian.

sybrandb_at_my-deja.com wrote:

> Actually the trace copy is much more easier. It is a 5 minute
> operation, really!
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> In article <8mu29m$c5q$1_at_nnrp1.deja.com>,
> meekel_at_yahoo.com wrote:
> > The easiest way I can think of is:
> > Create a new database with the name and parameters you want.
> > Do an export on the databse you want to copy.
> > (I go by user and skip SYS & SYSTEM, but you could do full=y)
> > Import the dump file into your new database and verify.
> >
> > There are other ways, like making a trace copy of your controlfile and
> > modifying it, but that is more involved.
> >
> > Michael Heindel
> >
> > In article <965902995.111321_at_iq>,
> > "Leonid Grinchak" <leonidgrinchak_at_freemail.ru> wrote:
> > > Hi All!
> > > I need to rename a database.
> > > How do it whithout Oracle technical support.
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------------------------------
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Aug 10 2000 - 00:00:00 CDT