--建立名为ph_pro的profile，如果已存在不需要再次建立create profile ph_pro limitsessions_per_user unlimitedcpu_per_session unlimitedcpu_per_call unlimitedconnect_time unlimitedidle_time 60logical_reads_per_session unlimitedlogical_reads_per_call unlimitedprivate_sga unlimitedcomposite_limit unlimited; --建立表空间CREATE tablespace publichealth_data DATAFILE 'E:oracle_table_spacepublichealthpublichealth_data.dbs' SIZE 100M DEFAULT STORAGE( INITIAL 409600 NEXT 51200 MINEXTENTS 1 MAXEXTENTS unlimited PCTINCREASE 1 )ONLINE;--建立临时表空间CREATE TEMPORARY TABLESPACE publichealth_data_tmpTEMPFILE 'E:oracle_table_spacepublichealthpublichealth_data_tmp.dbs' SIZE 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; --建立用户create user publichealth identified by publichealth default tablespace publichealth_data temporary tablespace publichealth_data_tmp quota unlimited on publichealth_data quota 10M on systemprofile ph_pro;--修改用户角色alter user publichealth default role all;--为用户授权grant connect,resource to publichealth;