Oracle创建用户、表空间

创建oracle表空间，复制以下内容用sys用户在sql窗口执行

CREATE TABLESPACE oracle DATAFILE  '/u02/oradata/oracle/oracle01.dbf' SIZE 10000M AUTOEXTEND ON NEXT 10M MAXSIZE  32000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256k SEGMENT SPACE MANAGEMENT  AUTO;  

创建的表空间大小为10000M ​ AUTOEXTEND ON 自动扩展，每次扩展10M NEXT 10M ​ 最大32G MAXSIZE 32000M。单个dbf文件最大也就能支持到32G ​ 当数据增多时候，一个dbf文件不够，就需要增加dbf文件个数。

alter TABLESPACE oracle add DATAFILE  '/u02/oradata/oracle/oracle02.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE  32000M;  

创建oracle用户并赋权

CREATE USER ORACLE IDENTIFIED BY oracle  DEFAULT TABLESPACE ORACLE TEMPORARY TABLESPACE TEMP; GRANT CONNECT TO ORACLE;  
GRANT RESOURCE TO ORACLE;
GRANT UNLIMITED TABLESPACE TO ORACLE;
GRANT DBA TO ORACLE;
GRANT create any table to ORACLE;
grant drop any table to oracle;
grant select on DEPENDENCY$ to oracle; 
grant select on V_$INSTANCE to oracle;  
grant select on V_$LOCKED_OBJECT to  oracle; 
grant select on V_$SESSION to oracle; 
grant administer database trigger to  oracle; 
grant EXECUTE on DBMS_SHARED_POOL to  oracle;