oracle XE “cannot access http://127.0.0.1:8080/apex”
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!
Oracle XE Tuning
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 following command as sys
exec dbms_xdb.setListenerLocalAccess(false);
Import tables to a different tablespace?
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 remarks and specify the correct tablespaces.
- Run this indexfile against your database, this will create the required tables in the appropriate tablespaces
- Import the table(s) with the IGNORE=Y option.
Change the default tablespace for the user:
- Revoke the “UNLIMITED TABLESPACE” privilege from the user Revoke the user’s quota from the tablespace from where the object was exported. This forces the import utility to create tables in the user’s default tablespace.
- Make the tablespace to which you want to import the default tablespace for the user
- Import the table
Getting n of m rows in a query – Oracle 9i and +
select *
from (
select a.*, rownum rnum
from ( YOUR_QUERY_GOES_HERE — including the order by ) a
where rownum <= MAX_ROWS
)
where rnum >= MIN_ROWS
