Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Undocumented support for likely for Advanced and/or Hybrid Columnar Compression
BEGIN
IF prvt_compress.get_arch_comp(78810,78810,2) THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
BEGIN
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.PRVT_COMPRESS", line 62
ORA-06512: at line 2
-- it appears that the TYPE# returned in the above query is the what this function
-- wants as replacing the "2" with a "1" eliminates the exception
BEGIN
IF prvt_compress.get_arch_comp(78810,78810,1) THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/ F
DECLARE
retVal NUMBER;
BEGIN
retVal := prvt_compress.get_ts_num(6445, 6445, 'PARTITION');
dbms_output.put_line(TO_CHAR(retVal));
END;
/
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.PRVT_COMPRESS", line 81
ORA-06512: at line 4