Re: AutoExtend / Locally Managed

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 28 Apr 2004 10:51:09 -0400
Message-ID: <BAY99-F33xArGvnCjnZ0000748b@hotmail.com>

Fahd,

Alternately you may use following script, you must define maxfilesize to have some control on maximum file size to grow. Default is unlimited.

CREATE TABLESPACE "TBS_NAME"
LOGGING
DATAFILE '/u002/oradata/XYZ/DATAFILE_NAME1.dbf' SIZE 501M AUTOEXTEND ON NEXT 1024K MAXSIZE 10000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Regards
Rafiq

From: "Richard Foote" <richard.foote_at_bigpond.com> Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
Subject: Re: AutoExtend / Locally Managed Date: Wed, 28 Apr 2004 22:37:24 +1000

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

Lose those love handles! MSN Fitness shows you two moves to slim your waist. http://fitness.msn.com/articles/feeds/article.aspx?dept=exercise&article=et_pv_030104_lovehandles

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

Received on Wed Apr 28 2004 - 09:48:56 CDT