I have a simple, empty table which is described as follows:
SQL>describe mod_test
Name Null? Type
------------------------------- -------- ----
COL1 NOT NULL CHAR(1)
COLUMN2 DATE
WHO NUMBER(4)
So now I try to add an attribute to it with the following:
SQL>alter table mod_test add john char(25);
And I get the following error message:
*
ERROR at line 1:
ORA-00058: timeout occurred while waiting for DDL lock
I have no idea what this means. Am I totally clueless or should that "alter
table" command work? Email to "jhess_at_eng.auburn.edu" is preferred, but
posting to this newsgroup is fine too.
P.S.: One of the columns was defined as the primary key as a table
constraint and I don't get any errors when I try this on a similar empty
table with no primary key defined. Why would the primary key cause this
problem?
Thanks,
