Re: Importing after dropping columns.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 11 Apr 2002 03:01:25 -0700
Message-ID: <a20d28ee.0204110201.8940420@posting.google.com>

"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 - 05:01:25 CDT