Hi rahutnimje,
On your first question:
Are you attempting to create a Federation Server view on an Oracle DBMS view or a BASE SAS view?
Could you list the CREATE DSN statement used in Federation Server?
On your second question:
The ALTER CACHE...REFRESH will create a new cached object with default naming. You can issue a DROP CACHE statement to remove the view.
Clark
... View more