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

Hi,

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.

Regards
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: Sun Dec 04 12:54:05 CST 2016

Total time taken to generate the page: 0.07600 seconds