7 Replies Latest reply: Oct 8, 2012 5:53 AM by jeneesh RSS

    Create Index on another schema table stored in my table

    sri333
      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