Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How do I create a table on a specific tablespace?
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