aw_copy does not work in 11.2.0.1.0?
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.