Toad World® Forums

How to include a default schema for all the tables in a sql script


#1

How to include a default schema for all the tables in a sql script

Example, Oracle is providing scripts and in that tables are there without schema and those scripts can be executed only in apps login without including any schema.

If i want execute the same scripts under my login, i need to add apps (apps.oe_order_headers_all) in front of all the tables…

its difficult to add apps if script contains many tables. So is there any way to add apps in a one shot for all the tables or how can i execute scripts without manually add apps using my user login. Please help me