RE: Index Tablespace

From: syed jaffar hussain <sjaffarhussain_at_hotmail.com>
Date: Wed, 19 May 2004 09:36:09 +0300
Message-ID: <00d901c43d6b$92505630$cf0a010a@app02test>

Fahad,
Whenever a user creates any objects in his scehma with out specifying tablespace parameter, then, those objects will be created in this default tablespace.
You can specifiy tablespace parameter while creating index to create in any particular tablespace.

Best Regards,

Syed Jaffar Hussain
Sr Oracle DBA
Sejel Technology Ltd.
+966 2 6064971 x 324

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fahd Mirza Sent: Wednesday, May 19, 2004 9:24 AM
To: oracle-l_at_freelists.org
Subject: Index Tablespace

Hi listers,

    I want to use a default tablespace of all indexes other then INDX tablespace or the default tablespace of user. How can I do that, please help.
thanks,
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 May 19 2004 - 01:33:23 CDT