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
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
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
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 c
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
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
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 sen
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
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
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 sen
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
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
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
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" 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 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 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 F
RE: Cannot Drop Column
Ron,
You should read the whole thread. ;)
Jared
"Ron Rogers"
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
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
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 s
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
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
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-- (8
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
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
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
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 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 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
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 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).
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 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).
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 fsys.com>cc: 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).
