Oracle Content Index

Index page - Oracle

This is Index page of this blog related to Oracle post, it could contains everything for Oracle DBA, SQL, PLSQL, Issues in Queries, Import, Export, IMPDP, EXPDP, Oracle startup Errors, Indexes and many more. Oracle is very vast i am not able to cover everything here but i am writing all my learning, issues that i have faced. All below articles are already a part of this blog, you can use this page for indexing purpose.

DML
Datatypes
 http://j4info.blogspot.in/2013/11/dml-datatype.html
alter
alter table move


index
why query is get faster after create a index // btree indexes 
Find used unused index
Full Text Index / Domain Index ( create datastore, assign tablespace for storage)
Lexer - Basic Lexer - Printjoins in DOMAIN index
domain index is marked LOADING/FAILED/UNUSABLE

Space Tuning / Reclaim space from tablespace / Freeup unused space


Oracle DBA
Oracle install (os red hat linux)
Oracle deinstall (windows)
ORA-00845: MEMORY_TARGET not supported on this system ...    dev/shm error
Oracle startup error : ORA-01078: failure in processing system parameters LRM-00109
ORA-01102 cannot mount database in EXCLUSIVE mode

Manual database creation / Restore reuse old datafiles in new instance

No comments:

Post a Comment

web stats