Re: Importing after dropping columns.

Hi,

you could try:

alter table tab add y char(??);
imp file=file.dmp log=file.log ignore=y full=y select count(*) from tab;
alter table tab drop column y;

Violin.
violin.hsiao_at_mail.pochen.com.tw

"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.
Received on Thu Apr 11 2002 - 12:05:31 CEST