Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing after dropping columns.

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@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 - 02:25:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US