Dennis This command doesn't apply on DOMAIN INDEX. Thx -sEEMA
>From: DENNIS WILLIAMS <[EMAIL PROTECTED]> >To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >Subject: RE: ORA-29857 >Date: Mon, 11 Feb 2002 17:02:05 -0600 > >Sure. >alter index XXXXX rebuild tablespace NEW; > >-----Original Message----- >From: Seema Singh [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 11, 2002 3:40 PM >To: Multiple recipients of list ORACLE-L >Subject: RE: ORA-29857 > > >Hi >can I change tablespace of domain index? >If one users names product has 4 domain indexes.If i drop those 4 indexes >then we can import those indexes or not? >Thx >-sEEMA > > >From: "Whittle Jerome Contr NCI" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >CC: <[EMAIL PROTECTED]> > >Subject: RE: ORA-29857 > >Date: Mon, 11 Feb 2002 13:46:07 -0600 > > > >select distinct owner, segment_name, segment_type > >from dba_extents > >where tablespace_name = 'ASIFDEV'; > > > >HTH, > > > >Jerry Whittle > >ACIFICS DBA > >NCI Information Systems Inc. > >[EMAIL PROTECTED] > >618-622-4145 > > > > > -----Original Message----- > > > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > > > > > > Hi > > > When I was trying to drop the tablespace I see following error > > > "ORA-29857: domain indexes and/or secondary objects exist in the > >tablespace" > > > Which View contains the domain indexes?,DBA_INDEXES etc or other > > > How tom find indexes which created secondary objects in a tablespace? > > > Please suggest what I do. > > > Thx > > > -Seema > > > > >_________________________________________________________________ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Seema Singh > 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). _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
