Tech Tips and Tricks
Using JNDI javax.naming.Context context = new javax.naming.InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource) context.lookup(“java:comp/env/jdbc/XXXJNDINAMEXXX”); java.sql.Connection con = ds.getConnection();
I had installed oracle XE on CentOS and was not able to connect to web admin for past two days. Finally after a long two days of search, found this. Thanks!
In order to use Oracle XE under normal load, database sessions and processes need to be increased. This could be some as follows: SQL> show parameters sessions SQL> alter system set sessions=250 scope=spfile; SQL> show parameters processes SQL> alter system Continue reading Oracle XE Tuning
Oracle offers no parameter to specify a different tablespace to import data into. Objects will be re-created in the tablespace they were originally exported from. One can alter this behaviour by following one of these procedures: Pre-create the table(s) in Continue reading Import tables to a different tablespace?
select * from ( select a.*, rownum rnum from ( YOUR_QUERY_GOES_HERE — including the order by ) a where rownum <= MAX_ROWS ) where rnum >= MIN_ROWS