APEX

Hi,

I created a workspace after installing APEX 3.2.1 on an XE database. To install APEX I completed the following steps:

Create the Tablespaces:

CREATE TABLESPACE APEX datafile ‘D:\oraclexe\oradata\XE\APEX.dbf’
SIZE 500M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;


CREATE TABLESPACE APEX_FILES datafile ‘D:\oraclexe\oradata\XE\APEX_FILES.dbf’
SIZE 100M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

Run the file:

@apexins APEX APEX_FILES TEMP /i/

Upload the images:

@apxldimg.sql D:\Apex\apex_3.2.1\apex

Then I went on to change the password.

I ran http://127.0.0.1:8080/apex/apex_admin and entered my username and password.

There are no errors in my install files. Everything seems to have completed correctly yet I cannot create a workspace.

When I create the workspace I get the following error:

ORA-01950: no privileges on tablespace 'SYSTEM'

If I press return to application and submit it a second time I get the following error:

ORA-20001: Request 1039726422996081 could not be processed. -20001 ORA-20001: Unable to grant initial privs. ORA-20001: Error with: GRANT CONNECT TO "TWODAYSPLUS" ORA-01917: user or role 'TWODAYSPLUS' does not exist


Any help is greatly appreciated.

Regards,

Shauna

Edited by: user649940 on 01-Sep-2009 07:07