Re: Reduce the No. of Fields in a Oracle Table
Date: 1995/07/25
Message-ID: <3v2v8p$5mm_at_xenon.brooks.af.mil>#1/1
If it suits your need, you may want to try the following construct:
CREATE TABLE mynewtable as
SELECT field1, field2, field3...field80
FROM myoldtable;
This will give you a new table with just the fields you want, but I may be
over-simplifying the problem...
Hope this helps (or gives you other ideas),
Richard Wark
madhu2_at_ix.netcom.com (Vir Madhu ) wrote:
Computer Sciences Corporation warkr_at_vanadium.brooks.af.mil
Brooks AFB, San Antonio TEXAS
http://www.txdirect.net:80/users/rwark/
>We are re_writing a Oracle application and as a part of that, I have
>to reduce no. of fields in the table( consisting of 85 fields ) by
>eliminating 5 fields. I am writing a program in Pro*C that reads all
>but those 5 fields and insert into a new table i.e., the new table will
>have 80 fields. There are 1 million records in this table. I am new to
>oracle application development and wondering if there is a Standard
>Oracle Tool that does this. Any pointers from the knowledgeable netters
>will be highly appreciated.
>Thank you
>Madhu.
Received on Tue Jul 25 1995 - 00:00:00 CEST