Re: cannot drop snapshot with partition.

From: orclbabu <orclbabu_at_hotmail.com>
Date: Fri, 01 Jun 2001 12:51:00 -0700
Message-ID: <F001.0031865B.20010601120326@fatcity.com>

do this

create table <your_snapshot_name> (test number); drop table <your_snapshot_name>

now you would be able to recreate the snapshot. i have seen this on 8.1.5. maybe its still there on 8162

babu

> > -!---- "Naik, Sandesh S" <sandesh.naik_at_qwest.com> 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: sandesh.naik_at_qwest.com
> > -!->
> > -!-> 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).

> > -!-
> > -!-
> > -!-__________________________________________________
> > -!-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: abardeen1_at_yahoo.com
> > -!-
> > -!-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: Jared Still
>   INET: jkstill_at_cybcon.com
>
> 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: orclbabu
  INET: orclbabu_at_hotmail.com

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 Fri Jun 01 2001 - 14:51:00 CDT