Re: Tablespace creation problems.

Have you created the tablespace 'MYTABLESPACE' yet? The tablespace needs to exist before you can use it. Look up the CREATE TABLESPACE command. Do not create any user objects in the system tablespace. That is a bad practice.

HTH,
Patrick

In article <38CD4CC9.9A5C39F0_at_yahoo.com>,   jghione99_at_yahoo.com wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 13 2000 - 00:00:00 CST