{"id":4379,"date":"2019-01-15T15:03:42","date_gmt":"2019-01-15T06:03:42","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4379"},"modified":"2019-01-15T15:03:43","modified_gmt":"2019-01-15T06:03:43","slug":"oracle-secure-file-%ed%99%9c%ec%9a%a9","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4379","title":{"rendered":"Oracle Secure File \ud65c\uc6a9"},"content":{"rendered":"
\n

\u00a0<\/span><\/span><\/p>\n<\/div>\n

\u00a0<\/span><\/p>\n

<\/a><\/a>1<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ud14c\uc2a4\ud2b8<\/span><\/span><\/span>\ud658\uacbd<\/span><\/span><\/span><\/span><\/h1>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>\uc11c\ubc84<\/span><\/span> : IBM,8202-E4B (8192M)<\/span><\/span><\/p>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>\uc6b4\uc601\uccb4\uc81c<\/span><\/span> : Aix 6.1 TL 06<\/span><\/span><\/p>\n

n<\/span>\u00a0 <\/span><\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>\uc624\ub77c\ud074<\/span><\/span> : Oracle 11.2.0.3.0 Enterprise 64bit<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

<\/a>2<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Oracle Secure File <\/span><\/span>\uac1c\uc694<\/span><\/span><\/span><\/h1>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Oracle Database 11g<\/span><\/span>\uc5d0\uc11c\ub294<\/span> LOB <\/span>\ub370\uc774\ud130\u00a0<\/span>\uc720\ud615\uc744<\/span> Oracle Secure files\u00a0<\/span>\ub85c\u00a0<\/span>\uc644\uc804\ud788\u00a0<\/span>\uc0c8\ub86d\uac8c\u00a0<\/span>\uc124\uacc4\ud558\uc5ec\u00a0<\/span>\uc131\ub2a5\uacfc\u00a0<\/span>\uad00\ub9ac\u00a0<\/span>\ud6a8\uc728\uc131\u00a0<\/span>\ub300\ud3ed\ud5a5\uc0c1<\/span><\/span>.<\/span><\/span><\/p>\n\n\n\n
\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ub514\uc2a4\ud06c<\/span><\/span> \ud615\uc2dd<\/span> – <\/span>\uac00\ubcc0\u00a0<\/span>\uc870\uac01\u00a0<\/span><\/span>\ud06c\uae30<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ub124\ud2b8\uc6cc\ud06c<\/span><\/span> \ud504\ub85c\ud1a0\ucf5c<\/span> – <\/span>\uc785<\/span>\/<\/span>\ucd9c\ub825<\/span><\/span>\ud5a5\uc0c1<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ubc84\uc804<\/span><\/span> \uc9c0\uc815\u00a0<\/span>\ubc0f\u00a0<\/span>\uacf5\uc720\u00a0<\/span><\/span>\uba54\ucee4\ub2c8\uc998<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\ub9ac\ub450<\/span><\/span> \ubc0f\u00a0<\/span>\uc5b8\ub450\u00a0<\/span>\uc54c\uace0\ub9ac\uc998<\/span> – <\/span>\uc720\uc800\u00a0<\/span>\uad6c\uc131\u00a0<\/span><\/span>\ubd88\ud544\uc694<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\uacf5\uac04<\/span><\/span> \ubc0f\u00a0<\/span>\uba54\ubaa8\ub9ac\u00a0<\/span>\uad00\ub828\u00a0<\/span>\ud5a5\uc0c1\ub41c\u00a0<\/span>\uae30\ub2a5<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\uae30\uc874<\/span><\/span>LOB<\/span>\uc758\u00a0<\/span>\ub370\uc774\ud130\uc758\u00a0<\/span>\uc911\ubcf5\uc131\u00a0<\/span><\/span>\uc81c\uac70<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>LOG <\/span><\/span>\ud30c\uc77c\uc744<\/span> Secure Files\u00a0<\/span>\ub85c\u00a0<\/span>\ucde8\uae09\ud560\uc9c0\u00a0<\/span>\uc5ec\ubd80\ub97c\u00a0<\/span>\uc9c0\uc815\ud558\ub824\uba74<\/span> DB_SECURE FILE <\/span>\ucd08\uae30\ud654\u00a0<\/span><\/span>\ud30c\ub77c\ubbf8\ud130\u00a0<\/span><\/span>\uc0ac\uc6a9\ud569\ub2c8\ub2e4<\/span><\/span>.<\/span><\/span><\/p>\n\n\n\n
\n

\"clip_image002[4]\"<\/a>\u00a0<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

<\/a>2.1<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Secure Files DB parameter <\/span><\/span>\uc635\uc158<\/span><\/span><\/span><\/h2>\n\n\n\n
\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Always : <\/span><\/span>\ubaa8\ub4e0<\/span> LOB<\/span>\ub97c<\/span> SecureFile LOB<\/span>\ub85c\u00a0<\/span>\uc0dd\uc131\ud558\uace0<\/span> ASSM<\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0\u00a0<\/span><\/span>\uc788\uc9c0 \uc54a\uc740<\/span><\/span>\u00a0<\/span><\/span>LOB<\/span><\/span>\ub294\u00a0<\/span>\ubaa8\ub4e0<\/span> SecureFile LOB<\/span>\uac00\u00a0<\/span><\/span>\ub418\ub3c4\ub85d\ud55c\ub2e4<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Force : <\/span><\/span>\uc0dd\uc131\ub418\uc5b4\u00a0<\/span>\uc804\ub2ec\ub418\ub294\u00a0<\/span>\ubaa8\ub4e0<\/span> LOB<\/span>\uac00<\/span> SecureFile LOB<\/span>\uac00\u00a0<\/span><\/span>\ub418\ub3c4\ub85d\ud55c\ub2e4<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Permitted : SecureFiles<\/span><\/span>\ub97c\u00a0<\/span>\uc0dd\uc131\ud560\u00a0<\/span>\uc218\u00a0<\/span>\uc788\ub3c4\ub85d\u00a0<\/span>\ud55c\ub2e4<\/span> (default <\/span>\uac12<\/span><\/span>)<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Naver : SecureFiles<\/span><\/span>\ub85c\u00a0<\/span>\uc9c0\uc815\ub418\ub294\u00a0<\/span>\ubaa8\ub4e0<\/span> LOB<\/span>\ub294<\/span> BasicFiles <\/span>\ub85c\u00a0<\/span><\/span>\uc0dd\uc131\ub41c\ub2e4<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Ignore : SecureFiles<\/span><\/span>\ub97c\u00a0<\/span>\ud5c8\uc6a9\ud558\uc9c0\u00a0<\/span>\uc54a\uc73c\uba70<\/span> SecureFiles <\/span>\uc635\uc158\uc744\u00a0<\/span>\uc0ac\uc6a9\ud558\uc5ec<\/span> Basic Files<\/span>\ub97c\u00a0<\/span><\/span>\uac15\uc81c\ub85c\u00a0<\/span><\/span>\u00a0<\/span><\/span><\/span>\ubcc0\ud658\ud558\ub294\u00a0<\/span>\uacbd\uc6b0\u00a0<\/span>\ubc1c\uc0dd\ud558\ub294\u00a0<\/span>\ubaa8\ub4e0\u00a0<\/span>\uc624\ub958\ub97c\u00a0<\/span><\/span>\ubb34\uc2dc<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

<\/a>2.2<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>SecureFIiles <\/span><\/span>\uc800\uc7a5\u00a0<\/span><\/span>\uc601\uc5ed\uc635\uc158<\/span><\/span>
\n<\/span><\/h2>\n\n\n\n
\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Maxsize : <\/span><\/span>\ucd5c\ub300<\/span> LOB <\/span>\uc138\ud06c\uba3c\ud2b8\u00a0<\/span>\ud06c\uae30\ub97c\u00a0<\/span><\/span>\uc9c0\uc815<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Retention : <\/span><\/span>\uc0ac\uc6a9\ud560<\/span> Retention <\/span><\/span>\uc815\ucc45\uc9c0\uc815<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>max : maxsize <\/span><\/span>\uc5d0\u00a0<\/span>\ub3c4\ub2ec\ud560\ub54c\uac00\uc9c0\u00a0<\/span>\uc774\uc804\u00a0<\/span>\ubc84\uc804\uc744\u00a0<\/span>\ud68c\uc218\ud558\ub294\ub370\u00a0<\/span><\/span>\uc0ac\uc6a9<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>min : <\/span><\/span>\uc9c0\uc815\ub41c\u00a0<\/span>\uc2dc\uac04\ub3d9\uc548\u00a0<\/span>\uc774\uc804\ubc84\uc804\uc744\u00a0<\/span><\/span>\ubcf4\uad00<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>auto : <\/span><\/span>\uae30\ubcf8\uc801\uc73c\ub85c\u00a0<\/span>\uacf5\uac04\uacfc\u00a0<\/span>\uc2dc\uac04\u00a0<\/span>\uac04\uc758\u00a0<\/span>\uade0\ud615\uc744\u00a0<\/span>\uc720\uc9c0\u00a0<\/span>\uc790\ub3d9\uc124\uc815<\/span> (default <\/span>\uac12<\/span><\/span>)<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>none : <\/span><\/span>\uc774\uc804\u00a0<\/span>\ubc84\uc804\uc744\u00a0<\/span>\uac00\ub2a5\ud55c\u00a0<\/span>\ub9cc\ud07c\u00a0<\/span><\/span>\uc7ac\uc0ac\uc6a9\ud55c\ub2e4<\/span><\/span><\/p>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>CHUNK, PCTVERSION : <\/span><\/span>\ub354\uc774\uc0c1\u00a0<\/span>\uc9c0\uc815\ud560\u00a0<\/span>\ud544\uc694\uac00\u00a0<\/span>\uc5c6\ub2e4\u00a0<\/span>\uae30\uc874\uc758<\/span>\u00a0 <\/span><\/span>\uc2a4\ud06c\ub9bd\ud2b8\uc640\uc758\u00a0<\/span><\/span>\ud638\ud658\uc131\uc744\u00a0<\/span><\/span>\uc704<\/span><\/span><\/span>\ud574\u00a0<\/span>\ub0a8\uaca8\ub460\u00a0<\/span>\uad6c\ubb38\uc774\u00a0<\/span>\ubd84\uc11d\ub418\uc9c0\ub9cc\u00a0<\/span>\ud574\uc11d\ub418\uc9c0\ub294\u00a0<\/span><\/span>\uc54a\ub294\ub2e4<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

<\/a>3<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Using SecureFiles<\/span><\/span><\/h1>\n

n<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>Securefile<\/span><\/span>\ub85c\u00a0<\/span>\uc774\uc6a9\ud558\uc5ec\u00a0<\/span>\uc911\ubcf5\uc81c\uac70<\/span>, <\/span>\uc911\ubcf5\ud5c8\uc6a9<\/span>,<\/span>\uc554\ud638\ud654<\/span>,<\/span>\uc555\ucd95\ub4f1\u00a0<\/span>\ub2e4\uc591\ud558\uac8c\u00a0<\/span><\/span>\uc0ac\uc6a9\ud560\uc218\uc788\ub2e4<\/span><\/span><\/p>\n

<\/a>3.1<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span>\uae30\uc874\uc758<\/span><\/span> LOB<\/span><\/span>\ud14c\uc774\ube14\uc744<\/span> Secure file<\/span><\/span>\ub85c\u00a0<\/span><\/span><\/span>\uc774\uad00<\/span><\/span><\/span><\/h2>\n