Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Execute a .sql file(having CTAS) in the Unix environment

curious_mindNov 19 2020 — edited Nov 19 2020

Hi All,
I have my requirement where i have to executed the attached block(.sql file) having CTAS into it from my KSH file. my script will get fail in production because in production the user which is executing this script will not have "create table" privilege.
CTAS.txt (8.9 KB)also in the attached script, it is picking up some partition codes dynamically(called CD_VAL_VARCHAR2 in the attached script) so considering this also please suggest how to get my requirement fulfilled.

Thanks in advance.

This post has been answered by Hemendra.Singh on Nov 21 2020

Jump to Answer

Added on Nov 19 2020

#general-database-discussions

4 comments

445 views