Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Unanswered: dropping a snapshot

    I have create a snapshot
    such as
    SQL>create snapshot tab_s as select * from tab;

    then I rename it
    SQL>alter snapshot tab_s rename to tab_s2;

    and drop the old snapshot
    SQL>drop snapshot tab_s;

    Now,the problem is
    I have no way to drop the snapshot call tab_s2

    SQL>drop snashot tab_s2;
    ERROR:ORA-12003:
    SQL>drop table tab_s2;
    ERROR:ORA-12083:

  2. #2
    Join Date
    Jul 2003
    Posts
    4

    Re: dropping a snapshot

    Originally posted by rollingpig
    I have create a snapshot
    such as
    SQL>create snapshot tab_s as select * from tab;

    then I rename it
    SQL>alter snapshot tab_s rename to tab_s2;

    and drop the old snapshot
    SQL>drop snapshot tab_s;

    Now,the problem is
    I have no way to drop the snapshot call tab_s2

    SQL>drop snashot tab_s2;
    ERROR:ORA-12003:
    SQL>drop table tab_s2;
    ERROR:ORA-12083:
    http://metalink.oracle.com/metalink/...atabase_id=BUG

    it is a bug of oracle
    no way to fix it!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •