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..
Received on Fri Dec 07 2007 - 14:14:30 CST
