Chris的Oracle学习笔记

实验：TEST表空间下有一张TT表，OWNER=TEST用户SQL> create table tt(col1 number primary key,col2 varchar2(10),col3 varchar2(10));Table created.SQL> CREATE MATERIALIZED VIEW LOG ON tt;        Mate

OCP考试有这样一道题目：View the Exhibit and examine the structure of the ORDERS table: The ORDER_ID column has the PRIMARY KEY constraint and CUSTOMER_ID has the NOT NULL constraint. Evaluate the foll

Oracle supports bitmap indexes on partitioned and nonpartitioned index-organized tables.A mapping table is required for creating bitmap indexes on an index-organized table.The mapping table

1.      为Transparent Data Encryption指定 Wallet存储路径  1.1  创建目录 ‘/home/oracle/ora_wallet/’ 用于存放wallet 1.2  修改sqlnet.ora.ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)        (METHOD_D