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

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 01:34:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.