Archive for June, 2010

ORA-08102: index key not found, obj# … Solution to resolve

When updated table, found error: ORA-08102: index key not found, obj# 116528, file 96, block 8795 (2) This problem I had resolved by rebuild indexes (ORA-08102 on index objects). But today I can not use this solution: [...]


Freeing up db_recovery_file_dest reclaimable space.

I temporarily reduced db_recovery_file_dest_size to force the database to free reclaimable space from recovery_file_dest. This reduced disk usage of ASM_ORADATA217 by over 320GB. SYS>show parameter recovery NAME [...]


Cannot export empty tables in 11.2

In 11g there is no segment allocated to the table until you insert, so the EXP utility fails to export empty tables. [oracle@dev-oranode-221 ~]$ sqlplus a/a SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 30 14:38:06 [...]




sponsored link