Re: What does this error message mean?

Don't bother answering this. I've already figured out what it was. I had another process with a connection to the server which had a lock on that table. Silly me, I guess. Sorry to waste your time.

• John

In article <jhess.940222202029_at_eng.auburn.edu> jhess_at_eng.auburn.edu (John M. Hess) writes:
>
>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,
>
>- John
Received on Wed Feb 23 1994 - 05:17:20 CET