Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: can I set a default index tablespace??
Mark,
Yeah, I've wanted that for years. I tried to automate changing the User's default tablespace in a Before Create trigger on a schema, but couldn't figure out how to tell if an index was being created and, anyway, you can't do that kind of DDL in that kind of trigger.
What I've done is run a script that queries User_Indexes and builds 'Alter Index <IndexName> Rebuild Tablespace <IndexTablespace>' statements for every index in a data tablespace. I guess this could be done with dynamic SQL in a stored proc called by a DBMS_Job.
Jack
-----Original Message-----
Mark Leith
Sent: Wednesday, April 04, 2001 1:06 PM
To: Multiple recipients of list ORACLE-L
Not as far as I know John, if so I should think it would be
a part of the
ALTER USER command, and there is no listing for this in any
manual or book I
have read.
List correct me if I'm wrong, as I'd love to see this too..
Regards
Mark
-----Original Message-----
Sent: Wednesday, April 04, 2001 04:41
To: Multiple recipients of list ORACLE-L
Is it possible to set a default index tablespace, rather
than specify it in
the create table statement?
Database is 8.1.7
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: japplewhite_at_inetprofit.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 04 2001 - 13:47:53 CDT