Re: AutoExtend / Locally Managed

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 28 Apr 2004 22:37:24 +1000
Message-ID: <0a2201c42d1d$8f1becd0$0100000a@FOOTE>

Hi Ron

Fahd simply forgot the "DATAFILE" keyword in his example.

Happens sometimes ...

Cheers

Richard
----- Original Message -----

From: "Ron Rogers" <RROGERS_at_galottery.org> To: <oracle-l_at_freelists.org>
Sent: Wednesday, April 28, 2004 9:44 PM
Subject: Re: AutoExtend / Locally Managed

Fahd,
 Autoextend does work in 8.1.7.4 and 9.2.0.5

example:

CREATE TABLESPACE fixed_data
DATAFILE '/data5/lnxdb/fixedd01.dbf' SIZE 2 M AUTOEXTEND ON NEXT 100 k
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100 k;

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Apr 28 2004 - 07:33:05 CDT