change database Schema (Universe Designer)

[Former Member]

I have created a universe with several derivated tables from an Oracle database using an schema called mudev that corresponds to the development environment, now I have to change the universe to the mupru schema.

What can I do since every derivated table has mudev.<tablename>.<columnname> in the sql statements?

Do I have to change them one by one manually? (This is a little crazy solutions since I got many derivated tables)

If extra information needed, just let me know.....

[Former Member]

I am afraid you will have to do it manually.

it is for this reason we should not give owner in the SQL statements. Rather the sql should only contain table_name.column_name. If you want to give owner it should always be given by right clicking the derived table and then specify owner in the owner box.

Thanks

Prashant