Re: cannot create table

From: D.Y. <dyou98_at_aol.com>
Date: 13 Aug 2002 12:37:11 -0700
Message-ID: <f369a0eb.0208131137.60249c26@posting.google.com>

"zeb" <thierry.constant1_at_free.fr> wrote in message news:<3d580e20$0$10494$626a54ce_at_news.free.fr>...
> Hi,
>
> When I am system/manager
> I can't create any table
>
> SQL> create table toto ( no integer );
>
> no return
> freeze, nothing happens
> nothing in the alert log
>
> Nevertheless the database seems to work ...
>

I wouldn't say the database seems to work if you can't even create tables. The first thing to check is whether your archive log directory is full, or whether your archiver is running.

>
> Any ideas ????
>
> HP-UX 11.0
> Oracle 8.1.7 Archivelog
Received on Tue Aug 13 2002 - 14:37:11 CDT