Re: CREATE/DROP/ALTER hangs...

On Dec 7, 11:52 am, gazzag <gar..._at_jamms.org> wrote:
> 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

The above returns 0 rows.

Looking at the alert file; seems a run on with what appears to be memory address:

[.....snip]
Fri Dec 7 05:19:50 2007
Beginning log switch checkpoint up to RBA [0x3a794.2.10], SCN: 0x0001.0216f9b4
Thread 1 advanced to log sequence 239508   Current log# 3 seq# 239508 mem# 0: /space/XXXXXX/datafiles/ redo03.log
Fri Dec 7 05:20:10 2007
Completed checkpoint up to RBA [0x3a794.2.10], SCN: 0x0001.0216f9b4 Fri Dec 7 05:20:35 2007
Beginning log switch checkpoint up to RBA [0x3a795.2.10], SCN: 0x0001.0216fc10
Thread 1 advanced to log sequence 239509   Current log# 1 seq# 239509 mem# 0: /space/XXXXXX/datafiles/ redo01.log
Fri Dec 7 05:20:56 2007
Completed checkpoint up to RBA [0x3a795.2.10], SCN: 0x0001.0216fc10 Received on Fri Dec 07 2007 - 11:10:47 CST