Re: CREATE/DROP/ALTER hangs...

From: gazzag <gareth_at_jamms.org>
Date: Fri, 7 Dec 2007 08:52:24 -0800 (PST)
Message-ID: <d39b4515-58c8-432d-a46f-4367dd71571a@d21g2000prf.googlegroups.com>

On 7 Dec, 16:46, "tocallag..._at_gmail.com" <tocallag..._at_gmail.com> wrote:
> Hello,
>
> I've stumbled on something curious (or at least curious to me). I'm
> trying to create a table by the name of 'FULFILLMENTS' (Oracle 8.1.7)
> but when I do it just seems to hang. I can successfully create any
> other table using any other name but when i attempt to create
> 'FULFILLMENTS' nadda. Even trying to 'DROP/ALTER TABLE FULFILLMENTS'
> the results are the same.
>
> I've checked to see if it could be a conflict in naming (select * from
> tab) but there aren't any views/procs or tables remotely close to that
> name.
>
> At its simplest, I'm stuck. Any thoughts would be appreciated.

Have you checked the alert log? Are there any trace files in background_dump_dest?

Have you tried:

SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
FROM DBA_OBJECTS
WHERE OBJECT_NAME='FULFILLMENTS' ; HTH -g Received on Fri Dec 07 2007 - 10:52:24 CST