Posts Tagged ‘oracle’

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!

Dec 26th, 2008 | Filed under linux, oracle

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 set processes=200 scope=spfile; In case you are unable to access apex website remotely, run the […]

Dec 4th, 2008 | Filed under oracle

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 the correct tablespace: Import the dump file using the INDEXFILE= option Edit the indexfile. Remove […]

Jan 30th, 2007 | Filed under oracle

select * from ( select a.*, rownum rnum from ( YOUR_QUERY_GOES_HERE — including the order by ) a where rownum <= MAX_ROWS ) where rnum >= MIN_ROWS

Apr 5th, 2006 | Filed under oracle