Howard J. Rogers wrote:
>>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
Not that inconsistent. There is this use the the same syntax too:
ALTER DATABASE TEMPFILE '/u02/oracle/data/lmtemp02.dbf' RESIZE 250M;
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Sep 13 2004 - 01:16:49 CDT
