From joni_65@yahoo.com Thu, 15 Feb 2001 18:07:14 -0800 From: Johnson Poovathummoottil Date: Thu, 15 Feb 2001 18:07:14 -0800 Subject: Re: How to alter default tablespace of IOT? Message-ID: MIME-Version: 1.0 Content-Type: text/plain This is not exactly what I was asking. May be a longer explanation helps to understand the situation better. I want to transport a tablespace SALES_TS which contains SALES_TABLE. When I test the to see whether it is self contained or not. I get the a voilation saying that MY_TABLE which is a Partioned index organized table is partially contained in SALES_TS. I checked the creation scripts and the data dictionary tables to see if MY_TABLE has any partitions for which the default tablespace as SALES_TS. I find none. I try to modify default attributes of the MY_TABLE and I get the error that I cannot do that for an index organized table. I try to do the same on the index name of IOT and I get the same error. So the question How do I change the defalut tablespace of the index organized table without recreating the table.? . --- Ruth Gramolini wrote: > select default_tablespace from dba_users where > user_name='YOUR_USER'; > > If this is not where you want stuff created then > you can change the default > tablespace: > alter user 'YOUR_USER' default tablespace > 'DESIRED_TABLESPACE'; > > hth, > Ruth > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > > Sent: Thursday, February 15, 2001 3:06 PM > > > > It would have gone to user defalut tablespace, had > I > > not given specific tablespaces for the partitions. > > > > Is there a data dictionary view which tells the > > default tablespace of a table? > > > > --- Ruth Gramolini > wrote: > > > It will go into the default tablespace of the > > > creator of the index. > > > > > > HTH, > > > Ruth > > > ----- Original Message ----- > > > To: "Multiple recipients of list ORACLE-L" > > > > > > Sent: Thursday, February 15, 2001 1:16 PM > > > > > > > > > > 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: joni_65@yahoo.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@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). > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Ruth Gramolini > > > INET: rgramolini@tax.state.vt.us > > > > > > 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@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). > > > > > > __________________________________________________ > > 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: joni_65@yahoo.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@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). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: rgramolini@tax.state.vt.us > > 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@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). __________________________________________________ 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: joni_65@yahoo.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@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).