Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing after dropping columns.
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 - 02:25:47 CDT
![]() |
![]() |