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
--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
