| 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
Apologies if this has already been mentioned. You will need a (free) technet account to access these links. Hope these links didn't wrap.
HTH....
Oracle8i Administrator's Guide
Release 2 (8.1.6)
Part Number A76956-01
"You cannot drop all columns from a table, nor can you drop columns from a table owned by SYS. Any attempt to do so will result in an error. "
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76956/tables.htm#1451
Use your browser to search for the string: "You cannot drop"
Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a85397/statem2a.htm#2055873
Use your browser to search the string: "a table owned by SYS"
__ _ ================================= -o)/ / (_)__ __ ____ __ | Ed Sherman | /\\ /__/ / _ \/ // /\ \/ / | Oracle Certified Professional |_\_v __/_/_//_/\_,_/ /_/\_\ | ECC International Corporation |
| Tel: (407) 859-7410 x2708 | =================================Supporter of the coalition for grumpiness where grumpiness is due
-----Original Message-----
Sent: Monday, December 10, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L
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 to ?
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
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: Nikunj Gupta INET: good_dba_at_hotmail.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: 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: shermanej_at_eccic.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 Mon Dec 10 2001 - 18:37:26 CST
 |
 |