Skip to Main Content

SQL Developer

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!

DDL "omit schema" option should only ignore current schema

B.DelméeFeb 15 2015 — edited Feb 16 2015

otherwise you get misleading statements for synonyms, e.g:

create synonym XYZ for XYZ;

-- instead of

create synonym target_schema.XYZ for source_schema.XYZ;

note this seems to work correctly for views, though.

Unchecking the "schema" box in the DDL options should only result in the omission of the logged-in (or better yet, current) schema for the connection.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2015
Added on Feb 15 2015
3 comments
827 views