Hi,
Could some help to alter the default tablespace of an
IOT?
I have an partitioned IOT for which I specifed
tablespce for all partitions but no default tablespace
for the table. It has somehow latched on to another
tablespace as default although no data of IOT go to
that tablespace as I have specified tablespaces for
all partitions of the IOT. But I am not able to change
the default tablespace for the IOT. I want to do a
tablespace transport for the tablespace to which this
IOT has latched on and could not do it as that
tablespace is not self contained.
Any ideas?
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
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).
