Re: Granting CREATE ALL TABLES to a user

First of all: either you misread something, or you really need to throw that book in a shredder (and you'd rather read Oracle docu) 1 create all table doesn't even exist
2 if you are getting the error table already exists, you can be sure this is true. Try describe <table_name> in sql*plus 3 You need to end any statement either with a semicolon (;) or a slash (/) in sql*plus.
If you do that you will get a different error message: create all tables doesn't exist, it should be create any table. Please read any docu carefully.

Be also aware Oracle Lite is a completely different beast from Oracle, it has been severly stripped down. You should rather get hold of Personal Oracle.

Regards,

Sybrand Bakker, Oracle DBA

Thomas Løvlie <thomasl_at_c2i.net> schreef in berichtnieuws TapJ4.4133$r6.447039_at_juliett.dax.net...
> The company I work for has decided to change from Solid DB to Oracle8 so I
> have downloaded Oracle8i Lite to test and learn a little, but already I
 have
> a couple of questions.
>
> So please help me out here.
>
> The first problem I encountered was when I tried to create some tables. I
> use ODBC to write the SQL (I have also tried using SQL+) but I keep
 getting
> the error 'table already exists'. I read in a book I bought that the error
> comes when a user is not granted the CREATE ALL TABLES right. But I
 connect
> to the database using SYSTEM/MANAGER and I thought that user had the
 rights
> to create tables.
>
> The second problem came when I tried to create a user, First I created a
> user 'Thomas' and I tried to use SQL+ to grant the rights, I wrote 'GRANT
> CREATE ALL TABLES TO THOMAS' but when I pressed ENTER I keep getting a
 next
> line starting with '2:'. I also tried writing 'EXECUTE' first but nothing
> helps.
>
> So please help me out here.
>
> Thanks in advance
>
> Thomas Løvlie
> thomasl_at_c2i.net
> Delphi Developer for Digitalteknikk AS
>
>
Received on Thu Apr 13 2000 - 00:00:00 CDT