3 Replies Latest reply: Nov 14, 2012 9:15 AM by JeromeFr RSS

    Interface on Base table vs View

    RG 007
      Hi Gurus,

      I am moving data within same database(OR 11G) from one schema to another schema.
      If I create an interface using source table, or if first I create view of source tables in staging schema and then use that view
      in my interface.
      will it create any performance issue(pros and cons) or any side effects.

      Reason: I want to create view in staging then I will have all permissions for that view like create trigger, which I don't have on any object in source schema.

      Thanks in advance.