Re: Tablespace creation problems.

<jghione99_at_yahoo.com> wrote in message news:38CD4CC9.9A5C39F0_at_yahoo.com...
> I am learning Oracle 8. I am practicing SQL command within SQLPlus.
>
> It is my own NT server and I have all rights and privileges in both NT
> and Oracle.
> I am using the default starter database that came with the install. In
> other words
> I just did a fresh install and never setup another instance or database.
>
> My problem is when I executed the command:
> create table MYTABLE ... tablespace MYTABLESPACE
> (I edited out the field definitions).
>
> I get the error "MYTABLESAPCE does not exist."
>
> However I can create tables if I do not specify a tablesapce. I assume
> when I do that the new tables are added to the system tablespace.
>
> The book I am using seems to indicate that I should be able to execute
> the above command. I tried this logged on as SYSTEM as well as
> a user with DBA privlegages.
>
> If anyone can help I would very much appreciate it.
>
> thx
>

If you don't specify a tablespace the table goes to the users default tablespace.
You can verify that by select default_tablespace from user_users; In a starter database there's no tablespace mytablespace, user_data should exist.
to create a tablespace use
create tablespace <name>
default storage (initial <bytes> next <bytes>) datafile '<any filename>'

Hth,

Sybrand Bakker, oracle dba Received on Mon Mar 13 2000 - 00:00:00 CST