Sandesh,
This is a known bug (1335477) that allows you to
rename a snapshot/materialized view, which you
shouldn't be allowed to do. What you've got now is
data dictionary corruption because not all of the data
dictionary entries were changed when the snapshot was
renamed.
You can try renaming the snapshot back to its original
name, but I suspect you'll get an error that the
object already exists.
Your only option, other than a PITR prior to when the
snapshot was renamed, is probably to log a tar with
support so they can walk you through correcting the
data dictionary corruption. This is not something I'd
advise trying on your own unless you can afford to
lose this db.
HTH,
-- Anita
--- "Naik, Sandesh S" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have a 8.1.6.2 database on hp9000. (11.0). I
> have created one snapshot ,
> with partition. Now I not able to drop snapshot or
> nor I cam drop last
> partition.
> It does not show that snapshot in dba_snapshot. I
> renamed the snapshot to
> old. But "drop snapshot is not working
> SQL> drop snapshot old;
> drop snapshot old
> *
> ERROR at line 1:
> ORA-12003: snapshot "SYS"."OLD" does not exist
> If I try to drop the table then it gives this error
> SQL> drop table old;
> drop table old
> *
> ERROR at line 1:
> ORA-12083: must use DROP MATERIALIZED VIEW to drop
> "SYS"."OLD"
>
> Does somebody has encountered this error or has
> solution to this problem.
>
> Sandesh
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Naik, Sandesh S
> 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).
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
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).
