I am using oracle enterprise stage for loading the table.
Write method is 'Load'.
write mode is 'Truncate'.
And target table has no index.
In our dev environment and testing its running fine.
But when we put this code in different environment its giving below abort message.
Code: Select all
Indexes on table 'TMP_T' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.
do i need to change some environment variables?