Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Unsetting autoextend?
Hey;
I'm having difficulty decyphering the Oracle documentation; I'm trying to turn off the auotextend feature on a tablespace. I keep getting "missing or invalid alter tablespace option".
What I've tried is as follows:
alter tablespace ${ts}
autoextend off;
alter tablespace ${ts}
set autoextend off;
alter tablespace ${ts}
storage (autoexend off);
alter tablespace ${ts}
default storage (autoextend off);
Can someone fill me in on the correct syntax?
Thanks!
Doug
-- ------------------- Douglas K. O'Leary Senior System Admin dkoleary_at_mediaone.netReceived on Sun Mar 04 2001 - 15:47:42 CST
![]() |
![]() |