| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: More Partition attached to a synonym.
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.
>>> dave.morgan_at_cybersurf.net 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 529-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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Binley Lim INET: Binley.Lim_at_ird.govt.nz 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).Received on Thu Aug 09 2001 - 21:04:02 CDT
 |
 |