Re: [Q] how to online drop tempfile???

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 13 Sep 2004 22:14:04 -0700
Message-ID: <73e20c6c.0409132114.50aa4c73@posting.google.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41454679$0$23894$afc38c87_at_news.optusnet.com.au>...
> >
> > Not that inconsistent. There is this use the the same syntax too:
> >
> > ALTER DATABASE TEMPFILE '/u02/oracle/data/lmtemp02.dbf' RESIZE 250M;
> >
>
> Hugely inconsistent!
>
> Datafile resizing has always been a 'alter database datafile ... resize'.
> The tempfile version is pretty much identical.
>

There is worse:
ALTER DATABASE RENAME FILE '/bing/bong/blah.dbf' TO '/who/knows.dbf';

How much work for Oracle would it be to make it: ALTER DATABASE DATAFILE '/bing/bong/blah.dbf' RENAME '/who/knows.dbf'; a much more consistent syntax?

Ah well, gotta keep those OCP $$$ coming.... Received on Tue Sep 14 2004 - 00:14:04 CDT