Hi All,
Just found an archive at
http://faqchest.dynhost.com/prgm/oracle-l
To answer Jonathan's questions:
It is an LMT
It is a standard partitioned table.
I know the tablespace the segment is in so I can get rid of it.
I can extract the data from the segment.
My main worry is data dictionary consistency after I clean up.
Off to research DBMS_SPACE_ADMIN
Thanks
Dave
Jonathan Lewis wrote
> Remind me,
> Is it a locally managed tablespace ?
> If so, get on to Oracle about the following idea.
> a) Export the data from the extent
> b) Use dbms_space_admin to make the non-existent
> segment appear/disappear
>
> If not, is there even an entry in UET$ for the
> extent ?
>
> Is this a standard partiitoned table, or a
> partitioned IOT ? If standard, there MUST
> be a segment, because dba_tab_partitions
> CANNOT report a partition without joining
> to the matching seg$ row.
>
> Jonathan Lewis
>
> Clearly this hasn't happened ;)
>
> But if the item shows up in dba_tab_partitions
> then there is a data segment linked to the
> partition.
>
> Get the SQL from the view dba_tab_partitions,
> you will see that the first section of the 3 unions
> is for tabpart$, and it joins tabpart$ to seg$
> on file#' and block#.
>
> Clip out this bit of the sql, and select out
> the file# and block# for the funny partition.
>
> Then use those values to query the
> file and block against dba_segments to
> find out what data segment is actually
> being referenced.
--
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dave Morgan
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).
