Re: Create indexes in specific tablespace
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: malcolmarnold@xxxxxxxxx
- Date: Thu, 10 Nov 2005 10:53:06 +0000
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@xxxxxxxxx> 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:
>
Other related posts:
