We have a version 9 database with a table named "JOB" owned by schema "DBO". We are upgrading to Oracle v11 but notice the database now has a public synonym named "JOB" that points to a SYS object.
The JOB table in our database is a key table and there are thousands of users that depend on the public synonym JOB to point to the DBO.JOB table.
Anyone else have this issue. We would like to consider dropping the JOB public synonym and replacing with public synonym JOB that points to our DBO.JOB table. Concerned for what might break. We are opening SR, but hoping others might have some input.