RE: AutoExtend / Locally Managed

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Apr 2004 09:15:19 -0400

You can have autoextend on, but you've got to tell Oracle how much & by =
how much.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Fahd Mirza [mailto:fahd-m@xxxxxxxxxxx]
Sent: Wednesday, April 28, 2004 1:16 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: AutoExtend / Locally Managed


Hi all,
    Why can't we put " autoextend on" in the creation of locally managed =
tablespaces?
        I wrote like this=20
            1-create tablespace tbs1 '<file_path>' size 10M=20
            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: