RE: AutoExtend / Locally Managed

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 28 Apr 2004 09:15:19 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D845E@25exch1.vicorpower.vicr.com>

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_at_aero.com.pk] Sent: Wednesday, April 28, 2004 1:16 AM
To: oracle-l_at_freelists.org
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_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


-----------------------------------------------------------------

----------------------------------------------------------------

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 - 08:12:32 CDT