result.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."LIMIT_VLR_IDX" ON "DYT"."LIMIT_VLR" ("LOCAL_CITY_ID
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE INDEX "DYT"."MSGSTAT_STIME_IDX" ON "DYT"."MSGSTAT" ("STIME")           
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "USERS"                                                            
 ;                                                                              
                                                                                
                                                                                
  CREATE INDEX "DYT"."NO_IDX" ON "DYT"."NO" ("TYPE")                            
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 2424832 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645       
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."OPERATEUSER_NAME" ON "DYT"."OPERATEUSER" ("NAME")  
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE INDEX "DYT"."STAT_CITY_IDX" ON "DYT"."STAT" ("CITY", "VLRCITY")        
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003019" ON "DYT"."ARGS" ("ID")                
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003020" ON "DYT"."IP" ("ID")                  
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003021" ON "DYT"."LANGUAGE" ("ID")            
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "USERS"                                                            
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003022" ON "DYT"."MSG" ("ID")                 
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003023" ON "DYT"."NO" ("ID")                  
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 3604480 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645       
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003024" ON "DYT"."NOTKNOWNO" ("ID")           
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003025" ON "DYT"."NOTKNOWVLR" ("ID")          
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003026" ON "DYT"."NOTSENDMSG" ("MSISDN")      
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003027" ON "DYT"."OPERATEUSER" ("ID")         
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003028" ON "DYT"."PROVINCE" ("ID")            
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003029" ON "DYT"."STATUS" ("STIME")           
  PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING                                  
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003030" ON "DYT"."USERINF" ("ID")             
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003031" ON "DYT"."VLR" ("ID")                 
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003032" ON "DYT"."WEATHER" ("CITYCODE")       
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "SYSTEM"                                                           
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003034" ON "DYT"."WLANGUAGE" ("COUNTRY_ID")   
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "USERS"                                                            
 ;                                                                              
                                                                                
                                                                                
  CREATE UNIQUE INDEX "DYT"."SYS_C003035" ON "DYT"."TEST_MSISDN" ("MSISDN")     
  PCTFREE 10 INITRANS 2 MAXTRANS 255                                            
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645         
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)              
  TABLESPACE "USERS"                                                            
 ;