Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace creation problems.

Re: Tablespace creation problems.

From: Alan Formstone <aformstone_at_us.lhsgroup.com>
Date: 2000/03/13
Message-ID: <38cd58dc@news.lhsgroup.com>#1/1

You need to first create the tablespace. When you don't specify it the table is created in the default tablespace for your user. In this case undoubtedly SYSTEM Check the create tablespace command

HTH Alan

>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."
>
Received on Mon Mar 13 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US