{"id":3233,"date":"2018-02-03T23:26:12","date_gmt":"2018-02-03T14:26:12","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3233"},"modified":"2018-02-03T23:26:12","modified_gmt":"2018-02-03T14:26:12","slug":"oracle-tde-oracle-10g","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3233","title":{"rendered":"Oracle TDE ( oracle 10g )"},"content":{"rendered":"\n\n<\/colgroup>\n\n\n
\n

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

Transparent Data Encryption<\/span><\/p>\n

\ud22c\uba85\ud55c<\/span>\u00a0\ub370\uc774\ud130\u00a0\uc554\ud638\ud654<\/span>\u00a0<\/span><\/p>\n

\ub2e8<\/span>\u00a0\ud55c\u00a0\uc904\uc758\u00a0\ucf54\ub4dc\ub3c4\u00a0\uc791\uc131\ud558\uc9c0\u00a0\uc54a\uace0\u00a0\uae30\ubc00\u00a0\ub370\uc774\ud130\ub97c\u00a0\ud22c\uba85\ud558\uac8c\u00a0\uc554\ud638\ud654\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\ub204\uad70\uac00\uac00<\/span>\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\ubc31\uc5c5\u00a0\ud14c\uc774\ud504\ub97c\u00a0\ud6d4\uccd0\uac00\ub294\u00a0\uac83\uc740\u00a0\uc870\uc9c1\uc5d0\uac8c\ub294\u00a0\ucd5c\uc545\uc758\u00a0\uc545\ubabd\uc785\ub2c8\ub2e4.
\n\ubb3c\ub860\u00a0\ubcf4\uc548\u00a0\uc2dc\uc2a4\ud15c\uc744\u00a0\uad6c\ucd95\ud558\uace0\u00a0\ub9e4\uc6b0\u00a0\uc911\uc694\ud55c\u00a0\uae30\ubc00\u00a0\uc790\uc0b0\uc740\u00a0\uc554\ud638\ud654\ud558\uace0\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\uc11c\ubc84\uc5d0\u00a0\ubc29\ud654\ubcbd\uc744\u00a0\uc124\uce58\ud588\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7ec\ub098\u00a0\uce68\uc785\uc790\uac00\u00a0\uc27d\uac8c\u00a0\uc811\uadfc\ud588\uc2b5\ub2c8\ub2e4.
\n\uce68\uc785\uc790\ub294\u00a0\ubc31\uc5c5\u00a0\ud14c\uc774\ud504\ub97c\u00a0\uac00\uc838\uac00\uc11c\u00a0\ud2c0\ub9bc\u00a0\uc5c6\uc774\u00a0\ub2e4\ub978\u00a0\uc11c\ubc84\uc5d0\uc11c\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\u00a0\ubcf5\uc6d0\ud558\uc5ec\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\u00a0\uc2dc\uc791\ud558\uace0\u00a0\ub290\uae0b\ud558\uac8c\u00a0\ub370\uc774\ud130\ub97c\u00a0\ubcf4\uace0\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7ec\ud55c\u00a0\uce68\uc785\uc790\ub85c\ubd80\ud130\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\ub370\uc774\ud130\ub97c\u00a0\ubcf4\ud638\ud558\ub294\u00a0\uac83\uc740\u00a0\ud6cc\ub96d\ud55c\u00a0\uc5c5\ubb34\ubc29\uc2dd\uc774\u00a0\uc544\ub2d9\ub2c8\ub2e4.
\n\uadf8\uac83\uc740\u00a0\ub300\ubd80\ubd84\uc758\u00a0\ubc95\ub960,
\n\uaddc\uc815,
\n\uc9c0\uce68\uc744\u00a0\uc900\uc218\ud558\uae30\u00a0\uc704\ud55c\u00a0\uc694\uad6c\u00a0\uc0ac\ud56d\uc785\ub2c8\ub2e4.
\n\uc774\ub7ec\ud55c\u00a0\ucde8\uc57d\uc131\uc73c\ub85c\ubd80\ud130\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\u00a0\uc5b4\ub5bb\uac8c\u00a0\ubcf4\ud638\ud560\u00a0\uc218\u00a0\uc788\uaca0\uc2b5\ub2c8\uae4c<\/span>? <\/span><\/p>\n

\ud55c<\/span>\u00a0\ud574\uacb0\ucc45\uc740\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\u00a0\uae30\ubc00\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud558\uace0\u00a0\ubcc4\ub3c4\uc758\u00a0\uc704\uce58\uc5d0\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc800\uc7a5\ud558\ub294\u00a0\uac83\uc785\ub2c8\ub2e4.
\n\uc554\ud638\ud654\u00a0\ud0a4\u00a0\uc5c6\uc774\u00a0\ud6d4\uccd0\uac04\u00a0\ub370\uc774\ud130\ub294\u00a0\uc4f8\ubaa8\uac00\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7ec\ub098\u00a0\ub450\u00a0\uc0c1\ubc18\ub41c\u00a0\uac1c\ub150\u00a0\uac04\uc758\u00a0\uade0\ud615\uc744\u00a0\uc720\uc9c0\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uadf8\u00a0\uac1c\ub150\uc774\ub780\u00a0\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774\u00a0\uc554\ud638\ud654\u00a0\ud0a4\uc5d0\u00a0\uc561\uc138\uc2a4\ud560\u00a0\uc218\u00a0\uc788\ub294\u00a0\ud3b8\ub9ac\uc131\uacfc\u00a0\ud0a4\u00a0\uc808\ub3c4\ub97c\u00a0\ubc29\uc9c0\ud558\ub294\ub370\u00a0\ud544\uc694\ud55c\u00a0\ubcf4\uc548\uc131\uc785\ub2c8\ub2e4.
\n\uadf8\ub9ac\uace0\u00a0\ud68c\uc0ac\uc640\u00a0\uc5f0\ubc29\u00a0\uc815\ubd80\u00a0\uaddc\uc815\uc744\u00a0\uc900\uc218\ud558\uae30\u00a0\uc704\ud574\u00a0\ubcf5\uc7a1\ud55c\u00a0\ucf54\ub529\u00a0\uc5c6\uc774\u00a0\uc989\uc2dc\u00a0\uc194\ub8e8\uc158\uc774\u00a0\ud544\uc694\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

Oracle Database 10<\/span>g Release
\n2\uc758\u00a0\uc0c8\ub85c\uc6b4\u00a0\uae30\ub2a5\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uadf8\ub807\uac8c\u00a0\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\ub2e8\u00a0\ud55c\u00a0\uc904\uc758\u00a0\ucf54\ub4dc\ub3c4\u00a0\uc791\uc131\ud558\uc9c0\u00a0\uc54a\uace0\u00a0\uc5f4\uc744\u00a0\uc554\ud638\ud654\ub428\uc73c\ub85c\u00a0\uc120\uc5b8\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc0ac\uc6a9\uc790\uac00\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc0bd\uc785\ud560\u00a0\ub54c\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00\u00a0\ud22c\uba85\ud558\uac8c\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud558\uc5ec\u00a0\uadf8\u00a0\uc5f4\uc5d0\u00a0\uc800\uc7a5\ud569\ub2c8\ub2e4.
\n\ub9c8\ucc2c\uac00\uc9c0\ub85c\u00a0\uc0ac\uc6a9\uc790\uac00\u00a0\uc5f4\uc744\u00a0\uc120\ud0dd\ud560\u00a0\ub54c\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc790\ub3d9\uc73c\ub85c\u00a0\ud574\ub3c5\ud569\ub2c8\ub2e4.
\n\uc774\ub7ec\ud55c\u00a0\ubaa8\ub4e0\u00a0\ud504\ub85c\uc138\uc2a4\uac00\u00a0\ud22c\uba85\ud558\uac8c\u00a0\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758\u00a0\ucf54\ub4dc\ub97c\u00a0\ubcc0\uacbd\ud558\uc9c0\u00a0\uc54a\uace0\u00a0\uc218\ud589\ub418\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\uc774\u00a0\uae30\ub2a5\uc5d0\ub294\u00a0\uc774\uc5d0\u00a0\uc798\u00a0\uc5b4\uc6b8\ub9ac\ub294 TDE(\ud22c\uba85\ud55c\u00a0\ub370\uc774\ud130\u00a0\uc554\ud638\ud654)\ub77c\ub294\u00a0\uc774\ub984\uc774\u00a0\ubd99\uc5ec\uc84c\uc2b5\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\uc791\ub3d9<\/span>\u00a0<\/span>\ubc29\uc2dd<\/span>\u00a0<\/span><\/p>\n

\uc804\uc5d0<\/span>\u00a0<\/span>Oracle
\nMagazine 1\/2\uc6d4\ud638 “\ub370\uc774\ud130\u00a0\uc790\uc0b0\uc758\u00a0\uc554\ud638\ud654<\/a><\/span>”
\n\uc5d0\uc11c\u00a0\uc554\ud638\ud654\u00a0\uae30\ucd08\uc5d0\u00a0\ub300\ud574\u00a0\ub2e4\ub8e8\uc5c8\uc2b5\ub2c8\ub2e4.
\n\uc8fc\uc694\u00a0\uc0ac\ud56d\uc744\u00a0\ub2e4\uc2dc\u00a0\uc124\uba85\ud558\uba74,
\n\uc554\ud638\ud654\ub294\u00a0\uc554\ud638\ud654\u00a0\uc54c\uace0\ub9ac\uc998\uacfc\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\u00a0\uc785\ub825\u00a0\ub370\uc774\ud130\uc5d0\u00a0\uc801\uc6a9\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uadf8\ub9ac\uace0\u00a0\uc554\ud638\ud654\ub41c\u00a0\uac12\uc744\u00a0\uc131\uacf5\uc801\uc73c\ub85c\u00a0\ud574\ub3c5\ud558\ub824\uba74\u00a0\ub3d9\uc77c\ud55c\u00a0\uc54c\uace0\ub9ac\uc998\uacfc\u00a0\ud0a4\u00a0\uac12\uc744\u00a0\uc54c\uc544\uc57c\u00a0\ud569\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\uadf8<\/span>\u00a0\uae30\uc0ac\uc5d0\uc11c\u00a0\uc800\ub294\u00a0\uc624\ub77c\ud074\uc774\u00a0\uc81c\uacf5\ud558\ub294\u00a0\uc554\ud638\ud654\u00a0\ud234\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc554\ud638\ud654\u00a0\uae30\ubc18\u00a0\uad6c\uc870\ub97c\u00a0\uad6c\ucd95\ud558\ub294\u00a0\ubc29\ubc95\uc744\u00a0\uc124\uba85\ud558\uc600\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7ec\ub098 Oracle Database 10<\/span>g Release
\n2\uc640 TDE\ub97c\u00a0\uc0ac\uc6a9\ud560\u00a0\uacbd\uc6b0\u00a0\uc554\ud638\ud654\u00a0\uae30\ubc18\u00a0\uad6c\uc870\ub97c\u00a0\uad6c\ucd95\ud560\u00a0\ud544\uc694\uac00\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.
\n\ub2e8\uc9c0\u00a0\uc554\ud638\ud654\ud560\u00a0\uc5f4\uc744\u00a0\uc815\uc758\ud558\uae30\ub9cc\u00a0\ud558\uba74Oracle
\nDatabase
\n10g\uc5d0\uc11c\u00a0\uadf8\u00a0\uc5f4\uc774\u00a0\ud3ec\ud568\ub41c\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\ub300\ud55c\u00a0\uc554\ud638\ud654\u00a0\ubc29\uc2dd\uc758\u00a0\uc548\uc804\ud55c\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc0dd\uc131\ud558\uace0\u00a0\uc9c0\uc815\ud55c\u00a0\uc554\ud638\ud654\u00a0\uc54c\uace0\ub9ac\uc998\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uadf8\u00a0\uc5f4\uc758\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud569\ub2c8\ub2e4.
\n\uc774\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\ubcf4\ud638\ud558\ub294\u00a0\uac83\uc774\u00a0\ub9e4\uc6b0\u00a0\uc911\uc694\ud569\ub2c8\ub2e4.
\nOracle Database
\n10g\ub294\u00a0\uc9c0\uac11\uc774\ub77c\uace0\u00a0\ubd80\ub974\ub294\u00a0\uc548\uc804\ud55c\u00a0\uc704\uce58\uc5d0\u00a0\uc800\uc7a5\ub418\ub294\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud569\ub2c8\ub2e4.
\n\uc774\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub294\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\uc11c\ubc84\uc758\u00a0\ud30c\uc77c\uc77c\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc554\ud638\ud654\ub41c\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub294\u00a0\ub370\uc774\ud130\u00a0\ub515\uc154\ub108\ub9ac\uc5d0\u00a0\uc800\uc7a5\ub429\ub2c8\ub2e4.
\n\uc0ac\uc6a9\uc790\uac00\u00a0\uc554\ud638\ud654\ub428\uc73c\ub85c\u00a0\uc815\uc758\ub41c\u00a0\uc5f4\uc5d0\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc785\ub825\ud560\u00a0\uacbd\uc6b0\u00a0\uadf8\ub9bc 1\uc5d0\uc11c\uc640\u00a0\uac19\uc774 Oracle
\nDatabase 10g<\/span>\uac00\u00a0\uc9c0\uac11\uc5d0\uc11c\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub97c\u00a0\uac00\uc838\uc640\u00a0\ub370\uc774\ud130\u00a0\ub515\uc154\ub108\ub9ac\uc758\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\ud574\ub3c5\ud558\uace0\u00a0\uc785\ub825\u00a0\uac12\uc5d0\u00a0\ub300\ud574\u00a0\uadf8\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc0ac\uc6a9\ud558\uace0\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\u00a0\uc554\ud638\ud654\ub41c\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc800\uc7a5\ud569\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n\n
\n

\"image0\"<\/a><\/p>\n<\/td>\n<\/tr>\n

\n

\uadf8\ub9bc<\/span> 1:
\nTDE(\ud22c\uba85\ud55c\u00a0\ub370\uc774\ud130\u00a0\uc554\ud638\ud654)
\n\uc791\ub3d9\u00a0<\/span>\ubc29\uc2dd<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\ud14c\uc774\ube14\uc758<\/span>\u00a0\ubaa8\ub4e0\u00a0\uc5f4\uc744\u00a0\uc554\ud638\ud654\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub9bc 1\uacfc\u00a0\uac19\uc774\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\uc5f4\uc774 4\uac1c\u00a0\uc788\uace0\u00a0\uc5f4 2\uc640 3\uc744\u00a0\uc554\ud638\ud654\ud560\u00a0\uacbd\uc6b0 Oracle
\nDatabase 10<\/span>g<\/span>\ub294\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\ub300\ud558\uc5ec\u00a0\ud558\ub098\uc758\u00a0\uc554\ud638\ud654\ub41c\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\uc0dd\uc131\ud558\uace0\u00a0\uadf8\u00a0\ud0a4\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\ub450\u00a0\uc5f4\uc744\u00a0\uc554\ud638\ud654\ud569\ub2c8\ub2e4.
\n\ub514\uc2a4\ud06c\uc5d0\u00a0\uc5f4 1\uacfc\u00a0\uc5f4 4\uc758\u00a0\uac12\uc744\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\ub85c\u00a0\uc800\uc7a5\ud558\uace0\u00a0\ub2e4\ub978\u00a0\ub450\u00a0\uc5f4\uc758\u00a0\uac12\uc740\u00a0\uc554\ud638\ud654\ub41c\u00a0\ud615\uc2dd\uc73c\ub85c\u00a0\uc800\uc7a5\ub429\ub2c8\ub2e4.
\n\ub370\uc774\ud130\uac00\u00a0\uc554\ud638\ud654\ub418\uc5b4\u00a0\uc800\uc7a5\ub418\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\ubc31\uc5c5\uacfc\u00a0\uc544\uce74\uc774\ube0c\ub41c\u00a0\ub85c\uadf8\u00a0\ub4f1\u00a0\ubaa8\ub4e0\u00a0\ub2e4\uc6b4\uc2a4\ud2b8\ub9bc\u00a0\uad6c\uc131\u00a0\uc694\uc18c\ub294\u00a0\uc554\ud638\ud654\ub41c\u00a0\ud615\uc2dd\uc744\u00a0\uac16\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\uc0ac\uc6a9\uc790\uac00<\/span>\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc744\u00a0\uc120\ud0dd\ud560\u00a0\uacbd\uc6b0 Oracle
\nDatabase 10<\/span>g<\/span>\ub294\u00a0\ud22c\uba85\ud558\uac8c\u00a0\ub370\uc774\ud130\u00a0\ub515\uc154\ub108\ub9ac\uc5d0\uc11c\u00a0\uc554\ud638\ud654\ub41c\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\uac80\uc0c9\ud558\uace0\u00a0\uc9c0\uac11\uc5d0\uc11c\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub97c\u00a0\uc778\ucd9c\ud55c\u00a0\ub2e4\uc74c\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\ud574\ub3c5\ud569\ub2c8\ub2e4.
\n\uadf8\ub7f0\u00a0\ub2e4\uc74c\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00\u00a0\ub514\uc2a4\ud06c\uc758\u00a0\uc554\ud638\ud654\ub41c\u00a0\ub370\uc774\ud130\ub97c\u00a0\ud574\ub3c5\ud558\uc5ec\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\ub85c\u00a0\uc0ac\uc6a9\uc790\uc5d0\uac8c\u00a0\ubc18\ud658\ud569\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\uc774<\/span>\u00a0\uc554\ud638\ud654\ub41c\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc0ac\uc6a9\ud560\u00a0\uacbd\uc6b0\u00a0\ub514\uc2a4\ud06c\uc758\u00a0\ub370\uc774\ud130\uac00\u00a0\ub3c4\ub09c\ub418\uc5b4\ub3c4\u00a0\ud6d4\uce5c\u00a0\ub370\uc774\ud130\uc758\u00a0\uc77c\ubd80\uac00\u00a0\uc544\ub2c8\ub77c\u00a0\uc9c0\uac11\uc5d0\u00a0\uc800\uc7a5\ub418\uc5b4\u00a0\uc788\ub294\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\u00a0\uc5c6\uc774\u00a0\ub370\uc774\ud130\ub97c\u00a0\uac80\uc0c9\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.
\n\uc9c0\uac11\uc744\u00a0\ub3c4\ub09c\u00a0\ub2f9\ud560\u00a0\uacbd\uc6b0\uc5d0\ub3c4\u00a0\uc9c0\uac11\u00a0\uc554\ud638\u00a0\uc5c6\uc774\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub97c\u00a0\uac80\uc0c9\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7ec\ubbc0\ub85c\u00a0\uadf8\u00a0\uce68\uc785\uc790\ub294\u00a0\ub514\uc2a4\ud06c\ub97c\u00a0\ud6d4\uce58\uac70\ub098\u00a0\ub370\uc774\ud130\u00a0\ud30c\uc77c\uc744\u00a0\ubcf5\uc0ac\ud558\ub354\ub77c\ub3c4\u00a0\ub370\uc774\ud130\ub97c\u00a0\ud574\ub3c5\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.
\n\uc774\uac83\uc740\u00a0\uc5ec\ub7ec\u00a0\uaddc\uc815\uacfc\u00a0\ud589\uc815\u00a0\uba85\ub839(directive)\uc5d0\u00a0\ub300\ud55c\u00a0\uc900\uc218\u00a0\uc694\uad6c\u00a0\uc0ac\ud56d\uc744\u00a0\ucda9\uc871\ud569\ub2c8\ub2e4.
\n\uadf8\ub9ac\uace0\u00a0\uc774\ub7ec\ud55c\u00a0\ubaa8\ub4e0\u00a0\ud504\ub85c\uc138\uc2a4\uac00\u00a0\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758\u00a0\ubcc0\uacbd\uc774\ub098\u00a0\ubcf5\uc7a1\ud55c\u00a0\uc554\ud638\ud654\u00a0\uc791\uc131,
\n\ud0a4\u00a0\uad00\ub9ac\u00a0\uc2dc\uc2a4\ud15c\u00a0\uc5c6\uc774\u00a0\uc218\ud589\ub429\ub2c8\ub2e4.
\n\uadf8\ub7ec\uba74\u00a0\uc9c0\uae08\ubd80\ud130 TDE\ub97c\u00a0\uc124\uc815\ud558\uace0\u00a0\uc0ac\uc6a9\ud558\ub294\u00a0\ubc29\ubc95\uc5d0\u00a0\ub300\ud574\u00a0\uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\ub2e8<\/span>\u00a0\ud55c\ubc88\uc758\u00a0<\/span>\uc124\uc815<\/span>\u00a0<\/span><\/p>\n

\ucc98\uc74c<\/span> TDE\ub97c\u00a0\uc0ac\uc6a9\ud560\u00a0\uacbd\uc6b0\u00a0\uc9c0\uac11\u00a0\uc704\uce58\ub97c\u00a0\uc9c0\uc815\ud558\uace0\u00a0\uc9c0\uac11\u00a0\uc554\ud638\ub97c\u00a0\uc124\uc815\ud558\uace0\u00a0\uc9c0\uac11\uc744\u00a0\uc5f4\uc5b4\uc57c\u00a0\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

1. <\/span>\uc9c0\uac11\u00a0\uc704\uce58\ub97c\u00a0\uc9c0\uc815\ud569\ub2c8\ub2e4.<\/span>
\n<\/span>\ucc98\uc74c TDE\ub97c\u00a0\uc124\uc815\ud560\u00a0\uacbd\uc6b0\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub97c\u00a0\uc800\uc7a5\ud560\u00a0\uc9c0\uac11\uc744\u00a0\uc0dd\uc131\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uae30\ubcf8\uc801\uc73c\ub85c\u00a0\uc9c0\uac11\uc740\u00a0\ub514\ub809\ud1a0\ub9ac $ORACLE_BASE\/admin\/$ORACLE_SID\/wallet\uc5d0\uc11c\u00a0\uc0dd\uc131\ub429\ub2c8\ub2e4.
\n\uadf8\ub7ec\ubbc0\ub85c $ORACLE_BASE is \/u01\/app\/oracle
\n\ubc0f $ORACLE_SID\uac00 SWBT4\uc77c\u00a0\uacbd\uc6b0\u00a0\uc9c0\uac11\uc740\u00a0\ub514\ub809\ud1a0\ub9ac \/u01\/app\/oracle\/admin\/SWBT4\/wallet\uc5d0\u00a0\uc800\uc7a5\ub429\ub2c8\ub2e4.
\n$ORACLE_HOME\/network\/admin
\n\ub514\ub809\ud1a0\ub9ac\uc5d0\u00a0\uc800\uc7a5\ub418\ub294 sqlnet.ora
\n\ud30c\uc77c\uc5d0\uc11c\u00a0\ub514\ub809\ud1a0\ub9ac\ub97c\u00a0\uc9c0\uc815\ud558\uc5ec\u00a0\ub2e4\ub978\u00a0\ub514\ub809\ud1a0\ub9ac\ub97c\u00a0\uc120\ud0dd\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc608\ub97c\u00a0\ub4e4\uc5b4\u00a0\uc9c0\uac11\uc744 \/orawall
\n\ub514\ub809\ud1a0\ub9ac\uc5d0\u00a0\uc800\uc7a5\ud558\ub824\uba74 sqlnet.ora
\n\ud30c\uc77c\uc5d0\u00a0\ub2e4\uc74c\u00a0\ud589\uc744\u00a0\ucd94\uac00\ud569\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

ENCRYPTION_WALLET_LOCATION =<\/span><\/p>\n

(SOURCE=<\/span><\/p>\n

\u00a0\u00a0 (METHOD=file)<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0 (METHOD_DATA=<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (DIRECTORY=\/orawall)))<\/span><\/p>\n

\uc774<\/span>\u00a0\uc608\uc81c\uc5d0\uc11c\ub294\u00a0\uae30\ubcf8\u00a0\uc704\uce58\uac00\u00a0\uc120\ud0dd\ub41c\u00a0\uac83\uc73c\ub85c\u00a0\uac00\uc815\ud569\ub2c8\ub2e4.
\n\ub610\ud55c\u00a0\uc9c0\uac11\u00a0\uc704\uce58\ub97c\u00a0\uc815\uae30\uc801\u00a0\ubc31\uc5c5\uc5d0\u00a0\ud3ec\ud568\uc2dc\ucf1c\uc57c\u00a0\ud569\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

2. <\/span>\uc9c0\uac11\uc744\u00a0\uc0dd\uc131\ud569\ub2c8\ub2e4.<\/span>
\n<\/span>\uc774\uc81c\u00a0\uc9c0\uac11\uc744\u00a0\uc0dd\uc131\ud558\uace0\u00a0\uc9c0\uac11\uc5d0\u00a0\uc561\uc138\uc2a4\ud558\uae30\u00a0\uc704\ud55c\u00a0\uc554\ud638\ub97c\u00a0\uc124\uc815\ud569\ub2c8\ub2e4.
\n\uc774\u00a0\uc791\uc5c5\uc744\u00a0\ud558\ub824\uba74<\/span>\u00a0<\/span>ALTER
\nSYSTEM<\/span>\u00a0<\/span>\uad8c\ud55c\uc744\u00a0\uac00\uc9c4\u00a0\uc0ac\uc6a9\uc790\ub85c\uc11c\u00a0\ub2e4\uc74c\u00a0\uba85\ub839\uc744\u00a0\uc2e4\ud589\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

alter system set encryption key
\n<\/span><\/p>\n

authenticated by “remnant”;<\/span><\/p>\n

\uc774<\/span>\u00a0\uba85\ub839\uc740\u00a0\ub2e4\uc74c\uc744\u00a0\uc218\ud589\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\u00b7 <\/span>\ub2e8\uacc4<\/span> 1\uc5d0\uc11c\u00a0\uc9c0\uc815\ud55c\u00a0\uc704\uce58\uc5d0\u00a0\uc9c0\uac11\uc744\u00a0\uc0dd\uc131\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\u00b7 <\/span>\uc9c0\uac11\uc758<\/span>\u00a0\uc554\ud638\ub97c “remnant”\ub85c\u00a0\uc124\uc815\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\u00b7 <\/span>\ub9c8\uc2a4\ud130<\/span>\u00a0\ud0a4\ub97c\u00a0\uc800\uc7a5\ud558\uace0\u00a0\uac80\uc0c9\ud560 TDE\uc5d0\u00a0\ub300\ud55c\u00a0\uc9c0\uac11\uc744\u00a0\uc5fd\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\uc554\ud638\ub294<\/span>\u00a0\ub300\uc18c\ubb38\uc790\ub97c\u00a0\uad6c\ubd84\ud558\uba70\u00a0\ud070\u00a0\ub530\uc634\ud45c\ub85c\u00a0\ubb36\uc5b4\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uc554\ud638 “remnant”\ub294\u00a0\uc5b4\ub290\u00a0\ub3d9\uc801\u00a0\uc131\ub2a5\u00a0\ubdf0\ub098\u00a0\ub85c\uadf8\uc5d0\ub3c4\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\ub85c\u00a0\ud45c\uc2dc\ub418\uc9c0\u00a0\uc54a\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\uc9c0\uac11<\/span>\u00a0<\/span>\uc5f4\uae30<\/span>\u00a0<\/span><\/p>\n

\uc9c0\uac11\uc740<\/span>\u00a0\ud55c\u00a0\ubc88\ub9cc\u00a0\uc0dd\uc131\ub418\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\uc55e\uc758\u00a0\ub450\u00a0\ub2e8\uacc4\ub294\u00a0\ud55c\u00a0\ubc88\ub9cc\u00a0\uc218\ud589\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uadf8\ub7ec\ub098\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\uc778\uc2a4\ud134\uc2a4\uac00\u00a0\uc2dc\uc791\ub41c\u00a0\ud6c4\uc5d0\u00a0\uc9c0\uac11\uc744\u00a0\uba85\uc2dc\uc801\uc73c\ub85c\u00a0\uc5f4\uc5b4\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uc9c0\uac11\uc744\u00a0\uc0dd\uc131\ud560\u00a0\ub54c(\uc55e\uc758\u00a0\ub2e8\uacc4 2)
\n\uc0ac\uc6a9\ud560\u00a0\uc9c0\uac11\uc744\u00a0\uc5f4\uc5b4\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uc9c0\uac11\uc744\u00a0\uc0dd\uc131\ud558\uace0\u00a0\uc554\ud638\ub97c\u00a0\uc124\uc815\ud55c\u00a0\ud6c4\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\u00a0\uc5f4\u00a0\ub54c\ub9c8\ub2e4\u00a0\ub3d9\uc77c\ud55c\u00a0\uc554\ud638\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\ub2e4\uc74c\uacfc\u00a0\uac19\uc774\u00a0\uc9c0\uac11\uc744\u00a0\uc5f4\uc5b4\uc57c\u00a0\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

alter system set encryption wallet open authenticated
\nby “remnant”;<\/span><\/p>\n

\uc9c0\uac11\uc744<\/span>\u00a0\ub2eb\uc73c\ub824\uba74\u00a0\ub2e4\uc74c\u00a0\uba85\ub839\uc744\u00a0\uc2e4\ud589\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

alter system set encryption wallet
\nclose;<\/span><\/p>\n

TDE<\/span>\ub97c\u00a0\uc0ac\uc6a9\ud558\ub824\uba74\u00a0\uc9c0\uac11\uc744\u00a0\uc5f4\uc5b4\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uc9c0\uac11\uc774\u00a0\ub2eb\ud600\u00a0\uc788\ub294\u00a0\uacbd\uc6b0\u00a0\uc554\ud638\ud654\ub418\uc9c0\u00a0\uc54a\uc740\u00a0\uc5f4\uc5d0\u00a0\uc561\uc138\uc2a4\ud560\u00a0\uc218\u00a0\uc788\uc73c\ub098\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc5d0\ub294\u00a0\uc561\uc138\uc2a4\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\uc5f4<\/span>\u00a0<\/span>\uc554\ud638\ud654<\/span>\u00a0<\/span><\/p>\n

TDE<\/span>\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc5f4\uc744\u00a0\uc554\ud638\ud654\ud558\ub824\uba74\u00a0\ub2e8\uc9c0\u00a0\uc5f4\u00a0\uc815\uc758\uc5d0\u00a0\uac04\ub2e8\ud55c\u00a0\uc808<\/span>, <\/span>ENCRYPT<\/span>\ub97c<\/span>\u00a0\ucd94\uac00\ud558\uae30\ub9cc\u00a0\ud558\uba74\u00a0\ub429\ub2c8\ub2e4.
\n\uadf8\ub7ec\ub098\u00a0\ucd94\uac00\ud558\uae30\u00a0\uc804\uc5d0\u00a0\uc0ac\uc6a9\ud560\u00a0\uc554\ud638\ud654\u00a0\uc720\ud615\uacfc\u00a0\ud0a4\u00a0\uae38\uc774\ub97c\u00a0\uc120\ud0dd\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uc774\u00a0\ubb38\uc81c\uc5d0\u00a0\ub300\ud55c\u00a0\uc790\uc138\ud55c\u00a0\uc124\uba85\uc740\u00a0\uc704\uc5d0\uc11c\u00a0\uc5b8\uae09\ud55c “\ub370\uc774\ud130\u00a0\uc790\uc0b0\uc758\u00a0\uc554\ud638\ud654”
\n\uae30\uc0ac\ub97c\u00a0\ucc38\uc870\ud558\uc2ed\uc2dc\uc624<\/span>. <\/span><\/p>\n

\uc815\uaddc<\/span>\u00a0\uc2a4\ud0a4\ub9c8\uc5d0\uc11c\u00a0\ub2e4\uc74c\uc758\u00a0\uacc4\uc815\u00a0\uc18c\uc720\uc790\uc758\u00a0\ud14c\uc774\ube14\uc774\u00a0\uc788\ub2e4\uace0\u00a0\uac00\uc815\ud569\uc2dc\ub2e4.<\/span>\u00a0<\/span><\/p>\n

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

ACC_NAME\u00a0\u00a0\u00a0 VARCHAR2(30)
\n<\/span><\/p>\n

SSN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(9)<\/span><\/p>\n

\ud604\uc7ac<\/span>\u00a0\ud14c\uc774\ube14\uc758\u00a0\ubaa8\ub4e0\u00a0\ub370\uc774\ud130\ub294\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\uc785\ub2c8\ub2e4.
\n\uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638\uac00\u00a0\uc800\uc7a5\ub41c\u00a0\uc5f4<\/span>\u00a0<\/span>SSN<\/span>\uc744<\/span>\u00a0\ubcc0\ud658\ud558\uc5ec\u00a0\uc554\ud638\ud654\ub428\uc73c\ub85c\u00a0\uc800\uc7a5\ud558\ub824\uace0\u00a0\ud569\ub2c8\ub2e4.
\n\ub2e4\uc74c\u00a0\uba85\ub839\uc744\u00a0\uc2e4\ud589\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

alter table accounts modify (ssn
\nencrypt);<\/span><\/p>\n

\uc774<\/span>\u00a0\uba85\ub839\ubb38\uc740\u00a0\ub2e4\uc74c\u00a0\ub450\u00a0\uc791\uc5c5\uc744\u00a0\uc218\ud589\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\u00b7 <\/span>\ud14c\uc774\ube14\uc5d0<\/span>\u00a0\ub300\ud55c\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc0dd\uc131\ud569\ub2c8\ub2e4.
\n\uc554\ud638\ud654\ub41c\u00a0\ud615\uc2dd\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\ub3d9\uc77c\ud55c\u00a0\ud14c\uc774\ube14\uc758\u00a0\ub2e4\ub978\u00a0\uc5f4\uc744\u00a0\ubcc0\uacbd\ud560\u00a0\uacbd\uc6b0\u00a0\ub3d9\uc77c\ud55c\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\uac00\u00a0\uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\u00b7 <\/span>\uc5f4\uc758<\/span>\u00a0\ubaa8\ub4e0\u00a0\uac12\uc744\u00a0\uc554\ud638\ud654\ub41c\u00a0\ud615\uc2dd\uc73c\ub85c\u00a0\ubcc0\ud658\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

\uc774<\/span>\u00a0\uba85\ub839\uc740\u00a0\uc5f4\uc758\u00a0\ub370\uc774\ud130\u00a0\uc720\ud615\uc774\ub098\u00a0\ud06c\uae30\ub97c\u00a0\ubcc0\uacbd\ud558\uc9c0\u00a0\uc54a\uc73c\uba70\u00a0\ud2b8\ub9ac\uac70\u00a0\ub610\ub294\u00a0\ubdf0\ub97c\u00a0\uc0dd\uc131\ud558\uc9c0\u00a0\uc54a\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\uae30\ubcf8\uc801\uc73c\ub85c<\/span> 192\ube44\ud2b8\u00a0\ud0a4\ub97c\u00a0\uc0ac\uc6a9\ud558\ub294\u00a0\uc54c\uace0\ub9ac\uc998 AES\uac00\u00a0\uc554\ud638\ud654\uc5d0\u00a0\uc0ac\uc6a9\ub429\ub2c8\ub2e4.
\n\uba85\ub839\uc5d0\u00a0\ud574\ub2f9\u00a0\uc808\uc744\u00a0\ucd94\uac00\uc801\uc73c\ub85c\u00a0\uc9c0\uc815\ud558\uc5ec\u00a0\ub2e4\ub978\u00a0\uc54c\uace0\ub9ac\uc998\uc744\u00a0\uc120\ud0dd\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc608\ub97c\u00a0\ub4e4\uc5b4 128\ube44\ud2b8 AES
\n\uc554\ud638\ud654\ub97c\u00a0\uc0ac\uc6a9\ud558\ub824\uba74\u00a0\ub2e4\uc74c\uacfc\u00a0\uac19\uc740\u00a0\uba85\ub839\uc744\u00a0\uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

alter table accounts modify (ssn encrypt using
\n‘AES128’);<\/span><\/p>\n

AES128, AES192, AES256 <\/span>\ub610\ub294<\/span> 3DES168<\/span>(168<\/span>\ube44\ud2b8 Triple DES
\n\uc54c\uace0\ub9ac\uc998)\uc744\u00a0\uc808\ub85c\uc11c\u00a0\uc0ac\uc6a9\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc774\u00a0\uac12\uc740\u00a0\uc124\uba85\ud560\u00a0\ud544\uc694\u00a0\uc5c6\uc774\u00a0\uc790\uba85\ud569\ub2c8\ub2e4.
\n\uc608\ub97c\u00a0<\/span>\ub4e4\uc5b4<\/span>AES256<\/span>\uc740<\/span> 256\ube44\ud2b8\u00a0\ud0a4\ub97c\u00a0\uc0ac\uc6a9\ud558\ub294 AES(Advanced
\nEncryption Standard)
\n\uc54c\uace0\ub9ac\uc998\uc744\u00a0\uc758\ubbf8\ud569\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\uc5f4\uc744<\/span>\u00a0\uc554\ud638\ud654\ud55c\u00a0\ud6c4\u00a0\ud14c\uc774\ube14\uc744\u00a0\uc124\uba85\ud560\u00a0\ub54c\u00a0\ub2e4\uc74c\uc774\u00a0\ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/span>\u00a0<\/span><\/p>\n

SQL> desc accounts<\/span><\/p>\n

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

Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Null?\u00a0\u00a0\u00a0\u00a0\u00a0 Type<\/span><\/p>\n

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

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

ACC_NAME\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(30)<\/span><\/p>\n

SSN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(9)
\nENCRYPT<\/span><\/p>\n

\ub370\uc774\ud130<\/span>\u00a0\uc720\ud615\u00a0\ub2e4\uc74c\uc758<\/span>\u00a0<\/span>ENCRYPT<\/span>\u00a0<\/span>\ud0a4\uc6cc\ub4dc\uc5d0\u00a0\uc8fc\uc758\ud558\uc2ed\uc2dc\uc624.
\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc744\u00a0\ucc3e\uc73c\ub824\uba74\u00a0\ub370\uc774\ud130\u00a0\ub515\uc154\ub108\ub9ac\u00a0\ubdf0<\/span>\u00a0<\/span>DBA_ENCRYPTED_COLUMNS<\/span>\ub97c<\/span>\u00a0\uac80\uc0c9\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n(SYS
\n\uc18c\uc720\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\ub300\ud574<\/span>\u00a0<\/span>TDE<\/span>\ub97c<\/span>\u00a0\uc0ac\uc6a9\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.)<\/span>\u00a0<\/span><\/p>\n

\uc131\ub2a5<\/span>\u00a0\uace0\ub824\u00a0<\/span>\uc0ac\ud56d<\/span>\u00a0<\/span><\/p>\n

\uc554\ud638\ud654\uc640<\/span>\u00a0\ud574\ub3c5\uc740 CPU
\n\uc8fc\uae30\ub97c\u00a0\uc18c\ube44\ud558\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\uc131\ub2a5\uc5d0\u00a0\ub300\ud55c\u00a0\uc601\ud5a5\uc744\u00a0\uace0\ub824\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\ud14c\uc774\ube14\uc758\u00a0\uc554\ud638\ud654\ub418\uc9c0\u00a0\uc54a\uc740\u00a0\uc5f4\uc5d0\u00a0\uc561\uc138\uc2a4\ud560\u00a0\ub54c\u00a0\uc131\ub2a5\uc740 TDE\uac00\u00a0\uc5c6\ub294\u00a0\ud14c\uc774\ube14\uacfc\u00a0\ub2e4\ub974\uc9c0\u00a0\uc54a\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7ec\ub098\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc5d0\u00a0\uc561\uc138\uc2a4\ud560\u00a0\ub54c selects
\n\uc2dc\u00a0\ud574\ub3c5\ud558\ub294\u00a0\ub3d9\uc548\uacfc inserts
\n\uc2dc\u00a0\uc554\ud638\ud654\ud558\ub294\u00a0\ub3d9\uc548\u00a0\uc791\uc740\u00a0\uc131\ub2a5\u00a0\uc624\ubc84\ud5e4\ub4dc\uac00\u00a0\ubc1c\uc0dd\ud558\uba70\u00a0\ub530\ub77c\uc11c\u00a0\uc5f4\uc744\u00a0\uc120\ud0dd\uc801\uc73c\ub85c\u00a0\uc554\ud638\ud654\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4.
\n\uc5f4\uc744\u00a0\uc554\ud638\ud654\ud560\u00a0\ud544\uc694\uac00\u00a0\uc5c6\uc744\u00a0\uacbd\uc6b0\u00a0\ub2e4\uc74c\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec TDE\ub97c\u00a0\ud574\uc81c\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

alter table account modify (ssn
\ndecrypt);<\/span><\/p>\n

\ub610\ud55c<\/span>\u00a0\uc778\ub371\uc2a4\u00a0\uc0ac\uc6a9\uc744\u00a0\uace0\ub824\ud558\uc2ed\uc2dc\uc624.
\n\uc704\u00a0\uc608\uc5d0\uc11c\u00a0\uc5f4<\/span>\u00a0<\/span>SSN<\/span>\uc5d0<\/span>\u00a0<\/span>in_accounts_ssn<\/span>\uc774\ub77c\ub294<\/span>\u00a0\uc774\ub984\uc758\u00a0\uc778\ub371\uc2a4\uac00\u00a0\uc788\ub2e4\uace0\u00a0\uac00\uc815\ud569\uc2dc\ub2e4<\/span>. <\/span>ACCOUNTS<\/span>\u00a0<\/span>\ud14c\uc774\ube14\uc5d0\u00a0\ub300\ud55c\u00a0\uc9c8\uc758\uc5d0\u00a0\ub2e4\uc74c\uacfc\u00a0\uac19\uc774\u00a0\ub3d9\ub4f1\u00a0\uc220\uc5b4\uac00\u00a0\uc788\uc744\u00a0\uacbd\uc6b0<\/span>\u00a0<\/span><\/p>\n

select * from accounts <\/span><\/p>\n

where ssn = ‘123456789’;<\/span><\/p>\n

\uc778\ub371\uc2a4<\/span>\u00a0<\/span>in_accounts_ssn<\/span>\uc774<\/span>\u00a0\uc0ac\uc6a9\ub429\ub2c8\ub2e4.
\n\uc9c8\uc758\uc5d0\uc11c\u00a0\ub2e4\uc74c\uacfc\u00a0\uac19\uc774<\/span>\u00a0<\/span>LIKE<\/span>\u00a0<\/span>\uc220\uc5b4\ub97c\u00a0\uc0ac\uc6a9\ud560\u00a0\uacbd\uc6b0<\/span>\u00a0<\/span><\/p>\n

select * from accounts <\/span><\/p>\n

where ssn like ‘123%’;<\/span><\/p>\n

\uc778\ub371\uc2a4\uac00<\/span>\u00a0\ubb34\uc2dc\ub418\uace0\u00a0\uc804\uccb4\u00a0\ud14c\uc774\ube14\u00a0\uc2a4\uce94\uc774\u00a0\uc0ac\uc6a9\ub429\ub2c8\ub2e4.
\n\uadf8\u00a0\uc774\uc720\ub294\u00a0\uac04\ub2e8\ud569\ub2c8\ub2e4.
\n\uc778\ub371\uc2a4\uc758 B
\n\ud2b8\ub9ac\u00a0\uad6c\uc870\uc5d0\uc11c\u00a0\uc55e\u00a0\uba87\u00a0\ubb38\uc790\uac00\u00a0\ub3d9\uc77c\ud55c\u00a0\uac12(“fraternal”,
\n“fraternity”
\n\ub4f1)\uc740\u00a0\ubb3c\ub9ac\uc801\uc73c\ub85c\u00a0\uc11c\ub85c\u00a0\uac00\uae4c\uc774\u00a0\uc788\uc2b5\ub2c8\ub2e4<\/span>. <\/span>LIKE<\/span>\u00a0<\/span>\uc220\uc5b4\ub97c\u00a0\ucc98\ub9ac\ud560\u00a0\ub54c Oracle
\nDatabase 10<\/span>g<\/span>\ub294\u00a0\ud328\ud134\u00a0\uc77c\uce58\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc778\ub371\uc2a4\u00a0\ud56d\ubaa9\uc744\u00a0\uac80\uc0c9\ud558\uace0\u00a0\ubb3c\ub9ac\uc801\u00a0\uadfc\uc811\uc131\uc774\u00a0\uc778\ub371\uc2a4\u00a0\uac80\uc0c9\u00a0\uc18d\ub3c4\ub97c\u00a0\uc99d\uac00\uc2dc\ud0a4\ubbc0\ub85c\u00a0\uc804\uccb4\u00a0\ud14c\uc774\ube14\u00a0\uc2a4\uce94\ubcf4\ub2e4\u00a0\uc88b\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/p>\n

\uadf8\ub7ec\ub098<\/span>\u00a0\uc5f4\uc744\u00a0\uc554\ud638\ud654\ud560\u00a0\uacbd\uc6b0\u00a0\uc778\ub371\uc2a4\uc758\u00a0\uc2e4\uc81c\u00a0\uac12\uc774\u00a0\uc554\ud638\ud654\ub418\uc5c8\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\ud06c\uac8c\u00a0\ub2e4\ub974\uace0\u00a0\ub530\ub77c\uc11c\u00a0\uc778\ub371\uc2a4\u00a0\uc804\uc5ed\uc5d0\u00a0\ud769\uc5b4\uc838\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub807\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\uc804\uccb4\u00a0\ud14c\uc774\ube14\u00a0\uc2a4\uce94\ubcf4\ub2e4\u00a0\uc778\ub371\uc2a4\u00a0\uc2a4\uce94\uc774\u00a0\ub354\u00a0\ub9ce\uc740\u00a0\ub9ac\uc18c\uc2a4\ub97c\u00a0\uc0ac\uc6a9\ud569\ub2c8\ub2e4.
\n\uadf8\ub798\uc11c\u00a0\uc774<\/span>\u00a0<\/span>LIKE<\/span>\u00a0<\/span>\uc220\uc5b4\u00a0\uc9c8\uc758\u00a0\uc608\uc81c\uc5d0\uc11c Oracle
\nDatabase 10<\/span>g<\/span>\ub294\u00a0\uc778\ub371\uc2a4\ub97c\u00a0\ubb34\uc2dc\ud558\uace0\u00a0\uc804\uccb4\u00a0\ud14c\uc774\ube14\u00a0\uc2a4\uce94\uc744\u00a0\uc120\ud0dd\ud569\ub2c8\ub2e4.
\n\ub3d9\ub4f1\u00a0\uc220\uc5b4\uc758\u00a0\uacbd\uc6b0\u00a0\ud328\ud134\uc744\u00a0\ub530\ub974\ub294\u00a0\uc5ec\ub7ec\u00a0\uac12\u00a0\ub300\uc2e0\uc5d0\u00a0\ud2b9\uc815\u00a0\uc778\ub371\uc2a4\u00a0\ud56d\ubaa9\uc774\u00a0\uac80\uc0c9\ub429\ub2c8\ub2e4.
\n\uadf8\ub798\uc11c\u00a0\uc778\ub371\uc2a4\ub97c\u00a0\uc0ac\uc6a9\ud55c\u00a0\uc2e4\ud589\u00a0\uacbd\ub85c\uac00\u00a0\uc804\uccb4\u00a0\ud14c\uc774\ube14\u00a0\uc2a4\uce94\ubcf4\ub2e4\u00a0\uc18d\ub3c4\uac00\u00a0\ube60\ub974\uba70\u00a0\ucd5c\uc801\uae30\uac00\u00a0\uc778\ub371\uc2a4\u00a0\uc0ac\uc6a9\uc744\u00a0\uc120\ud0dd\ud569\ub2c8\ub2e4.
\n\uc554\ud638\ud654\ud560\u00a0\uc5f4\uc744\u00a0\uacb0\uc815\ud560\u00a0\ub54c\u00a0\uc554\ud638\ud654\uac00\u00a0\uc778\ub371\uc2a4\uc5d0\u00a0\uc5bc\ub9c8\ub098\u00a0\uc601\ud5a5\uc744\u00a0\uc8fc\ub294\uc9c0\u00a0\uace0\ub824\ud558\uace0\u00a0\uc554\ud638\ud654\u00a0\uc5f4\uc744\u00a0\ud3ec\ud568\ud558\ub294\u00a0\ud2b9\uc815\u00a0\uc9c8\uc758\ub97c\u00a0\uc7ac\uc791\uc131\ud574\uc57c\u00a0\ud558\ub294\u00a0\uacbd\uc6b0\uac00\u00a0\uc788\uc73c\ub2c8\u00a0\uc8fc\uc758\ud558\uc2ed\uc2dc\uc624<\/span>.<\/span><\/p>\n

\ud0a4\uc640<\/span>\u00a0\uc554\ud638\u00a0\uad00\ub9ac<\/span>\u00a0<\/span><\/p>\n

\ub204\uad70\uac00\uac00<\/span>\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\uc54c\uace0\u00a0\uc788\uac70\ub098\u00a0\uc554\ud638\ud654\ub41c\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\ud574\ub3c5\ud588\uc744\uc9c0\ub3c4\u00a0\ubaa8\ub978\ub2e4\ub294\u00a0\uc758\uc2ec\uc774\u00a0\ub4e4\u00a0\ub54c\uc5d0\ub294\u00a0\uc5b4\ub5bb\uac8c\u00a0\ud560\uae4c\uc694?
\n\uac04\ub2e8\ud558\uac8c\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\ub300\ud55c\u00a0\uc0c8\u00a0\ud0a4\ub97c\u00a0\uc0dd\uc131\ud560\u00a0\uc218\u00a0\uc788\uace0\u00a0\uac04\ub2e8\ud55c\u00a0\uba85\ub839\uc744\u00a0\uc2e4\ud589\ud558\uc5ec\u00a0\uc0c8\ub85c\uc6b4\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\u00a0\uac12\uc744\u00a0\ub2e4\uc2dc\u00a0\uc0dd\uc131\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\ub610\ud55c\u00a0\uc774\u00a0\uc791\uc5c5\uc744\u00a0\ud560\u00a0\ub54c<\/span>\u00a0<\/span>AES256<\/span>\u00a0<\/span>\ub4f1\u00a0\ub2e4\ub978\u00a0\uc554\ud638\ud654\u00a0\uc54c\uace0\ub9ac\uc998\uc744\u00a0\uc120\ud0dd\ud560\u00a0\uc218\ub3c4\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\ub2e4\uc74c\u00a0\uba85\ub839\uc744\u00a0\uc218\ud589\ud558\uc5ec\u00a0\ub450\u00a0\uc791\uc5c5\uc744\u00a0\uc218\ud589\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span>\u00a0<\/span><\/p>\n

alter table accounts rekey using
\n‘aes256’;<\/span><\/p>\n

\ub204\uad70\uac00\uac00<\/span>\u00a0\uc9c0\uac11\u00a0\uc554\ud638\ub97c\u00a0\uc54c\uace0\u00a0\uc788\uc744\u00a0\uacbd\uc6b0\u00a0\uc5b4\ub5bb\uac8c\u00a0\ud560\uae4c\uc694?
\nOracle Wallet
\nManager\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc554\ud638\ub97c\u00a0\ubcc0\uacbd\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc774\u00a0\uadf8\ub798\ud53d\u00a0\ud234\uc744\u00a0\ud638\ucd9c\ud558\ub824\uba74\u00a0\uba85\ub839\uc904\uc5d0 OWM\uc744\u00a0\uc785\ub825\ud569\ub2c8\ub2e4(\uadf8\ub9bc 2
\n\ucc38\uc870).
\n\uc0c1\ub2e8\u00a0\uba54\ub274\uc5d0\uc11c\u00a0<\/span>\uc9c0\uac11 ->
\n\uc5f4\uae30\ub97c\u00a0\uc120\ud0dd\ud558\uace0\u00a0\uc9c0\uc815\ud55c\u00a0\uc9c0\uac11\u00a0\uc704\uce58\ub97c\u00a0\uc120\ud0dd\ud55c\u00a0\ub2e4\uc74c\u00a0\uc9c0\uac11\u00a0\uc554\ud638\ub97c\u00a0\uc785\ub825\ud569\ub2c8\ub2e4.
\n\uadf8\ub7f0\u00a0\ub2e4\uc74c\u00a0\uc9c0\uac11 ->
\n\uc554\ud638<\/span>\u00a0\ubcc0\uacbd\uc744\u00a0\uc120\ud0dd\ud558\uc5ec\u00a0\uc554\ud638\ub97c\u00a0\ubcc0\uacbd\ud569\ub2c8\ub2e4.
\n\uc9c0\uac11\u00a0\uc554\ud638\ub97c\u00a0\ubcc0\uacbd\ud558\uc5ec\ub3c4\u00a0\ud0a4\ub294\u00a0\ubcc0\uacbd\ub418\uc9c0\u00a0\uc54a\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n\n
\n

\"image1\"<\/a><\/p>\n<\/td>\n<\/tr>\n

\n

\uadf8\ub9bc<\/span> 2: Oracle Wallet
\nManager<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uc554\ud638\ud654\uc640<\/span>\u00a0\ud568\uaed8 “Salt”\ub97c\u00a0\uc6d0\ud558\uc2ed\ub2c8\uae4c<\/span>? <\/span><\/p>\n

\uc554\ud638\ud654\ub294<\/span>\u00a0\uc644\uc804\ud788\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc228\uae30\uc9c0\ub9cc\u00a0\ub54c\ub54c\ub85c\u00a0\ub370\uc774\ud130\uc758\u00a0\uc6d0\ubcf8\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\u00a0\uac12\uc5d0\u00a0\ubc18\ubcf5\ub418\ub294\u00a0\uac12\uc774\u00a0\uc788\uc744\u00a0\uacbd\uc6b0\u00a0\uc554\ud638\ud654\ub41c\u00a0\ub370\uc774\ud130\u00a0\uac12\uc744\u00a0\uc27d\uac8c\u00a0\ucd94\uce21\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc608\ub97c\u00a0\ub4e4\uc5b4\u00a0\uae09\uc5ec\u00a0\uc815\ubcf4\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\ubc18\ubcf5\ub418\ub294\u00a0\uac12\uc774\u00a0\ud3ec\ud568\ub420\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uc774\u00a0\uacbd\uc6b0\uc5d0\u00a0\uc554\ud638\ud654\ub41c\u00a0\uac12\ub3c4\u00a0\ub3d9\uc77c\ud558\uba70\u00a0\uce68\uc785\uc790\uac00\u00a0\ub3d9\uc77c\ud55c\u00a0\uae09\uc5ec\u00a0\ud56d\ubaa9\uc744\u00a0\ud310\ubcc4\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7ec\ud55c\u00a0\uacbd\uc6b0\ub97c\u00a0\ubc29\uc9c0\ud558\uae30\u00a0\uc704\ud574\u00a0\uc785\ub825\u00a0\ub370\uc774\ud130\uac00\u00a0\uac19\ub354\ub77c\ub3c4\u00a0\uc554\ud638\ud654\ub41c\u00a0\uac12\uc774\u00a0\ub2e4\ub974\ub3c4\ub85d\u00a0\ub370\uc774\ud130\uc5d0 “salt”\ub97c\u00a0\ucd94\uac00\ud569\ub2c8\ub2e4.
\n\uae30\ubcf8\uc801\uc73c\ub85c TDE\ub294 salt\ub97c\u00a0\uc801\uc6a9\ud569\ub2c8\ub2e4.
\n\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc5d0\u00a0\ub300\ud55c\u00a0\uc778\ub371\uc2a4\ub97c\u00a0\uc0dd\uc131\ud560\u00a0\uacbd\uc6b0\u00a0\uc778\ub371\uc2a4\uc5d0 salt\ub97c\u00a0\ud3ec\ud568\uc2dc\ud0ac\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.
\n\uc608\ub97c\u00a0\ub4e4\uc5b4<\/span>\u00a0<\/span>SSN<\/span>\u00a0<\/span>\uc5f4\uc5d0\uc11c salt\ub97c\u00a0\uc81c\uac70\ud558\ub824\uba74\u00a0\ub2e4\uc74c\uc744\u00a0\uc2e4\ud589\ud569\ub2c8\ub2e4<\/span>.<\/span>\u00a0<\/span><\/p>\n

alter table accounts modify <\/span><\/p>\n

(ssn encrypt no salt);<\/span><\/p>\n

salt<\/span>\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc5d0\u00a0\ub300\ud55c\u00a0\uc778\ub371\uc2a4\ub97c\u00a0\uc0dd\uc131\ud560\u00a0\uacbd\uc6b0\u00a0\ub2e4\uc74c\u00a0\uc608\uc5d0\uc11c\uc640\u00a0\uac19\uc774\u00a0\uc624\ub958\uac00\u00a0\ubc1c\uc0dd\ud569\ub2c8\ub2e4<\/span>.<\/span>\u00a0<\/span><\/p>\n

SQL> create index in_acc_01
\n<\/span><\/p>\n

on accounts (ssn);<\/span><\/p>\n

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

ORA-28338: cannot encrypt indexed column(s) with
\nsalt<\/span><\/p>\n

salt<\/span>\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc778\ub371\uc2a4\ub41c\u00a0\uc5f4\uc744\u00a0\uc554\ud638\ud654\ud560\u00a0\uacbd\uc6b0\uc5d0\ub3c4\u00a0\ub3d9\uc77c\ud55c\u00a0\uc624\ub958\uac00\u00a0\ubc1c\uc0dd\ud569\ub2c8\ub2e4.
\n\ub9c8\ucc2c\uac00\uc9c0\ub85c\u00a0\uc554\uc2dc\uc801\u00a0\uc778\ub371\uc2a4\u00a0\uc0dd\uc131\uc774\u00a0\uc788\uc744\u00a0\uacbd\uc6b0,
\n\uc989\u00a0\uc5f4\uc774\u00a0\uae30\ubcf8\u00a0\ud0a4\uc758\u00a0\uc77c\ubd80\uc774\uac70\ub098 unique\ub85c\u00a0\uc815\uc758\ub41c\u00a0\uacbd\uc6b0 salt\ub97c\u00a0\uc0ac\uc6a9\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4.
\n\ub610\ud55c\u00a0\uc5f4\uc774\u00a0\uc678\ub798\u00a0\ud0a4\uc758\u00a0\uc77c\ubd80\uc778\u00a0\uacbd\uc6b0\uc5d0\ub3c4 salt\ub97c\u00a0\uc0ac\uc6a9\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4<\/span>.<\/span>\u00a0<\/span><\/p>\n

TDE<\/span>\uc640 Data Pump
\n\uc0ac\uc6a9<\/span>\u00a0<\/span><\/p>\n

\uae30\ubcf8\uc801\uc73c\ub85c<\/span> Data Pump
\n\uc5d1\uc2a4\ud3ec\ud2b8\u00a0\uc720\ud2f8\ub9ac\ud2f0(EXPDP)\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc774\u00a0\uc788\ub294\u00a0\ud14c\uc774\ube14\uc758\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\ud560\u00a0\uacbd\uc6b0\u00a0\uc0dd\uc131\ub418\ub294\u00a0\ub364\ud504\u00a0\ud30c\uc77c\uc758\u00a0\ub370\uc774\ud130\ub294\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\uc785\ub2c8\ub2e4(\uc554\ud638\ud654\ub41c\u00a0\uc5f4\u00a0\ub370\uc774\ud130\uc758\u00a0\uacbd\uc6b0\uc5d0\ub3c4\u00a0\ub9c8\ucc2c\uac00\uc9c0).
\n\ub2e4\uc74c\u00a0\uba85\ub839\uc740<\/span>\u00a0<\/span>ACCOUNTS<\/span>\u00a0<\/span>\ud14c\uc774\ube14(\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc774\u00a0\uc788\uc74c)\uc744\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\ud558\uace0<\/span>\u00a0<\/span><\/p>\n

$ expdp arup\/arup
\ntables=accounts<\/span><\/p>\n

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

ORA-39173: Encrypted data has been stored unencrypted
\nin dump file set.<\/span><\/p>\n

\uc774<\/span>\u00a0\uba54\uc2dc\uc9c0\ub294\u00a0\ub2e8\uc9c0\u00a0\uacbd\uace0\uc774\uace0\u00a0\uc624\ub958\uac00\u00a0\uc544\ub2c8\uba70\u00a0\ud589\uc774\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\ub429\ub2c8\ub2e4<\/span>.. <\/span><\/p>\n

Data Pump <\/span>\ub364\ud504\u00a0\ud30c\uc77c\uc758\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\u00a0\ub370\uc774\ud130\ub97c\u00a0\ubcf4\ud638\ud558\ub824\uba74\u00a0\ud14c\uc774\ube14\uc744\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\ud560\u00a0\ub54c\u00a0\ub364\ud504\u00a0\ud30c\uc77c\uc744\u00a0\uc554\ud638\ub85c\u00a0\ubcf4\ud638\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4.
\nEXPDP \uba85\ub839\uc5d0\uc11c<\/span>\u00a0<\/span>ENCRYPTION_PASSWORD<\/span>\u00a0<\/span>\ub9e4\uac1c\ubcc0\uc218\ub85c\u00a0\uc9c0\uc815\ub418\ub294\u00a0\uc774\u00a0\uc554\ud638\ub294\u00a0\uc774\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\u00a0\ud504\ub85c\uc138\uc2a4\uc5d0\ub9cc\u00a0\uc801\uc6a9\ub429\ub2c8\ub2e4.
\n\uc774\uac83\uc740\u00a0\uc9c0\uac11\u00a0\uc554\ud638\uac00\u00a0\uc544\ub2d9\ub2c8\ub2e4.
\n\ubaa9\ub85d 1\uc740\u00a0\uc554\ud638 “pooh”\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc2e4\ud589\ud55c EXPDP
\n\uba85\ub839\uc785\ub2c8\ub2e4.
\n\ubaa9\ub85d 1\uc758\u00a0\uba85\ub839\uc5d0\u00a0\ub300\ud55c\u00a0\ucd9c\ub825\uc774\u00a0\uc5b4\ub5a4\u00a0\ubc29\uc2dd\uc73c\ub85c\u00a0\uc554\ud638 “pooh”\ub97c\u00a0\ud45c\uc2dc\ud558\uc9c0\u00a0\uc54a\ub294\uc9c0\u00a0\uc8fc\ubaa9\ud558\uc2ed\uc2dc\uc624.
\n\uc554\ud638\ub294\u00a0\ubcc4\ud45c(*)
\n\ubb38\uc790\uc5f4\ub85c\u00a0\uc228\uaca8\uc9d1\ub2c8\ub2e4.
\n\uc0dd\uc131\ub418\ub294\u00a0\ub364\ud504\u00a0\ud30c\uc77c\uc5d0\ub294 TDE\ub85c\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc758\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\u00a0\ub370\uc774\ud130\uac00\u00a0\ubcf4\uc774\uc9c0\u00a0\uc54a\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/p>\n

\ucf54\ub4dc<\/span>\u00a0\ubaa9\ub85d 1:<\/span>\u00a0\uc554\ud638\ub85c\u00a0\ubcf4\ud638\ub41c\u00a0\ub364\ud504\u00a0\ud30c\uc77c\uc758\u00a0<\/span>\uc5d1\uc2a4\ud3ec\ud2b8<\/span>\u00a0<\/span><\/p>\n

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

$ expdp arup\/arup ENCRYPTION_PASSWORD=pooh
\ntables=accounts<\/span><\/p>\n

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

Export: Release 10.2.0.0.0 – Beta on Friday, 01 July,
\n2005 16:14:06<\/span><\/p>\n

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

Copyright (c) 2003, 2005, Oracle.\u00a0 All rights
\nreserved.<\/span><\/p>\n

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

Connected to: Oracle Database
\n10<\/span>g<\/span> Enterprise Edition Release 10.2.0.0.0 –
\nBeta<\/span><\/p>\n

With the Partitioning, OLAP and Data Mining
\noptions<\/span><\/p>\n

Starting “ARUP”.”SYS_EXPORT_TABLE_01″:\u00a0 arup\/******** ENCRYPTION_PASSWORD=********* tables=accounts
\n<\/span><\/p>\n

Estimate in progress using BLOCKS
\nmethod…<\/span><\/p>\n

Processing …<\/span><\/p>\n

\uc774<\/span>\u00a0\uc554\ud638\ud654\ub41c\u00a0\ub364\ud504\u00a0\ud30c\uc77c\uc744\u00a0\uc784\ud3ec\ud2b8\ud560\u00a0\ub54c\u00a0\ubaa9\ub85d 2\uc5d0\uc11c\uc640\u00a0\uac19\uc774\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\u00a0\uc2dc\u00a0\uc0ac\uc6a9\ud55c\u00a0\ub3d9\uc77c\ud55c\u00a0\uc554\ud638\ub97c\u00a0\uc9c0\uc815\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4<\/span>.<\/span>\u00a0<\/span><\/p>\n

\ucf54\ub4dc<\/span>\u00a0<\/span>\ubaa9\ub85d<\/span> 2:<\/span>\u00a0<\/span>\uc554\ud638\ub85c\u00a0\ubcf4\ud638\ub41c\u00a0\ub364\ud504\u00a0\ud30c\uc77c\uc758\u00a0<\/span>\uc784\ud3ec\ud2b8<\/span>\u00a0<\/span><\/p>\n

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

$ impdp arup\/arup ENCRYPTION_PASSWORD=pooh
\ntables=accounts table_exists_action=replace<\/span><\/p>\n

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

Import: Release 10.2.0.0.0 – Beta on Friday, 01 July,
\n2005 16:04:20<\/span><\/p>\n

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

Copyright (c) 2003, 2005, Oracle.\u00a0 All rights
\nreserved.<\/span><\/p>\n

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

Connected to: Oracle Database
\n10<\/span>g<\/span> Enterprise Edition Release 10.2.0.0.0 –
\nBeta<\/span><\/p>\n

With the Partitioning, OLAP and Data Mining
\noptions<\/span><\/p>\n

Master table “ARUP”.”SYS_IMPORT_TABLE_01″ successfully
\nloaded\/unloaded<\/span><\/p>\n

Starting “ARUP”.”SYS_IMPORT_TABLE_01″:\u00a0 arup\/******** ENCRYPTION_PASSWORD=********* table_exists_action=replace
\n<\/span><\/p>\n

Processing …<\/span><\/p>\n

\ub2e4\uc74c\uc740<\/span>\u00a0\uc784\ud3ec\ud2b8\u00a0\uc2dc<\/span>\u00a0<\/span>ENCRYPTION_PASSWORD<\/span>\u00a0<\/span>\ub9e4\uac1c\ubcc0\uc218\ub97c\u00a0\uc9c0\uc815\ud558\uc9c0\u00a0\uc54a\uc740\u00a0\uacbd\uc6b0\uc758\u00a0\uacb0\uacfc\uc785\ub2c8\ub2e4<\/span>.<\/span>\u00a0<\/span><\/p>\n

$ impdp arup\/arup
\ntables=accounts<\/span><\/p>\n

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

ORA-39174: Encryption password must
\n<\/span><\/p>\n

be supplied.<\/span><\/p>\n

\ub2e4\uc74c\uc740<\/span>\u00a0\ud2c0\ub9b0\u00a0\uc554\ud638\ub97c\u00a0\uc9c0\uc815\ud55c\u00a0\uacbd\uc6b0\uc758\u00a0\uacb0\uacfc\uc785\ub2c8\ub2e4<\/span>.<\/span>\u00a0<\/span><\/p>\n

$ impdp arup\/arup
\nENCRYPTION_PASSWORD<\/span><\/p>\n

=piglet tables=accounts<\/span><\/p>\n

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

ORA-39176: Encryption password is
\n<\/span><\/p>\n

incorrect.<\/span><\/p>\n

\uc6d0\ubcf8<\/span>\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\u00a0\uc720\ud2f8\ub9ac\ud2f0(EXP)\ub294\u00a0\uc554\ud638\ud654\ub41c\u00a0\uc5f4\uc774\u00a0\uc788\ub294\u00a0\ud14c\uc774\ube14\uc744\u00a0\uc5d1\uc2a4\ud3ec\ud2b8\ud560\u00a0\uc218\u00a0\uc5c6\uc2b5\ub2c8\ub2e4<\/span>.. <\/span><\/p>\n

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

\uacf5\uaca9\uc73c\ub85c\ubd80\ud130<\/span>\u00a0\ub370\uc774\ud130\ub97c\u00a0\ubcf4\ud638\ud558\uace0\u00a0\uae30\uc5c5\uc5d0\u00a0\uc801\uc6a9\ub418\ub294\u00a0\ub9ce\uc740\u00a0\ubc95\ub960\uc744\u00a0\uc900\uc218\ud558\ub294\u00a0\uc77c\uc740\u00a0\uac04\ub2e8\ud55c\u00a0\uc791\uc5c5\uc774\u00a0\uc544\ub2d9\ub2c8\ub2e4.
\nTDE\ub97c\u00a0\uc0ac\uc6a9\ud558\uba74\u00a0\ucf54\ub529\uc774\ub098\u00a0\ud0a4\u00a0\uad00\ub9ac\u00a0\ubcf5\uc7a1\uc131\u00a0\uc5c6\uc774\u00a0\ub370\uc774\ud130\u00a0\uc554\ud638\ud654\uc640\u00a0\uc900\uc218\ub97c\u00a0\ubaa8\ub450\u00a0\uc218\ud589\ud560\u00a0\uc218\u00a0\uc788\uc73c\ubbc0\ub85c\u00a0\ub354\u00a0\uc804\ub7b5\uc801\u00a0\ud65c\ub3d9\uc5d0\u00a0\uc8fc\ub825\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0 Transparent Data Encryption \ud22c\uba85\ud55c\u00a0\ub370\uc774\ud130\u00a0\uc554\ud638\ud654\u00a0 \ub2e8\u00a0\ud55c\u00a0\uc904\uc758\u00a0\ucf54\ub4dc\ub3c4\u00a0\uc791\uc131\ud558\uc9c0\u00a0\uc54a\uace0\u00a0\uae30\ubc00\u00a0\ub370\uc774\ud130\ub97c\u00a0\ud22c\uba85\ud558\uac8c\u00a0\uc554\ud638\ud654\ud569\ub2c8\ub2e4.\u00a0 \ub204\uad70\uac00\uac00\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\ubc31\uc5c5\u00a0\ud14c\uc774\ud504\ub97c\u00a0\ud6d4\uccd0\uac00\ub294\u00a0\uac83\uc740\u00a0\uc870\uc9c1\uc5d0\uac8c\ub294\u00a0\ucd5c\uc545\uc758\u00a0\uc545\ubabd\uc785\ub2c8\ub2e4. \ubb3c\ub860\u00a0\ubcf4\uc548\u00a0\uc2dc\uc2a4\ud15c\uc744\u00a0\uad6c\ucd95\ud558\uace0\u00a0\ub9e4\uc6b0\u00a0\uc911\uc694\ud55c\u00a0\uae30\ubc00\u00a0\uc790\uc0b0\uc740\u00a0\uc554\ud638\ud654\ud558\uace0\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\uc11c\ubc84\uc5d0\u00a0\ubc29\ud654\ubcbd\uc744\u00a0\uc124\uce58\ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098\u00a0\uce68\uc785\uc790\uac00\u00a0\uc27d\uac8c\u00a0\uc811\uadfc\ud588\uc2b5\ub2c8\ub2e4. \uce68\uc785\uc790\ub294\u00a0\ubc31\uc5c5\u00a0\ud14c\uc774\ud504\ub97c\u00a0\uac00\uc838\uac00\uc11c\u00a0\ud2c0\ub9bc\u00a0\uc5c6\uc774\u00a0\ub2e4\ub978\u00a0\uc11c\ubc84\uc5d0\uc11c\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\u00a0\ubcf5\uc6d0\ud558\uc5ec\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\u00a0\uc2dc\uc791\ud558\uace0\u00a0\ub290\uae0b\ud558\uac8c\u00a0\ub370\uc774\ud130\ub97c\u00a0\ubcf4\uace0\u00a0\uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ud55c\u00a0\uce68\uc785\uc790\ub85c\ubd80\ud130\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\ub370\uc774\ud130\ub97c\u00a0\ubcf4\ud638\ud558\ub294\u00a0\uac83\uc740\u00a0\ud6cc\ub96d\ud55c\u00a0\uc5c5\ubb34\ubc29\uc2dd\uc774\u00a0\uc544\ub2d9\ub2c8\ub2e4. \uadf8\uac83\uc740\u00a0\ub300\ubd80\ubd84\uc758\u00a0\ubc95\ub960, \uaddc\uc815, \uc9c0\uce68\uc744\u00a0\uc900\uc218\ud558\uae30\u00a0\uc704\ud55c\u00a0\uc694\uad6c\u00a0\uc0ac\ud56d\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c\u00a0\ucde8\uc57d\uc131\uc73c\ub85c\ubd80\ud130\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\u00a0\uc5b4\ub5bb\uac8c\u00a0\ubcf4\ud638\ud560\u00a0\uc218\u00a0\uc788\uaca0\uc2b5\ub2c8\uae4c? \ud55c\u00a0\ud574\uacb0\ucc45\uc740\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\u00a0\uae30\ubc00\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud558\uace0\u00a0\ubcc4\ub3c4\uc758\u00a0\uc704\uce58\uc5d0\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc800\uc7a5\ud558\ub294\u00a0\uac83\uc785\ub2c8\ub2e4. \uc554\ud638\ud654\u00a0\ud0a4\u00a0\uc5c6\uc774\u00a0\ud6d4\uccd0\uac04\u00a0\ub370\uc774\ud130\ub294\u00a0\uc4f8\ubaa8\uac00\u00a0\uc5c6\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098\u00a0\ub450\u00a0\uc0c1\ubc18\ub41c\u00a0\uac1c\ub150\u00a0\uac04\uc758\u00a0\uade0\ud615\uc744\u00a0\uc720\uc9c0\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4. \uadf8\u00a0\uac1c\ub150\uc774\ub780\u00a0\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774\u00a0\uc554\ud638\ud654\u00a0\ud0a4\uc5d0\u00a0\uc561\uc138\uc2a4\ud560\u00a0\uc218\u00a0\uc788\ub294\u00a0\ud3b8\ub9ac\uc131\uacfc\u00a0\ud0a4\u00a0\uc808\ub3c4\ub97c\u00a0\ubc29\uc9c0\ud558\ub294\ub370\u00a0\ud544\uc694\ud55c\u00a0\ubcf4\uc548\uc131\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0\u00a0\ud68c\uc0ac\uc640\u00a0\uc5f0\ubc29\u00a0\uc815\ubd80\u00a0\uaddc\uc815\uc744\u00a0\uc900\uc218\ud558\uae30\u00a0\uc704\ud574\u00a0\ubcf5\uc7a1\ud55c\u00a0\ucf54\ub529\u00a0\uc5c6\uc774\u00a0\uc989\uc2dc\u00a0\uc194\ub8e8\uc158\uc774\u00a0\ud544\uc694\ud569\ub2c8\ub2e4.\u00a0 Oracle Database 10g Release 2\uc758\u00a0\uc0c8\ub85c\uc6b4\u00a0\uae30\ub2a5\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uadf8\ub807\uac8c\u00a0\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4. \ub2e8\u00a0\ud55c\u00a0\uc904\uc758\u00a0\ucf54\ub4dc\ub3c4\u00a0\uc791\uc131\ud558\uc9c0\u00a0\uc54a\uace0\u00a0\uc5f4\uc744\u00a0\uc554\ud638\ud654\ub428\uc73c\ub85c\u00a0\uc120\uc5b8\ud560\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\uac00\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc0bd\uc785\ud560\u00a0\ub54c\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00\u00a0\ud22c\uba85\ud558\uac8c\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud558\uc5ec\u00a0\uadf8\u00a0\uc5f4\uc5d0\u00a0\uc800\uc7a5\ud569\ub2c8\ub2e4. \ub9c8\ucc2c\uac00\uc9c0\ub85c\u00a0\uc0ac\uc6a9\uc790\uac00\u00a0\uc5f4\uc744\u00a0\uc120\ud0dd\ud560\u00a0\ub54c\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc790\ub3d9\uc73c\ub85c\u00a0\ud574\ub3c5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c\u00a0\ubaa8\ub4e0\u00a0\ud504\ub85c\uc138\uc2a4\uac00\u00a0\ud22c\uba85\ud558\uac8c\u00a0\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758\u00a0\ucf54\ub4dc\ub97c\u00a0\ubcc0\uacbd\ud558\uc9c0\u00a0\uc54a\uace0\u00a0\uc218\ud589\ub418\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\uc774\u00a0\uae30\ub2a5\uc5d0\ub294\u00a0\uc774\uc5d0\u00a0\uc798\u00a0\uc5b4\uc6b8\ub9ac\ub294 TDE(\ud22c\uba85\ud55c\u00a0\ub370\uc774\ud130\u00a0\uc554\ud638\ud654)\ub77c\ub294\u00a0\uc774\ub984\uc774\u00a0\ubd99\uc5ec\uc84c\uc2b5\ub2c8\ub2e4.\u00a0 \uc791\ub3d9\u00a0\ubc29\uc2dd\u00a0 \uc804\uc5d0\u00a0Oracle Magazine 1\/2\uc6d4\ud638 “\ub370\uc774\ud130\u00a0\uc790\uc0b0\uc758\u00a0\uc554\ud638\ud654” \uc5d0\uc11c\u00a0\uc554\ud638\ud654\u00a0\uae30\ucd08\uc5d0\u00a0\ub300\ud574\u00a0\ub2e4\ub8e8\uc5c8\uc2b5\ub2c8\ub2e4. \uc8fc\uc694\u00a0\uc0ac\ud56d\uc744\u00a0\ub2e4\uc2dc\u00a0\uc124\uba85\ud558\uba74, \uc554\ud638\ud654\ub294\u00a0\uc554\ud638\ud654\u00a0\uc54c\uace0\ub9ac\uc998\uacfc\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\u00a0\uc785\ub825\u00a0\ub370\uc774\ud130\uc5d0\u00a0\uc801\uc6a9\ud574\uc57c\u00a0\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0\u00a0\uc554\ud638\ud654\ub41c\u00a0\uac12\uc744\u00a0\uc131\uacf5\uc801\uc73c\ub85c\u00a0\ud574\ub3c5\ud558\ub824\uba74\u00a0\ub3d9\uc77c\ud55c\u00a0\uc54c\uace0\ub9ac\uc998\uacfc\u00a0\ud0a4\u00a0\uac12\uc744\u00a0\uc54c\uc544\uc57c\u00a0\ud569\ub2c8\ub2e4. \uadf8\u00a0\uae30\uc0ac\uc5d0\uc11c\u00a0\uc800\ub294\u00a0\uc624\ub77c\ud074\uc774\u00a0\uc81c\uacf5\ud558\ub294\u00a0\uc554\ud638\ud654\u00a0\ud234\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uc554\ud638\ud654\u00a0\uae30\ubc18\u00a0\uad6c\uc870\ub97c\u00a0\uad6c\ucd95\ud558\ub294\u00a0\ubc29\ubc95\uc744\u00a0\uc124\uba85\ud558\uc600\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 Oracle Database 10g Release 2\uc640 TDE\ub97c\u00a0\uc0ac\uc6a9\ud560\u00a0\uacbd\uc6b0\u00a0\uc554\ud638\ud654\u00a0\uae30\ubc18\u00a0\uad6c\uc870\ub97c\u00a0\uad6c\ucd95\ud560\u00a0\ud544\uc694\uac00\u00a0\uc5c6\uc2b5\ub2c8\ub2e4. \ub2e8\uc9c0\u00a0\uc554\ud638\ud654\ud560\u00a0\uc5f4\uc744\u00a0\uc815\uc758\ud558\uae30\ub9cc\u00a0\ud558\uba74Oracle Database 10g\uc5d0\uc11c\u00a0\uadf8\u00a0\uc5f4\uc774\u00a0\ud3ec\ud568\ub41c\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\ub300\ud55c\u00a0\uc554\ud638\ud654\u00a0\ubc29\uc2dd\uc758\u00a0\uc548\uc804\ud55c\u00a0\uc554\ud638\ud654\u00a0\ud0a4\ub97c\u00a0\uc0dd\uc131\ud558\uace0\u00a0\uc9c0\uc815\ud55c\u00a0\uc554\ud638\ud654\u00a0\uc54c\uace0\ub9ac\uc998\uc744\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\uadf8\u00a0\uc5f4\uc758\u00a0\uc77c\ubc18\u00a0\ud14d\uc2a4\ud2b8\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud569\ub2c8\ub2e4. \uc774\u00a0\ud14c\uc774\ube14\u00a0\ud0a4\ub97c\u00a0\ubcf4\ud638\ud558\ub294\u00a0\uac83\uc774\u00a0\ub9e4\uc6b0\u00a0\uc911\uc694\ud569\ub2c8\ub2e4. Oracle Database 10g\ub294\u00a0\uc9c0\uac11\uc774\ub77c\uace0\u00a0\ubd80\ub974\ub294\u00a0\uc548\uc804\ud55c\u00a0\uc704\uce58\uc5d0\u00a0\uc800\uc7a5\ub418\ub294\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub97c\u00a0\uc0ac\uc6a9\ud558\uc5ec\u00a0\ub370\uc774\ud130\ub97c\u00a0\uc554\ud638\ud654\ud569\ub2c8\ub2e4. \uc774\u00a0\ub9c8\uc2a4\ud130\u00a0\ud0a4\ub294\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0\uc11c\ubc84\uc758\u00a0\ud30c\uc77c\uc77c\u00a0\uc218\u00a0\uc788\uc2b5\ub2c8\ub2e4. […]<\/p>\n","protected":false},"author":1,"featured_media":2427,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[336],"tags":[760,761,824,762],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/data-encryption-facts.jpg?fit=468%2C327","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3233"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3233"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3233\/revisions"}],"predecessor-version":[{"id":3235,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3233\/revisions\/3235"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2427"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3233"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}