Re: Tablespace creation problems.

jghione99_at_yahoo.com writes:

> 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."

The tablespace needs to be created before : CREATE TABLESPACE mytablespace DATAFILE 'full path to the datafile' SIZE 50M;
>
> 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.

They are created in the user's default 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
>
 

-- 
The fundamental aim of King Crimson is to organize anarchy, to utilize
   the latent power of chaos and to allow the varying influences to
	       interact and find their own equilibrium.
                                        -Robert Fripp