This content has been marked as final. Show 5 replies
What do you see if you query user_objects?
select * from user_objects where object_name = 'ABC';
orawen wrote:select owner, object_name, object_type from all_objects where object_name like ('ABC%')
Why am seeing this error? - Unable to create but not existing??!!
SQL> CREATE TABLE ABC(
2 SCHEDULEID NUMBER,
3 TASKID NUMBER,
4 CREDENTIALS VARCHAR2(128),
5 constraint ABC_PK PRIMARY KEY(SCHEDULEID, TASKID)
CREATE TABLE ABC(
ERROR at line 1:
ORA-00955: name is already used by an existing object
SQL> desc ABC
ORA-04043: object ABC does not exist
No rows returns when query on either user_objects or all_objects.
I wonder if the DB server (maybe in public synonym area) corrupted somehow caused this issue?
You need to query DBA_OBJECTS.
There're 119 objects with the same name appearing in the DBA_Objects list.
But they are all correctly seating in their owner?
If UserA create a table 'TabA', does this prevent UserB to create the same named table on the same DB server?