Oracle创建表空间和用户

=============================================================================

create temporary tablespace C##FH_TEMP  

tempfile 'D:\Project\oracleTableSpace\FH\C##FH_TEMP.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

create tablespace C##FH_DATA

logging  

datafile 'D:\Project\OracleTableSpace\FH\C##FH_DATA.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

create user C##FH identified by root

default tablespace C##FH_DATA

temporary tablespace C##FH_TEMP;  

grant connect,resource,dba to C##FH; 

=====================================================================