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

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 13 Sep 2004 15:54:31 +1000
Message-Id: <41453617$0$23899$afc38c87@news.optusnet.com.au>

>
> Sorry for the delay. vacation-induced. I'll try not to make that
> mistake again! ;-)
>
> alter database tempfile '/u01/oradata/xxx/temp03.dbf' drop;
> alter tablespace temp add tempfile '/u01/oradata/zzz/temp08.dbf';

See! I knew I could have looked it up. Did you have to? Or is this piece of syntax something now you feel in your bones?

> No accounting for syntax consistency .... "drop this_thing",
> "this_thing drop", "add this_thing" (at least, no "this_thing add")

Exactly. That's why I like to stick, wherever possible, to syntax I know and love.

Regards
HJR Received on Mon Sep 13 2004 - 00:54:31 CDT