Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Referenced Owner "SYS" issue

jerry8989Oct 4 2011 — edited Oct 7 2011
I have a view that when I go to the dependencies tab shows me a row that says
Referenced Owner: SYS
Referenced Name: STANDARD
Referenced Type: PACKAGE

When I run the same script on a different db I don't get this reference. There is not a SYS package within that db.

Is there a grant statement that adds this dependency? I have to make my new schema exactly like my old one except for tables that we are not using and we are making sure out scripts are correct. I want to correct this so both schema match on all tables, procedures, views, etc..

Any help would be appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2011
Added on Oct 4 2011
12 comments
1,250 views