Bro
Bro

Reputation: 61

Execute sql script in a different schema

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

Answers (1)

Kevin Burton
Kevin Burton

Reputation: 11936

try:

ALTER SESSION SET CURRENT_SCHEMA = different_schema

Upvotes: 9

Related Questions