Re: cannot drop snapshot with partition.

[Henrik Ekenberg <[EMAIL PROTECTED]>]

Hello,

We had the same problem and here comes one solution :

0. Pray !!!
1. Full backup
2. -- Change u.name and o.name
UPDATE tab$ t
set t.property = t.property - 67108864
where bitand(t.property, 67108864) = 67108864
and t.obj# =  (select o.obj# from sys.user$ u , sys.obj$ o
                 where u.user# = o.owner#
                  and o.obj# = t.obj#
                   and u.name = 'SC'
                   and o.name = 'STOCKS');
commit;


Good luck ..

Regards
Henrik
---------------------------------------------------------------------------
Henrik Ekenberg                                 Anoto AB
www.anoto.com

On Thu, 31 May 2001, A. Bardeen wrote:

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henrik Ekenber
  INET: [EMAIL PROTECTED]>" <[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).