Database DataWarehousing (MOSC)

MOSC Banner

dbms_aw.aw_copy fails with ORA-34492: Analytic workspace object SYS.DATETOTIMEPD does not exist

edited Jul 28, 2011 10:51PM in Database DataWarehousing (MOSC) 1 commentAnswered
i cant for the life of me figure out why i cannot copy 1 AW to a new one.  here is my script, help is very much appreciated!

thanks!

--script

begin
dbms_aw.aw_copy('TESTOLD', 'TEST', 'EMS_DEV', 1);
end;
/

--output

Error starting at line 16 in command:
begin
dbms_aw.aw_copy('TESTOLD', 'TEST', 'EMS_DEV', 1);
end;
Error report:
ORA-34492: Analytic workspace object SYS.DATETOTIMEPD does not exist.
ORA-06512: at "SYS.DBMS_AW", line 1019
ORA-06512: at "SYS.DBMS_AW", line 986
ORA-06512: at line 2
34492. 00000 -  "(MXMSERR00) Analytic workspace object %q does not exist."
*Cause:   
*Action:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center