Tuesday, November 1, 2011

Create Or Replace ORA-00955: name is already used by an existing object

ORA-00955: name is already used by an existing object

when create or replace is used look at the synonyms to see whether synonym with that name exists.

For example

CREATE OR REPLACE test_synonym ..............

check whether synonym test_synonym already exists.

No comments:

Post a Comment