| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
Sent: Friday, December 07, 2001 4:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Cannot Drop Column
Ron,
You should read the whole thread. ;)
Jared
"Ron Rogers"
<RROGERS_at_galot To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
tery.org> cc:
Sent by: Subject: RE: Cannot Drop Column
root_at_fatcity.c
om
12/07/01 12:05
PM
Please respond
to ORACLE-L
Oracle 8i
ALTER TABLE name DROP COLUMN name;
ROR mô¿ôm
>>> Jared.Still_at_radisys.com 12/07/01 02:25PM >>>
Ken,
Just add the column with the correct name, and leave the other one alone.
You could create a check constraint to make sure it isn't used.
Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea.
As you've already discovered, it really isn't all that convenient. ;)
Jared
Ken Janusz
<ken.janusz_at_su To: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
fsys.com> cc:
Sent by: Subject: RE: Cannot Drop
Column
root_at_fatcity.c
om
12/07/01 09:50
AM
Please respond
to ORACLE-L
Dave:
I am working on a database to do a DB conversion from IMS to 8.1.7. It is
only being used to load the data for the conversion process. No
application
software will be connected to it. So, for convenience I am doing
everything
as SYS. I am the only person using this DB on a dedicated W2000 server. I
accidentally added this column by the wrong name, so I want to delete the
column so I can add the column with the correct name. I would change the
name of the column but I have not found any syntax to do this.
Thanks,
Ken
-----Original Message-----
Sent: Friday, December 07, 2001 11:36 AM To: Multiple recipients of list ORACLE-L
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 you're in is currently in use by virtue of the fact you're logged in as SYS.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Ken Janusz
<ken.janusz_at_su To: Multiple recipients of
list
ORACLE-L <ORACLE-L_at_fatcity.com>
fsys.com> cc:
Sent by: Subject: Cannot Drop Column
root_at_fatcity.c
om
12/07/2001
10:05 AM
Please respond
to ORACLE-L
8.1.7 logged in as SYS.
Will not let me drop a column because it belongs to SYS.
If I am logged in as SYS why can't I drop a column owned by SYS?
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: ken.janusz_at_sufsys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: DBarbour_at_austin.isd.tenet.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: ken.janusz_at_sufsys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Dec 07 2001 - 16:28:19 CST
 |
 |