Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cannot create table

Re: cannot create table

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 12 Aug 2002 23:23:44 GMT
Message-ID: <3D58437F.446E8A4B@exesolutions.com>


zeb wrote:

> 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

Good thing too.

Because you have no business creating any table or other object as SYSTEM. My first idea is to have someone responsible take the system password away from you. My second idea is for you to get a schema somewhere else to make your messes.

I hope that I have displayed sufficient irritation to let you know that if you were in my class you would fail. And if you were on a consulting project with me you'd be summarily dismissed.

Daniel Morgan Received on Mon Aug 12 2002 - 18:23:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US