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!

Create Index on another schema table stored in my table

sri333Oct 8 2012 — edited Oct 8 2012
Hi,
I want to create index on a table column which is in another schema from my schema and the index to be stored in my schema.

ex: current user 'hr'
sql>create index idx1 on scott.emp(eno);

Does the above query works??

thanks,
Sri
This post has been answered by jeneesh on Oct 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2023
Added on Oct 8 2012
9 comments
6,474 views