sky's profileDBA日记PhotosBlogListsMore Tools Help
    8/1/2008

    10g的recyclebin

    1.启用&关闭回收站
       10gR1:_recyclebin=true/false (隐含参数)
       10gR2:   recyclebin=on/on  (常规动态参数)

    2.视图  recyclebin,dba_recyclebin,user_recyclebin;

    3.flashback table功能
       flashback table t1 to before drop rename to t2;

    4.限制条件
        undo_management=auto
        删除user时,user下的表不会放到recyclebin中
        删除cluster时,cluster的成员表不会放到recyclebin中
        删除type时,相关的对象不会放到recyclebin中。

    5.清除recyclebin中的对象。
       purge table BIN$jsleilx392mk2=293$0;
       purge table table_name;
       purge tablespace tbs1;
       purge recyclebin;( as sysdba)

    Comments

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up

    Trackbacks

    The trackback URL for this entry is:
    http://dbadiary.spaces.live.com/blog/cns!A3ECB1FE1E761C58!1267.trak
    Weblogs that reference this entry
    • None