Re: AutoExtend / Locally Managed
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Apr 2004 07:44:30 -0400
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;
Ron
>>> fahd-m@xxxxxxxxxxx 04/28/2004 1:16:06 AM >>>
Hi all,
Why can't we put " autoextend on" in the creation of locally
managed tablespaces?
I wrote like this
1-create tablespace tbs1 '<file_path>' size 10M
2-autoextend on
3-extent management local uniform size 128K;
4-and it is giving me error on line 2.
Please give some lights.
regards,
Fahd
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
