sql模板！

1、create USER filemanager
  identified by filemanager
  default tablespace Bizfocus_dmp
  temporary tablespace TEMP
  profile DEFAULT;
grant connect to filemanager;
grant resource to filemanager;

grant unlimited tablespace to filemanager;

2、create table FILEMANAGER.HHTY_SMSS
(
ID NUMBER(10) not null,
RECEIVE_MAN VARCHAR2(20),
RECEIVE_MOBILE VARCHAR2(20),
SMS_CONTENTS VARCHAR2(500),
STATUS NUMBER(1) default 0 not null,
CREATE_TIME DATE default sysdate not null,
SNED_TIME DATE
)