Re: Importing after dropping columns.

"Yash R. Ganthe" <yash_ganthe_at_hotmail.com> wrote in message news:<a93a9k$23c$1_at_news.vsnl.net.in>...
> Hi,
> I had a table Tab[X,Y,Z]. I exported the table using the export utility,
> into a dmp file. A few days later I had to drop column Y from the table. Can
> I now import the dmp file into my table, given that only columns X and Z
> remain in it?
>
> Thanks.

import generates insert into values statement based upon data in the export. Now answer your question yourself. The answer is obvious.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Apr 11 2002 - 12:01:25 CEST