We are creating a table using CTAS from a remote DB. We are using CTAS due to performance issues with INSERT-SELECT.
EXECUTE IMMEDIATE 'CREATE TABLE ods_idl_vst NOLOGGING AS SELECT * FROM remote_tab@remote_db vst';
How can I pevent 'ora-01723 zero-length columns are not allowed" error? Our DB is 11g.