tablespace maintenance tasks

I just had to guide one of our DBA this morning. How to get free of segments in SYSTEM tablespace : tables SQL> select owner, table_name from dba_tables where tablespace_name=’SYSTEM’ and owner not in (‘SYS’,’SYSTEM’,’OUTLN’); OWNER TABLE_NAME —– ———- SCOTT T SQL> alter table scott.t move tablespace users; Table altered. SQL> select owner, table_name from […]

latest patchset

Huge downtime on forums.oracle.com today. After landing on an Error-500 page, I discovered a quick and neat overview of oracle patchsets, accessible without metalink account : http://www.oracle.com/technology/support/patches.htm Still waiting for 9.2.0.8 Solaris by the way, announced for 2006Q3, whatever this mean

sqlnet.wallet_override=true

I recently posted about Oracle Password Repository (OPR). I did get a comment from Andreas Piesk about something similar in Oracle, the wallet. Let’s do a quick test. First, I create a .sqlnet.ora in my home directory (I do not want to mess up the system-wide sqlnet.ora). $ cat /home/lsc/.sqlnet.ora SQLNET.WALLET_OVERRIDE=TRUE WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/home/lsc))) I now create […]

select last rows

I just read about a query to retrieve last modification row of a date SQL> SELECT ora_rowscn FROM tab_test; ORA_ROWSCN ———- 351744 351744 351744 351744 351744 351744 6 rows selected. SQL> UPDATE tab_test SET valeur=valeur*1.1 WHERE col_id=1; 3 rows updated. SQL> commit; Commit complete SQL> SELECT ora_rowscn FROM tab_test: ORA_ROWSCN ———- 351744 351744 351744 371423 […]