Home » RDBMS Server » Server Administration » dbms_aw package creation (Oracle 9i,, Windows XP)
dbms_aw package creation [message #293844] Tue, 15 January 2008 04:32 Go to next message
Messages: 56
Registered: July 2005
Location: Indore


I wanted to know about how We can create aw and other OLAP packages for OLAP.

when I try to use these packages it gives me
SQL> exec dbms_aw.execute('aw attach gsw_aw.gsw_aw');
BEGIN dbms_aw.execute('aw attach gsw_aw.gsw_aw'); END;

ERROR at line 1:
ORA-33262: (DBERR01) Analytic workspace GSW_AW.GSW_AW does not exist.
ORA-06512: at "SYS.DBMS_AW", line 42
ORA-06512: at "SYS.DBMS_AW", line 87
ORA-06512: at line 1
to solve this error.

Amit Nanote
Re: dbms_aw package creation [message #293872 is a reply to message #293844] Tue, 15 January 2008 06:54 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

First check

ORA-33262: (DBERR01) Analytic workspace string does not exist.

Cause: The analytic workspace requested does not seem to be in the current database

Action: Check that you are in the correct schema and have access to the requested AW.
Previous Topic: ORA-12519, Listener refused the connection
Next Topic: Recommendations for maintaining Prod support DB
Goto Forum:

Current Time: Fri Oct 21 13:41:35 CDT 2016

Total time taken to generate the page: 0.17936 seconds