thanks ramon,
your last suggestion worked, though i dont see how it is different from others i have been trying.
Anyway i am up with another problem and
the error now says "for INSERT option, table must be empty. error on table scott.dept"
I guess i need to go through the documentation more thoroughly.
manjunath