Re: Importing after dropping columns.
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Thu, 11 Apr 2002 07:25:47 GMT
Message-ID: <%Tat8.275433$q2.33411_at_sccrnsc01>
Date: Thu, 11 Apr 2002 07:25:47 GMT
Message-ID: <%Tat8.275433$q2.33411_at_sccrnsc01>
Not directly. You would have to import into a different schema then do an
insert into table as select x,y from newschema.table
Jim
"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 - 09:25:47 CEST