Re: cannot create table

Don't have 8i here in front of me but what you did should work.

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option
JServer Release 9.0.1.1.1 - Production

Input truncated to 15 characters
SQL> create table toto (no integer);

Table created.

SQL> drop table toto;

Table dropped.

Since the password is still manager, I assume this is a small play database. Did you create the database manually? Run all the Oracle supplied scripts afterwards - catalog, catproc etc. Can you create any tables as system? System have the roles you'd expect i.e. DBA role?

"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 ...
>
>
> Any ideas ????
>
> HP-UX 11.0
> Oracle 8.1.7 Archivelog
>
>
Received on Mon Aug 12 2002 - 18:53:48 CDT