Oracle Encrypted Tablespaces
實驗:建立加密表空間,並插入測試資料
一:檢視現有wallet
SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS
-------------------- ----------------------------------- ------------------
file
/u01/app/oracle/admin/orcl/wallet
CLOSED
二:建立目錄
SQL> ho mkdir /u01/app/oracle/admin/orcl/wallet
三:建立加密KEY
SQL> alter system set encryption key identified by oracle;
四:檢視現有wallet狀態
SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS
-------------------- ----------------------------------- ------------------
file /u01/app/oracle/admin/orcl/wallet
OPEN
五:建立加密表空間
SQL> create tablespace test_encrypt datafile '/u01/app/oracle/oradata/orcl/test_encrypt01.dbf' size 10M encryption default storage(encrypt);
Tablespace created.
SQL> SELECT TABLESPACE_NAME, ENCRYPTED FROM DBA_TABLESPACES;
TABLESPACE_NAME ENC
------------------------------ ---
SYSTEM NO
SYSAUX NO
UNDOTBS1 NO
TEMP NO
USERS NO
TEST_ENCRYPT YES
6 rows selected.
SQL> SELECT NAME, ENCRYPTIONALG ENCRYPTEDTS
FROM V$ENCRYPTED_TABLESPACES, V$TABLESPACE
WHERE V$ENCRYPTED_TABLESPACES.TS# = V$TABLESPACE.TS#;
NAME ENCRYPT
------------------------------ -------
TEST_ENCRYPT AES128
六:建立測試資料
SQL> create table t1(id number,name varchar2(20)) tablespace
test_encrypt;
SQL> create table t2(id number,name varchar2(20)) tablespace users;
SQL> insert into t1 values(1,'a');
SQL> commit;
SQL> insert into t2 values(2,'b');
SQL> commit;
七:重啟資料庫後,錢包自動關閉,並且無法查詢加密表空間裡的資料
SQL> shutdown immediate
SQL> startup
SQL> select * from t1;
select * from t1
*
ERROR at line 1:
ORA-28365: wallet is not open
---資料庫重啟後,錢包會自動關閉
SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS
-------------------- ----------------------------------- ------------------
file /u01/app/oracle/admin/orcl/wallet
CLOSED
八:開啟錢包
SQL>
alter system set wallet open identified by oracle;
System altered.
---SQL> alter system set wallet close identified by oracle;(關閉錢包)
SQL> select * from t1;
ID NAME
---------- --------------------
1 a
九:將t2表移動到加密表空間中
SQL>
alter table t2 move tablespace test_encrypt;
System altered.
歡迎關注我的微信公眾號"IT小Chen",共同學習,共同成長!!!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29785807/viewspace-2141957/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Transporting TablespacesOracle
- oracle bigfile tablespacesOracle
- Temporary tablespaces in RAC ? Oracle databas...Oracle
- ORACLE撤銷表空間(Undo Tablespaces)Oracle
- Transportable Tablespaces (TTS) for Oracle Database [ID 1461278.2]TTSOracleDatabase
- Encrypted Wallet加密方面的理解加密
- Oracle 12C RMAN Duplicating Tablespaces Within a PDBOracle
- Overview of Tablespaces (38)View
- Oracle 12c RMAN Duplicating a Subset of the Source Database TablespacesOracleDatabase
- Oracle OCP 1Z0-053 Q291(encrypted tablespace&redo logs)Oracle
- How to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1]ROSPlatform
- Using Multiple Tablespaces (46)
- Transport of Tablespaces Between Databases (59)Database
- 2.5 Overview of Tablespaces and Database Files in a CDBViewDatabase
- oracle10g_impdp工具測試學習_之二_transport_tablespacesOracle
- Backing Up Individual Tablespaces with RMAN
- Transporting Tablespaces with Self-ContainedAI
- Step 8: Create Additional Tablespaces (66)
- Oracle OCP 1Z0 053 Q65(dictionary-managed&local-managed tablespaces)Oracle
- DELETE from DBA_TABLESPACES IN 10Gdelete
- use multiple tablespaces to perform the following tasks (47)ORM
- ORA-1578 Corrupt Block Found in Encrypted Database (Doc ID 1329437.1)BloCDatabase
- Supporting Bigfile Tablespaces During Database Creation (77)Database
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- 淺談mysql中各種表空間(tablespaces)的概念MySql
- Master Note for Transportable Tablespaces (TTS) -- Common Questions_1166564.1ASTTTS
- 10g : Transportable Tablespaces Across Different Platforms [ID 243304.1]ROSPlatform
- 10g+: Transportable Tablespaces Across Different Platforms [ID 243304.1]ROSPlatform
- ORA-22868: table with LOBs contains segments in different tablespacesAI
- How to Move a Database Using Transportable Tablespaces (文件 ID 1493809.1)Database
- 【OCP最新題庫解析(052)--題8】Which two are true about undo tablespaces?
- mysql 5.7啟動報錯"Expected to open undo tablespaces but was able to find only 0"MySql
- Removing All Encrypted TBS, RAC DB Getting ORA-28365 Won't Start Up_1911970.1REM
- 關於tablespace在read only狀態下的DML ,DDL操作--Read-Only Tablespaces
- oracle DBLink oracleOracle
- Oracle 中$ORACLE_HOME/bin/oracle檔案Oracle
- oracle 修改ORACLE例項Oracle
- oracle安裝工具目錄常用解釋oracle wallet manager/Oracle Directory Manager /oracle net manager /Oracle Net ManagOracle