Skip to Main Content
Forums

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!

Schema name prefix

862489Jun 12 2011 — edited Jun 12 2011
I have a table in a remote database, a db link is created for the same

Should I prefix schemaname before the table name to access or else simply the tablename@dblink name is suffice?

select trn_id from trn_header@linkname or else

select trn_id from SCHEMANAME.trn_header@link name? where trn_header is a table of a different database

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2011
Added on Jun 12 2011
#schema
2 comments
518 views