Informix to Oracle conversion - Fragmentation

 Hi

 

I taken across the following table from Informix:

create table "informix".sec_lev_ovr 

  (

    secure_code char(6) not null ,

    waybill_no integer,

    logname char(20),

    date_created date,

    time_created datetime hour to minute

  ) 

  fragment by round robin in roundrobdbs_001 , roundrobdbs_002 , roundrobdbs_003 

    , roundrobdbs_004 , roundrobdbs_005 , roundrobdbs_006 , roundrobdbs_007 

    , roundrobdbs_008 , roundrobdbs_009 , roundrobdbs_010  

  extent size 10000 next size 1000 lock mode row;

 

From what I could read,  “by hash” will be the same as the Round Robin option Informix has, so here is my table on Oracle:

CREATE TABLE SLE.SEC_LEV_OVR

(

  SECURE_CODE   CHAR(6 BYTE)                    NOT NULL,

  WAYBILL_NO    INTEGER,

  LOGNAME       CHAR(20 BYTE),

  DATE_CREATED  DATE,