Re: CREATE/DROP/ALTER hangs...

On Dec 7, 12:02 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Dec 7, 10:46 am, "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.
>
> 8.1.7 doesn't say much except that you're woefully behind the most
> current of releases; 8.1.7 hasn't been supported in this century.

*laugh - 100% aware of this fact. I'm sorry to report that upgrading isn't an option.
I've just been charged with the crusade to 'fix it'. I'm also sorry to report that I'm
clearly not an Oracle DBA, but enough of my short comings ;)

> That being said which release (all four numbers) are you using, on
> which operating system?

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for Linux: Version 8.1.7.0.0 - Development NLSRTL Version 3.4.1.0.0 - Production Received on Fri Dec 07 2007 - 11:18:57 CST