This discussion is archived
7 Replies Latest reply: Oct 8, 2012 3:53 AM by jeneesh RSS

Create Index on another schema table stored in my table

sri333 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points