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 <rgramolini_at_tax.state.vt.us> 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"
> <ORACLE-L_at_fatcity.com>
> 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 <rgramolini_at_tax.state.vt.us>
> 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"
> > > <ORACLE-L_at_fatcity.com>
> > > 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_at_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_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).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > > INET: rgramolini_at_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_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).
> >
> >
> > __________________________________________________
> > 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_at_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_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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_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_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).
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_at_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_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 Thu Feb 15 2001 - 20:07:14 CST
