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