RE: Cannot Drop Column

2001-12-10 Thread Ken Janusz
Is this in a DBA table? If so, which one? Thanks, Ken -Original Message- Sent: Sunday, December 09, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set

RE: Cannot Drop Column

2001-12-10 Thread Ken Janusz
I checked compatible in init.ora and it is set to 8.1.0. Ken -Original Message- Sent: Sunday, December 09, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set

RE: Cannot Drop Column

2001-12-10 Thread Sherman, Edward
PM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Did you check COMPATIBLE ? What is it set to ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients

RE: Cannot Drop Column

2001-12-10 Thread Herman Cungadibrata
Ken, maybe you have an constraint to that column. if yes you could drop it first. rgds, cung ASTRA CREDIT COMPANIES http://www.autocybercenter.com/ ; Automotive Solution Provider -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Cungadibrata INET: [EMAIL

Re: Cannot Drop Column

2001-12-09 Thread Nikunj Gupta
: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do

Re: Cannot Drop Column

2001-12-07 Thread Jared . Still
Ken, I think the more important question is Why are you trying to drop a column in a table owned by Sys? Jared Ken Janusz

Re: Cannot Drop Column

2001-12-07 Thread DBarbour
Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table

RE: Cannot Drop Column

2001-12-07 Thread Ken Janusz
11:36 AM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables

RE: Cannot Drop Column

2001-12-07 Thread Jared . Still
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: RE: Cannot Drop Column

RE: Cannot Drop Column

2001-12-07 Thread Ron Rogers
: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om

RE: Cannot Drop Column

2001-12-07 Thread Ken Janusz
Ron: This doesn't work. I'm just ignoring the column and adding the correctly named column. Ken -Original Message- Sent: Friday, December 07, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject:RE: Cannot Drop Column Oracle 8i ALTER TABLE name DROP COLUMN

RE: Cannot Drop Column

2001-12-07 Thread Jared . Still
RROGERS@galot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tery.orgcc: Sent by: Subject: RE: Cannot Drop Column

RE: Cannot Drop Column

2001-12-07 Thread Godlewski, Melissa
Title: RE: Cannot Drop Column Why not create newtable as select columns wanted from oldtable, then add your column. Drop old table rename new table to old table if desired. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 4:00