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 -> How do I create a table on a specific tablespace?

How do I create a table on a specific tablespace?

From: TimeVest Inc. <reb_at_shell5.ba.best.com>
Date: 25 Oct 2000 19:08:55 -0700
Message-ID: <4l4s208ibs.fsf@shell5.ba.best.com>

I'm trying to create a table on a specific tablespace but I don't seem to have the right syntax.

I tried:

CREATE TABLE TESTDATA.NG_ANA_CUSTOMID_C (STARTDATE DATE, ADID NUMBER, ADSIZEID NUMBER, FLIGHTID NUMBER, FLIGHTTARGETID NUMBER, SITEVALUEID NUMBER, IMPRESSIONS NUMBER, CLICKS NUMBER, EVENTTYPE NUMBER, EVENTCOUNT NUMBER, CENTERID NUMBER, CHANNELID NUMBER) using REPORT_DATA; and got this error

CENTERID NUMBER, CHANNELID NUMBER) using REPORT_DATA

                    *

ERROR at line 4:
ORA-00922: missing or invalid option Received on Wed Oct 25 2000 - 21:08:55 CDT

Original text of this message

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