Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

aw_copy does not work in 11.2.0.1.0?

user11925394Oct 3 2011
Hi,

I try to use the aw_copy procedure from dbms_aw package.

Here is the command I use:

>
execute dbms_aw.aw_attach('T00_TST');
execute dbms_aw.aw_copy('T00_TST', 'T01_TST', 'GDWH07_OLAPC', 2);
>

And here the output:

>
SQL*Plus: Release 11.2.0.1.0 Production on Mo Okt 3 11:34:05 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


PL/SQL procedure successfully completed.

BEGIN dbms_aw.aw_copy('T00_TST', 'T01_TST', 'GDWH07_OLAPC', 2); END;

*
ERROR at line 1:
ORA-34344: Analytic workspace T00_TST is not attached.
ORA-06512: at "SYS.DBMS_AW", line 67
ORA-06512: at "SYS.DBMS_AW", line 131
ORA-06512: at "SYS.DBMS_AW", line 947
ORA-06512: at "SYS.DBMS_AW", line 1016
ORA-37162: OLAP error
XOQ-02109: Top level object "GDWH07.T00_417_5" already exists.
XOQ-02109: Top level object "GDWH07.T00_417_4" already exists.
XOQ-02109: Top level object "GDWH07.T00_417_3" already exists.
XOQ-02109: Top level object "GDWH07.T00_417_2" already exists.
XOQ-02109: Top level object "GDWH07.T00_417_1" already exists.
XOQ-02100: cannot parse server XML string
ORA-06512: at "SYS.DBMS_AW", line 986
ORA-06512: at line 1
>

Can anybody help me?
Do I something wrong?

Thank you,

M.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2011
Added on Oct 3 2011
0 comments
197 views