today1858的专栏

--表空间drop tablespace ICD_BILLLOG1 including contentscreate tablespace icd_servicedatafile 'F:/oracle/tablespace/rdata10' size 500M reuse,  'F:/oracle/tablespace/rdata14' size 500M reuse  LOGGING  ONLINE  PERMANENT  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M/-

<br />DROP TABLE TBILLLOG1 CASCADE CONSTRAINTS<br />CREATE TABLE TBILLLOG1<br />(<br />  PARTID NUMBER(2) ,<br />  CALLID VARCHAR2(25) NOT NULL,<br />  CALLIDNUM NUMBER(4),   <br />  CALLBEGIN DATE,   <br />  CALLEND DATE NOT NULL ,   <br />  UVID NUMBER(1

<br />DROP INDEX indBillLog1_CallEnd<br />CREATE INDEX indBillLog1_CallEnd<br />ON tBillLog1 (CallEnd)<br />  TABLESPACE ICD_BILLLOG_IND LOCAL  <br />  PCTFREE 10<br />  INITRANS 2<br />  MAXTRANS 255<br />  STORAGE (<br />  INITIAL 128k<br />  NEXT 128k<b