Re: Stupid Newbie Q.

Your problem has nothing to do with the syntax of your create table statement.

The problem is that the user creating the table has a default tablespace of USERS but there is not enough room in USERS to create the table.

To solve the problem, you need to either add a datafile to the users tablespace or reduce the size of the initial extent in the default storage parameters set for the tablespace.

Also make sure that the user has adequate resource privelages to that tablespace.

Robert Buda

In article <352C5FC8.410C_at_faceng.anu.edu.au>,   hugo <hugo_at_faceng.anu.edu.au> wrote:
>
> Hi there,
> I am new user to Oracle. While trying to create a table
> I got the following error message...
>
> SQL> create table temp as select name,one,three,four from blah;
> create table temp as select name,one,three,four from blah
> *
> ERROR at line 1:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> USERS
>
> What am I doing wrong?
>
> Thanks,
> Hugo
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 09 1998 - 12:51:20 CDT