Tag Archives: 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 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