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...

How can I check which tables that are being audited in my database?

›
The experiences in this article is applicable to all Oracle versions using classic auditing setup. To check which tables are currently ...
Monday, December 15, 2014

How to solve "ORA-06502: PL/SQL: numeric or value error" when cloning a database

›
While attempting to clone an Oracle 11gR2 production database, Oracle returned "ORA-06502: PL/SQL: numeric or value error". The ...
4 comments:
Thursday, December 4, 2014

How to work around ORA-00845: MEMORY_TARGET not supported on this system during startup

›
On Linux platforms, you need to adjust the size of the shared memory file system (/dev/shm) to match the size of your memory_target or memor...
Monday, December 1, 2014

How to find and change the default temporary tablespace and default tablespace for a database instance

›
set lines 200 col description format a50 col property_value format a30 col property_name format a30 SELECT * FROM DATABASE_PROPERTIES WHER...