PL/SQL (MOSC)

MOSC Banner

HOW to create local PK index using PARALLEL

edited Nov 25, 2017 4:00AM in PL/SQL (MOSC) 1 commentAnswered

where  "PARALLEL 8 NOLOGGINGshould  be wroten?

alter table TD.VEH_UPLOAD_LOC

  add constraint PK_VEH_UPLOAD_LOC primary key (VEH_UPLOAD_LOC_ID, CREATED_TIMSTM)

  local

  tablespace TD_IDX_P001

  pctfree 10

  initrans 100

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  )

PARALLEL 8 NOLOGGING;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center