no you dont
CREATE TABLE access_level(
access_level NUMBER(1, 0) NOT NULL,
access_level_desc VARCHAR2(100),
status NUMBER(1, 0),
CONSTRAINT pk_access_level PRIMARY KEY (access_level)
USING INDEX
TABLESPACE xxx
)
TABLESPACE yyy
;
On 11/10/05, malcolm arnold <malcolmarnold_at_gmail.com> wrote:
>
> > How can I amend the following to ensure any idexes are created in a
> > tablespaced called INDEXES, rather than the default tablespace?
>
> You have to create the table, then add the primary key in separate DDLs:
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 10 2005 - 04:55:36 CST
