Beside the fact that you can do all what you want with exp/imp (if TS quotas for importing user are set correctly), if you want to stick with your CTAS script, change your where clause from "... WHERE EMPCODE=0" withs something like "... WHERE 1 = 2". This will create table, but will not load any data in it since the where condition will never evaluate to TRUE.