한국생상성본부 웹 취약점 분석전문가 교육중


[oracle@oracle ws2]$ sqlplus "/as sysdba"
SQL> alter system set encryption key identified by "ora1cle2";

SQL> alter system set encryption wallet open identified by "ora1cle2";


SQL> CREATE TABLESPACE tde DATAFILE 'tde01.dbf' SIZE 500K;

-- tablespace 경로
-- /u01/app/oracle/product/10.2.0/db_1/dbs
-- $ORACLE_HOME/dbs


SQL> create table hr.emp_enc(
    first_name varchar2(20),
    last_name varchar2(20),
    salary number encrypt,
    job_nonenc varchar2(20),
    job varchar2(20) encrypt
) tablespace tde;

SQL> insert into hr.emp_enc values ('mir', 'baek', 10000, 'CurriculumA', 'CurriculumB');
SQL> commit;

-- 입력된 테이타 확인
-- select * from hr.emp_enc;

-- tablespace 분리
SQL> alter tablespace tde offline;

-- sqlplus 종료

[oracle@oracle dbs]$ cd $ORACLE_HOME/dbs
[oracle@oracle dbs]$ strings tde01.dbf

Posted by incree

2013/06/21 01:24 2013/06/21 01:24
, ,
Response
0 Trackbacks , 0 Comments
RSS :
http://www.incree.com/tc/incree/rss/response/239

Trackback URL : 이 글에는 트랙백을 보낼 수 없습니다


Notices

Archives

Authors

  1. incree

Recent Trackbacks

Calendar

«   2017/08   »
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

Site Stats

Total hits:
419290
Today:
94
Yesterday:
111