use dbms_ddl package

see help for that if u hav access to docs.

Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



"Lewycky, George"
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
> cc:
Subject: simple way to drop numerous columns in a single
01/29/2004 09:28 step ??
PM







Hi everyone,

I copied a table structure and unfortunately I have
many columns I dont need.

I cant do each alter/drop seperately (see below), is there
a simpler technique to delete columns (wildcard, etc??)

Any Ideas

thanks

George
--------------------------------------------

alter table george_trx
drop column GLOBAL_ATTRIBUTE1;
alter table george_trx
drop column GLOBAL_ATTRIBUTE2;
alter table george_trx
drop column GLOBAL_ATTRIBUTE3;
alter table george_trx
drop column GLOBAL_ATTRIBUTE4;
alter table george_trx
drop column GLOBAL_ATTRIBUTE5;
alter table george_trx
drop column GLOBAL_ATTRIBUTE6;
alter table george_trx
drop column GLOBAL_ATTRIBUTE7;
alter table george_trx
drop column GLOBAL_ATTRIBUTE8;
alter table george_trx
drop column GLOBAL_ATTRIBUTE9;
alter table george_trx
drop column GLOBAL_ATTRIBUTE10;
alter table george_trx
drop column GLOBAL_ATTRIBUTE11;
alter table george_trx
drop column GLOBAL_ATTRIBUTE12;
alter table george_trx
drop column GLOBAL_ATTRIBUTE13;
alter table george_trx
drop column GLOBAL_ATTRIBUTE14;
alter table george_trx
drop column GLOBAL_ATTRIBUTE15;
alter table george_trx
drop column GLOBAL_ATTRIBUTE16;
alter table george_trx
drop column GLOBAL_ATTRIBUTE17;
alter table george_trx
drop column GLOBAL_ATTRIBUTE18;
alter table george_trx
drop column GLOBAL_ATTRIBUTE19;
/

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:
http://www.lazydba.com/legal.html






Oracle LazyDBA home page