OraFAQ Forum: Server Administration » dbms

Home » RDBMS Server » Server Administration » dbms_aw package creation (Oracle 9i, 9.2.0.1.0, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_aw package creation [message #293844]

Tue, 15 January 2008 04:32

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

Report message to a moderator

Re: dbms_aw package creation [message #293872 is a reply to message #293844]

Tue, 15 January 2008 06:54

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.

Report message to a moderator

Previous Topic:	ORA-12519, Listener refused the connection
Next Topic:	Recommendations for maintaining Prod support DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:44:47 CST 2024