not only that, after droping old table u must rename new table to original
name.
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



novice_dba
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
5.com> cc:
Subject: RE: simple way to drop numerous columns in a
01/30/2004 11:53 single step ??
AM






hi,

i will prefer to creat new table inserting the values into new
from old, scrapping old one..


good luck...


"Bhat, Vikas" <Vikas.[Email Address Removed] I think u can club all the columns in one alter like this.....
Not sure
> though....
>
> ALTER TABLE george_trx
> Drop (
GLOBAL_ATTRIBUTE1,GLOBAL_ATTRIBUTE2,GLOBAL_ATTRIBUTE3.......);
>
>
> Warm regards,
> Vikas Bhat
>
> -------------------------------------------------------
> Fidelity Investments Systems Company
> Embassy Golf Links Business Park,
> Off Intermediate Ring Road,
> Bangalore 560071
> Phone: +91 80 5691 6422
> Email: Vikas.[Email Address Removed] ------------------------------------------------------
>
>
> -----Original Message-----
> From: Lewycky, George [mailto:[Email Address Removed] Sent: Thursday, January 29, 2004 10:58 AM
> To: LazyDBA.com Discussion
> Subject: simple way to drop numerous columns in a single step ??
>
>
>
> 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] To subscribe: send a blank email to oracledba-
[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> 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] To subscribe: send a blank email to oracledba-
[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>



==================================================================
Good Judgement Comes from Experience, Experiences Comes From Bad
Judgement
==================================================================

--------
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