Some Oracle commands — by khairil on

0 comment

1.set the oracle xmltoollite instance (windows cmd) e.g. set ORACLE_SID >set ORACLE_SID=xmltoollite 2.login to sqplus as dba in xmltoolli...

TNS-12519: TNS:no appropriate service handler found in Oracle10g XE — by khairil on

0 comment

this is a bug on how OracleXE monitors processes. database didn't register with the listener and that the processes parameter needed to ...

enable remote access to Oracle10g XE — by khairil on

0 comment

by default remote access is not enabled for XE version. So we can only access db in our localhost. To enable remote access, connect as '...

oracle : display all tables in database — by khairil on

0 comment

SELECT owner, table_name FROM all_tables order by OWNER ;

windows command shell to run all sqls in a folder for oracle /sqlplus — by khairil on

0 comment

let say u have a set of sqls to run in a folder(sql1.sql,sql2.sql,sql3.sql bla bla bla..), this script might be useful. create a batch file(...

oracle - check cursor (connection) — by khairil on

0 comment

--total cursors open, by session select a.value, s.username, s.sid, s.serial# from v$sesstat a, v$statname b, v$session s where a.statistic#...