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

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Wed, 25 Oct 2000 22:29:10 -0500
Message-ID: <svf8ve1bt99s0c@corp.supernews.com>

Get a SQL book and read it, it will help.

The syntax is CREATE TABLE owner.table_name (column_name datatype,...) TABLESPACE tablespace_name;

--
Dave A


"TimeVest Inc." <reb_at_shell5.ba.best.com> wrote in message
news:4l4s208ibs.fsf_at_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 - 22:29:10 CDT