Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Unsetting autoextend?

Unsetting autoextend?

From: Doug O'Leary <dkoleary_at_mediaone.net>
Date: Sun, 4 Mar 2001 13:47:42 -0800
Message-ID: <MPG.150c57dd911fc27989779@news.randori.com>

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.net
Received on Sun Mar 04 2001 - 15:47:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US