11th June 2010
in
OraERR, Tips
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:
[...]
No Comments
3rd June 2010
in
Backup, Tips
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 [...]
No Comments
1st June 2010
in
Tips
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 [...]
1 Comment