| ron |
Posted: Jan 15, 2007 12:43:35 PM |
Total Post: 9
Joined: Nov, 2006
|
i have connected as
connect abc/abc as sysdba
then created a table without any constarints. now, when i try to drop a column, i get the message
ORA-12988:cannot drop column from table owned by SYS
how should i create a table so that i can drop a column from it? |
|
|
 Jayanta |
| Posted: Jan 15, 2007 01:18:33 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
hope the user name abc does not have dba privilege. and the table u have created is own by user sys(a dba). that is user abc lack drop any table privilege.
login as connect abc/abc
then create a table of ur choice in abc schema
and then do whatever u want with the table.
hope this will help
with regards
jayanta
|
|
|
|
|
| ron |
| Posted: Jan 16, 2007 05:04:42 AM | |
|
Total Post: 9
Joined: Nov, 2006
|
|
|
|
|
| Jayanta |
| Posted: Jan 16, 2007 06:32:59 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
then u plz create a user with create user statement and then try to do the same thing.
with regards
jayanta
|
|
|
|
|
| maddy |
| Posted: Jan 17, 2007 12:04:34 AM | |
|
Total Post: 18
Joined: Aug, 2006
|
connect as sys
create a non system tablespace
after creating a non system tablespace
assign non system tablespace as default tablespace to user abc
and also grant quota 0 on system to user abc
and also assign quota unlimited on non system tablespace to user abc...
your problem will be solved....
|
|
|
|
|
| RAM SAHU |
| Posted: Jan 22, 2007 03:33:16 PM | |
|
Total Post: 1
Joined: Jan, 2007
|
logon as abc/abc
use below command
alter table table_name
drop column col_name;
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
