{"width":"100%","blog_url":"https://cynipe.hateblo.jp/","provider_name":"Hatena Blog","blog_title":"cynipe\u3068\u8aad\u3080","url":"https://cynipe.hateblo.jp/entry/20071101/1193900034","title":"\u30b4\u30df\u7bb1\uff08BIN$XXXX\uff09","author_url":"https://blog.hatena.ne.jp/cynipe/","provider_url":"https://hatena.blog","author_name":"cynipe","categories":["DB","oracle"],"image_url":null,"type":"rich","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fcynipe.hateblo.jp%2Fentry%2F20071101%2F1193900034\" title=\"\u30b4\u30df\u7bb1\uff08BIN$XXXX\uff09 - cynipe\u3068\u8aad\u3080\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2007-11-01 15:53:54","version":"1.0","description":"10g\u3060\u3068\u8868\u3092DROP\u3057\u3066\u3082BIN$XXXX\u3068\u304b\u3063\u3066\u540d\u524d\u3067\u6b8b\u308b\u3002 SQL>DROP TABLE hoge; \u8868\u304c\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002 SQL> FLASHBACK TABLE hoge TO BEFORE DROP \u30d5\u30e9\u30c3\u30b7\u30e5\u30d0\u30c3\u30af\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 SQL> SELECT table_name FROM user_tables WHERE table_name = 'HOGE'; TABLE_NAME ------------------------------------------------------------ HOGE \u3093\u30fc\u3001\u78ba\u304b\u306b\u4fbf\u5229\u306a\u3093\u3060\u3051\u3069\u3001\u77e5\u3089\u306a\u3044\u3068\u305a\u3063\u3068\u30b4\u30df\u6b8b\u3063\u3061\u3083\u3046\u3088\u306d\u3053\u308c\u2026"}