noqqe » blog | sammelsurium | photos | projects | about

Oracle

2012-01-04 @ Databases, Oracle

Connect:

/usr/lib/nagios/plugins ##  su - oracle
/home/oracle > sqlplus / as user

History:

SYS@ruix AS SYSDBA> ed

Query:

select owner,index_name from dba_indexes where index_name like 'VALUE%'
## % ist normale wildcard