I have build some cubes on a oracle server say ORACLE_SERVER_OLD with
DSN pointing to the same ,Lets say the DSN name is "TEST" , After some
days i have to point all these cubes to a different oracle server say
"ORACLE_SERVER_NEW".

What i did was changed the DSN Information to point to
ORACLE_SERVER_NEW and kept the DSN name same as "TEST".

This Dosent work , Says "Table or Views doesnt exist".. (Guess it
is looking for the prefix as ORACLE_SERVER_OLD."Table name" ..

Is there anyway out where i could just point all my cube tables to the
new DB.

Thanks
Nilesh.