Database Software

Hi

I've a strange problem. I created dimension using Oracle Enterprise manager console and everything works fine.

I created more dimensions and copied CREATE DIMENSIONs and PL/SQL blocks into one script. Than i deleted all dimensions and run created script in sqlplus and for every CREATE DIMENSION i got an error:


ORA-30371: Column cannot define level...

But dimensions were created and looks fine.

When i try to execute CREATE DIMENSION and after this PL/SQL block in another client application, command is sucessfully finished.

Have any ideas?

And I have another problem. I'm connection to another database, where i'm not an admin. I told admin of this database to upgrade to version 9.2.0.6. When i try to run:

cwm2_olap_metadata_refresh.mr_refresh;

i got an error message cwm2_olap_metadata_refresh.mr_refresh is not declared, but in my database everything works fine.

Thx for your help.