Re: CREATE/DROP/ALTER hangs...

On Dec 7, 3:14 pm, Ben <benal..._at_yahoo.com> wrote:
> On Dec 7, 2:38 pm, "tocallag..._at_gmail.com" <tocallag..._at_gmail.com>
> wrote:
>
>
>
> > On Dec 7, 1:49 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
> > > On Dec 7, 11:18 am, "tocallag..._at_gmail.com" <tocallag..._at_gmail.com>
> > > wrote:
>
> > > > 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- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > You should, if at all possible, patch this antiquated beast to
> > > 8.1.7.4; you're running an unpatched release of Oracle and it's likely
> > > this is known problem and corrected in the aforementioned patch set.
>
> > > Also, all we know is it's on Linux; different distributions and
> > > releases behave, well, differently. Which distribution, what release
> > > of Linux? Such information could answer a number of questions.
>
> > Hopefully this helps:
>
> > Red Hat Linux Advanced Server release 2.1AS (Pensacola)
> > 2.4.9-e.24smp #1 SMP
> > i686 unknown
>
> > I assure you I'm not trying to be withholding to screw with you. I'm
> > very honestly at my wits end with this business. However I do
> > appreciate your help, so thank you.
>
> > D- Hide quoted text -
>
> > - Show quoted text -
>
> post the exact statement that you are trying to execute to create the
> object as well. just a thought..

CREATE TABLE FULFILLMENTS (TEST1 varchar2(1));

To be honest I'm out of ideas. I'm going to take Davids advice and get into the millennium and install Oracles Database Express Edition and see if that makes a difference. Received on Fri Dec 07 2007 - 14:51:55 CST