Tuesday, January 20, 2015

Query the registry!

›
To view the different options installed in the database, you should use DBA_REGISTRY, as follows: set lines 200 pages 100 col comp_name f...
Friday, January 16, 2015

How to use regexp_substring to extract the 5-digit version

›
SELECT BANNER, REGEXP_SUBSTR(BANNER, '[[:digit:]]+[[:punct:]]+.[^-]{1,}',1,1) "5 digit Version" FROM V$VERSION WHERE BAN...
Monday, January 12, 2015

Getting ORA-01031: insufficient privileges when data dictionary table is being used in a view

›
I must admit I have been consulted in these situations before, but since then I had forgotten how it worked and failed to take notes on how ...
Tuesday, January 6, 2015

How to use multiple delimiters in awk

›
When creating a script for cloning, I wanted to perform some initial checks. One of them was to make sure the listener for the source datab...
Monday, December 29, 2014

How to move LOB segments in a sub-partitioned table to a new tablespace

›
Find the sub-partitions that you would like to relocate: SELECT TABLE_OWNER,TABLE_NAME,COLUMN_NAME,LOB_NAME,SUBPARTITION_NAME,LOB_PARTI...

How to move LOB segments in a partitioned table to a new tablespace

›
During an attempt to move a partition that contained a LOB segment from one tablespace to another, I hit the infamous ORA-14511 "Canno...
1 comment:
Wednesday, December 17, 2014

Why are statements executed by SYS not found in the DB audit trail?

›
Even if Oracles default auditing is set up, it surprised me that audit information did not appear in the audit trail, for statements that s...