Home -> Usenet -> comp.databases.oracle -> ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified

ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified

From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/09/20
Message-ID: <32429d03.5250115_at_n5.gbso.net>#1/1 







Why would the following statement give me an "ORA-12812: only one
PARALLEL or NOPARALLEL clause may be specified" error?



create snapshot master_claim


  parallel (degree 2)


  tablespace mhp 


  storage (initial 20m next 5m pctincrease 0) pctfree 0
  using index 


  tablespace mhpx 


  storage (initial 3m next 3m pctincrease 0) pctfree 0
  as select * from mhp.master_claim_at_mast_drd where rownum <= 100000
/

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!


Received on Fri Sep 20 1996 - 00:00:00 CEST












Original text of this message