Partition attached to SYNONYM

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: dave.morgan_at_cybersurf.net

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).