DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Flashback Drop not working

  1. 07-06-2004, 06:50 AM #1
    Vipassana
    Vipassana is offline Member
    Join Date
    Jul 2003
    Posts
    134

    Flashback Drop not working

    I have the Flashback Recovery Area setup (Archivelog mode and the logs are getting generated).

    But when I drop a table and say SQL> SHOW RECYCLEBIN, it says there are no objects in the recycle bin.

    Can anyone tell me what could be the issue?

    Many thanks,
    Vipassana
    Reply With Quote Reply With Quote
  2. 07-06-2004, 10:40 AM #2
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Metalink forum says " Table must exist in a locally managed tablespace"
    And Set compatiable to 10.1.0.0
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width