Even though it looks like a mess, I think you can clean things up nicely by dropping
the table, and the synonym.
The synonym has been created as type 20 (when it should be 19), but when you do a drop
table, it does not appear to have any problems cleaning out the 19s and the 20s
(probably by some fluke that 20 is an index partition which gets dropped with the
table).
You can test this by tracking the dictionary tables, obj$, partobj$, tab$, tabpart$,
ind$, indpart$, seg$, before creating the situation, during, and after the drop, but
of course you need to work this through with Oracle Support.
>>> [EMAIL PROTECTED] 08/10/01 04:55AM >>>
Hi All,
First off I did not receive the digest last night
so if someone could forward me the digest or resend
any emails on this topic directly to me it would be greatly
appreciated.
In summary, a table partitioned on the first of every month
had a partition added when using a synonym name in the ALTER TABLE
ADD PARTITION statement.
The partition shows up in DBA_TAB_PARTITIONS associated with the
synonym name
There is no entry in DBA_SEGMENTS for the partition.
The partition is currently 800MB in size and holds 15 million rows
DML and data access on/to the data in the partition is fine.
from OBJ$, the 2 problem entries and a good one
OBJ# DATAOBJ# OWNER# NAME NAMESPACE SUBNAME TYPE#
CTIME
---- -------- ------ ------------- ---------- ------------------ -----
-------
3383 39 IMPRESSIONS 1 5
29-MAR-01
20817 20817 39 IMPRESSIONS 1 IMPRESSIONS_2001_08 20
23-JUL-01
20578 20943 39 IMPRESSIONS_TAB 1 IMPRESSIONS_2001_06 19
29-MAY-01
IMPRESSIONS is a private synonym (owned by the table owner) for
IMPRESSIONS_TAB
I do have a copy of the data, so I can drop the synonym., table and
tablespace
but I am worried about my data dictionary.
TIA
Dave
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
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).
