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.