{"id":422,"date":"2013-10-22T11:09:02","date_gmt":"2013-10-22T20:09:02","guid":{"rendered":"\/blog\/?p=422"},"modified":"2023-09-21T09:38:50","modified_gmt":"2023-09-21T00:38:50","slug":"oracle-data-dictionary-2","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=422","title":{"rendered":"Oracle Data Dictionary"},"content":{"rendered":"\n\n\n\n\n <\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">ddd<\/span><\/title><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><h4><i>\ucd9c\ucc98 : <a class=\"tx-link\" target=\"_blank\" href=\"http:\/\/www.oracleclub.com\/lecture\/1520\" rel=\"noopener\">http:\/\/www.oracleclub.com\/lecture\/1520<\/a><br \/><\/i><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"><\/span><\/h4><h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\ub370\uc774\ud130 \uc0ac\uc804(Data Dictionary)\uc774\ub780<\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> \ub370\uc774\ud130 \uc0ac\uc804(Data Dictionary)\uc774\ub780 \ub300\ubd80\ubd84 \uc77d\uae30\uc804\uc6a9\uc73c\ub85c \uc81c\uacf5\ub418\ub294\n\ud14c\uc774\ube14 \ubc0f \ubdf0\ub4e4\uc758 \uc9d1\ud569\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\ubc18\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5 \ud55c\ub2e4. <\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uba85\ub839\uc774 \uc2e4\ud589 \ub420 \ub54c \ub9c8\ub2e4 \ub370\uc774\ud130 \uc0ac\uc804\uc744 Access\n\ud55c\ub2e4. <\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> DB\uc791\uc5c5\ub3d9\uc548 Oracle\uc740 \ub370\uc774\ud130 \uc0ac\uc804\uc744 \uc77d\uc5b4 \uac1d\uccb4\uc758 \uc874\uc7ac\uc5ec\ubd80\uc640 \uc0ac\uc6a9\uc790\uc5d0\uac8c\n\uc801\ud569\ud55c Access \uad8c\ud55c\uc774 \uc788\ub294\uc9c0\ub97c \ud655\uc778 \ud55c\ub2e4. \ub610\ud55c Oracle\uc740 \ub370\uc774\ud130 \uc0ac\uc804\uc744 \uacc4\uc18d \uac31\uc2e0\ud558\uc5ec DATABASE \uad6c\uc870, \uac10\uc0ac,\n\uc0ac\uc6a9\uc790\uad8c\ud55c, \ub370\uc774\ud130\ub4f1\uc758 \ubcc0\uacbd \uc0ac\ud56d\uc744 \ubc18\uc601 \ud55c\ub2e4. <\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> \ub370\uc774\ud130 \uc0ac\uc804\uc5d0 \uc800\uc7a5\ub418\ub294 \ub0b4\uc6a9\uc740 \uc544\ub798\uc640 \uac19\ub2e4.<\/span><\/h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><ul class=\"lecture_ul\">\n\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - \uc624\ub77c\ud074\uc758 \uc0ac\uc6a9\uc790 \uc815\ubcf4<\/span><\/li>\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - \uc624\ub77c\ud074 \uad8c\ud55c\uacfc \ub864 \uc815\ubcf4<\/span><\/li>\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8 \uac1d\uccb4(TABLE, VIEW, INDEX, CLUSTER, SYNONYM,\nSEQUENCE..) \uc815\ubcf4 <\/span><\/li>\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - \ubb34\uacb0\uc131 \uc81c\uc57d\uc870\uac74\uc5d0 \uad00\ud55c \uc815\ubcf4<\/span><\/li>\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc870 \uc815\ubcf4<\/span><\/li>\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud568\uc218 \uc640 \ud504\ub85c\uc9c0\uc800 \ubc0f \ud2b8\ub9ac\uac70\uc5d0 \ub300\ud55c \uc815\ubcf4<\/span><\/li>\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - \uae30\ud0c0 \uc77c\ubc18\uc801\uc778 DATABASE \uc815\ubcf4<\/span><\/li>\n<\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\ub370\uc774\ud130 \uc0ac\uc804\uc758 \ubd84\ub958 <\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">ALL_XXXX<\/span><\/h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> ALL_\ub85c \uc2dc\uc791\ud558\ub294 \ub370\uc774\ud130 \uc0ac\uc804\uc73c\ub85c, \ud55c \ud2b9\uc815 \uc0ac\uc6a9\uc790\uac00 \uc870\ud68c \uac00\ub2a5\ud55c \ubaa8\ub4e0\n\ub370\uc774\ud130\uc0ac\uc804\uc744 \uc758\ubbf8 \ud55c\ub2e4.<\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> \uc790\uc2e0\uc774 \uc870\ud68c\ud558\ub824\ub294 \uac1d\uccb4\uc758 \uc8fc\uc778\uc774 \uc544\ub2c8\ub354\ub77c\ub3c4 \uadf8 \uac1d\uccb4\uc5d0 \uc811\uadfc \ud560 \uc218 \uc788\ub294\n\uad8c\ud55c\uc744 \uac00\uc9c0\uace0 \uc788\ub2e4\uba74 ALL_XXXX \ubdf0\ub97c \ud1b5\ud558\uc5ec \uc870\ud68c\uac00 \uac00\ub2a5 \ud558\ub2e4.<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><div id=\"highlighter_47598\" class=\"syntaxhighlighter sql\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><div class=\"toolbar\"><span><\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n <tbody>\n <tr>\n <td class=\"gutter\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number1 index0 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">1<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number2 index1 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">2<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number3 index2 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">3<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/td>\n <td class=\"code\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"container\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number1 index0 alt2\"><code class=\"sql comments\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">--\nscott \uc0ac\uc6a9\uc790\ub85c \uc811\uc18d\ud558\uc5ec \uc544\ub798 SQL\ubb38\uc7a5\uc744 \uc2e4\ud589\ud574 \ubcf4\uc790.    <\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number2 index1 alt1\"><code class=\"sql keyword\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">SELECT<\/span><\/code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><code class=\"sql plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">table_name, tablespace_name <\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number3 index2 alt2\"><code class=\"sql spaces\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">  <\/span><\/code><code class=\"sql keyword\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">FROM<\/span><\/code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><code class=\"sql plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">ALL_TABLES;<\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/td>\n <\/tr>\n <\/tbody>\n<\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">USER_XXXX<\/span><\/h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> USER_\ub85c \uc2dc\uc791\ud558\ub294 \ub370\uc774\ud130 \uc0ac\uc804\uc73c\ub85c, \ud55c \ud2b9\uc815 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc885\uc18d\ub418\uc5b4 \uc788\uace0,\n\uadf8 \uc0ac\uc6a9\uc790\uac00 \uc870\ud68c \uac00\ub2a5\ud55c \ub370\uc774\ud130 \uc0ac\uc804 \ubdf0\ub4e4\ub85c ALL_XXXX \ub370\uc774\ud130 \uc0ac\uc804\uc758 \ubaa8\ub4e0 \uc815\ubcf4\uc758 \ubd80\ubd84 \uc9d1\ud569 \uc774\ub2e4.<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><div id=\"highlighter_913816\" class=\"syntaxhighlighter sql\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><div class=\"toolbar\"><span><\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n <tbody>\n <tr>\n <td class=\"gutter\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number1 index0 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">1<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number2 index1 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">2<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number3 index2 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">3<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/td>\n <td class=\"code\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"container\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number1 index0 alt2\"><code class=\"sql comments\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">--\nscott \uc0ac\uc6a9\uc790\ub85c \uc811\uc18d\ud558\uc5ec \uc544\ub798 SQL\ubb38\uc7a5\uc744 \uc2e4\ud589\ud574 \ubcf4\uc790.    <\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number2 index1 alt1\"><code class=\"sql keyword\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">SELECT<\/span><\/code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><code class=\"sql plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">table_name, tablespace_name <\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number3 index2 alt2\"><code class=\"sql spaces\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">  <\/span><\/code><code class=\"sql keyword\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">FROM<\/span><\/code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><code class=\"sql plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">USER_TABLES;<\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/td>\n <\/tr>\n <\/tbody>\n<\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">DBA_XXXX<\/span><\/h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> DBA\uad8c\ud55c\uc744 \uac00\uc9c4 \uc0ac\uc6a9\uc790 \ub9cc\uc774 \uc870\ud68c\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130 \uc0ac\uc804\uc73c\ub85c\uc11c \ubaa8\ub4e0 \uc624\ub77c\ud074\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ubcfc \uc218 \uc788\ub2e4.<\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> SELECT ANY TABLE \uad8c\ud55c\uc774 \uc788\ub294 \uc0ac\uc6a9\uc790 \ub610\ud55c \uc9c8\uc758\uac00 \uac00\ub2a5 \ud558\uba70\n\ub2e4\ub978 \uc0ac\uc6a9\uc790\uac00 \uc9c8\uc758 \ud558\ub824\uba74 \uc55e\uc5d0 SYS.\uc774\ub77c\ub294 \uc811\ub450\uc5b4\ub97c \ubd99\uc5ec\uc57c \ud55c\ub2e4.<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><div id=\"highlighter_638092\" class=\"syntaxhighlighter sql\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><div class=\"toolbar\"><span><\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n <tbody>\n <tr>\n <td class=\"gutter\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number1 index0 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">1<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number2 index1 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">2<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number3 index2 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">3<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/td>\n <td class=\"code\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"container\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number1 index0 alt2\"><code class=\"sql comments\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">--\nSYS\uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud558\uc5ec \uc544\ub798 \ubb38\uc7a5\uc744 \uc2e4\ud589\ud574 \ubcf4\uc790<\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number2 index1 alt1\"><code class=\"sql keyword\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">SELECT<\/span><\/code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><code class=\"sql plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">OWNER, OBJECT_NAME <\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><div class=\"line number3 index2 alt2\"><code class=\"sql spaces\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">  <\/span><\/code><code class=\"sql keyword\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">FROM<\/span><\/code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><code class=\"sql plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">SYS.DBA_OBJECTS;<\/span><\/code><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n <\/span><\/td>\n <\/tr>\n <\/tbody>\n<\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">V$_XXXX <\/span><\/h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> Dynamic Performance View\ub77c\uace0\ub3c4 \ud558\uba70, \ud604\uc7ac\nDatabase\uc758 \uc0c1\ud0dc\uc5d0 \uad00\ud55c \uc815\ubcf4\ub85c \uc8fc\ub85c DBA\uc5d0\uac8c\ub9cc \uc561\uc138\uc2a4\uac00 \ud5c8\uc6a9\ub418\uc5b4 \uc788\ub2e4.<\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> \uc8fc\ub85c DBA\uc758 \ubaa8\ub2c8\ud130\ub9c1 \uc791\uc5c5\uc6a9 \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uba70, X$ \ud14c\uc774\ube14\uc744 \ubca0\uc774\uc2a4\ub85c \ud558\ub294\n\ubdf0\uc774\ub2e4.<\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">X$_XXXX <\/span><\/h6><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> X$ \ubdf0\ub294 V$ \ubdf0\uac00 \ubcf4\uc5ec\uc8fc\uc9c0 \uc54a\ub294 \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc900\ub2e4.<\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> X$ \ud14c\uc774\ube14\uc740 \uc624\ub77c\ud074\uc758 \uba54\ubaa8\ub9ac\uc815\ubcf4\ub97c \ubcfc \uc218\uc788\ub294 SQL \uc778\ud130\ud398\uc774\uc2a4 \ubdf0\ub4e4\ub85c\nOracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uac00\uc7a5 \uc228\uaca8\uc9c4 \uc601\uc5ed \uc911 \ud558\ub098\uc774\ub2e4.<\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> <\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">Oracle Database \uc804\uccb4 \ub370\uc774\ud130\uc0ac\uc804 <\/span><\/h4><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><ul class=\"lecture_ul\">\n\n <li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\"> - <\/span><a class=\"tx-link\" href=\"http:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/index.htm\" target=\"_blank\" rel=\"noopener\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">http:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/index.htm<\/span><\/a><\/li>\n<\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; font-size: 10pt;\">\n\n<\/span><p><br \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ddd \ucd9c\ucc98 : http:\/\/www.oracleclub.com\/lecture\/1520 \ub370\uc774\ud130 \uc0ac\uc804(Data Dictionary)\uc774\ub780 \ub370\uc774\ud130 \uc0ac\uc804(Data Dictionary)\uc774\ub780 \ub300\ubd80\ubd84 \uc77d\uae30\uc804\uc6a9\uc73c\ub85c \uc81c\uacf5\ub418\ub294 \ud14c\uc774\ube14 \ubc0f \ubdf0\ub4e4\uc758 \uc9d1\ud569\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\ubc18\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5 \ud55c\ub2e4. \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uba85\ub839\uc774 \uc2e4\ud589 \ub420 \ub54c \ub9c8\ub2e4 \ub370\uc774\ud130 \uc0ac\uc804\uc744 Access \ud55c\ub2e4. DB\uc791\uc5c5\ub3d9\uc548 Oracle\uc740 \ub370\uc774\ud130 \uc0ac\uc804\uc744 \uc77d\uc5b4 \uac1d\uccb4\uc758 \uc874\uc7ac\uc5ec\ubd80\uc640 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc801\ud569\ud55c Access \uad8c\ud55c\uc774 \uc788\ub294\uc9c0\ub97c \ud655\uc778 \ud55c\ub2e4. \ub610\ud55c Oracle\uc740 \ub370\uc774\ud130 \uc0ac\uc804\uc744 \uacc4\uc18d \uac31\uc2e0\ud558\uc5ec DATABASE […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-422","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=422"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/422\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}