ORA-12988: cannot drop column
I have created a DB as SYS and added columns to some of the tables as SYS. When I try to drop some of these columns I get this error. ORA-12988: cannot drop column from table owned by SYS How can I get around this problem? Thanks, 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: ORA-12988: cannot drop column
Ken, This subject was discussed at some length in the past week or two. If I remember correctly the only way and approved method is the ignore the columns and recreate the tables as the proper owner. ROR mª¿ªm [EMAIL PROTECTED] 12/20/01 02:15PM I have created a DB as SYS and added columns to some of the tables as SYS. When I try to drop some of these columns I get this error. ORA-12988: cannot drop column from table owned by SYS How can I get around this problem? Thanks, 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: ORA-12988: cannot drop column
Error: ORA-12988 Text: cannot drop column from table owned by SYS --- Cause: An attempt was made to drop a column from a system table. Action: This action is not allowed The solution seems to be 'do not create objects as sys'. Drop the tables and create them as another user. Jared Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: ORA-12988: cannot drop column [EMAIL PROTECTED] om 12/20/01 11:15 AM Please respond to ORACLE-L I have created a DB as SYS and added columns to some of the tables as SYS. When I try to drop some of these columns I get this error. ORA-12988: cannot drop column from table owned by SYS How can I get around this problem? Thanks, 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Cannot Drop Column
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 to ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: Cannot Drop Column
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 ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
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 ? Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY
RE: Cannot Drop Column
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 PROTECTED] 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: [EMAIL PROTECTED] (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).
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 of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City Network
Cannot Drop Column
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Cannot Drop Column
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 ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 08: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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Cannot Drop Column
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 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Cannot Drop Column
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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
RE: Cannot Drop Column
Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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
RE: Cannot Drop Column
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 name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City
RE: Cannot Drop Column
Ron, You should read the whole thread. ;) Jared Ron Rogers RROGERS@galot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tery.orgcc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 12:05 PM Please respond to ORACLE-L Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
RE: Cannot Drop Column
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 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cannot Drop Column Ron, You should read the whole thread. ;) Jared Ron Rogers RROGERS@galot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tery.org cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 12:05 PM Please respond to ORACLE-L Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.com cc: 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 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@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.com cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet