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


[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/12   »
          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:
435938
Today:
113
Yesterday:
230