Reduce the No. of Fields in a Oracle Table
From: Vir Madhu <madhu2_at_ix.netcom.com>
Date: 1995/07/25
Message-ID: <3v1te0$52u_at_ixnews3.ix.netcom.com>#1/1
Date: 1995/07/25
Message-ID: <3v1te0$52u_at_ixnews3.ix.netcom.com>#1/1
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