Reputation: 61
How to execute a SQL script(.sql) in a different schema in SQLPLUS. I do have all permissions on the schema.
Upvotes: 6
Views: 5083
Reputation: 11936
try:
ALTER SESSION SET CURRENT_SCHEMA = different_schema
Upvotes: 9