DTS Delete an Oracle Table
I have a DTS package which creates an Oracle Table and then populates it - no problem.
What I want to do is each time I run the DTS package is to drop it using the DROP TABLE <TABLENAME>. This command is failing in the DTS package, but it works from SQL*plus, under the same username/password. DELETE FROM <TABLENAME> also fails???
Any help appreciated