Re: How do I create a table on a specific tablespace?

From: <lrako_at_my-deja.com>
Date: Thu, 26 Oct 2000 12:41:54 GMT
Message-ID: <8t98qh$b8o$1@nnrp1.deja.com>

Hi,

Try this.

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)
TABLESPACE REPORT_DATA; USING clause is used with INDEX TABLESPACE.

Note also the reformatting of the statement which is easier to read.

Regards,

Lalaina RAKOTONIAINA
CRM Consultant
Complete Business Solutions Inc.

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 26 2000 - 07:41:54 CDT