Paul,

I am a total Oracle novice.
However I was experiencing a similar problem to yourself.

Perhaps the responses submitted already have answered your question but I will just add a short comment.

What I think was happenning to you was:

The DTS Package you were using was creating a table in the following format "PAUL"."TABLENAME".

Therefore a table was being created but you could only access it if you said something like 'select * from "TABLENAME"' or 'describe "TABLENAME"' . Select * from TABLENAME would return your error .

From my experience of using the DTS Wizard , if you change the name of the Oracle destination table to simply TABLENAME , with no double quotes you can then access it.

Now there may be a need to call it PAUL.TABLENAME or something but then I wouldn't know about that as I am an Oracle novice.

DD