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
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
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
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
:
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
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,
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
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
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
fsys.comcc:
Sent by: Subject: RE: Cannot Drop Column
:
Sent by: Subject: RE: Cannot Drop Column
[EMAIL PROTECTED]
om
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
RROGERS@galot To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
tery.orgcc:
Sent by: Subject: 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
13 matches
Mail list logo