ORACLE 10G创建表空间和创建用户

 1、创建表空间
CREATE TABLESPACE mytablespace DATAFILE   
  'F:\oracle\product\10.2.0\oradata\myoracle\MYTABLESPACE01.DBF' SIZE 500M AUTOEXTEND ON NEXT
100M MAXSIZE UNLIMITED  
LOGGING  
PERMANENT  
EXTENT MANAGEMENT LOCAL AUTOALLOCATE  
BLOCKSIZE 8K  
SEGMENT SPACE MANAGEMENT MANUAL  
FLASHBACK ON;
2、创建用户
CREATE USER ECC_NOTE IDENTIFIED BY sys
PROFILE DEFAULT
DEFAULT TABLESPACE mytablespace
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;
GRANT UNDER ANY TABLE TO ECC_NOTE WITH ADMIN OPTION;  
 
GRANT UNDER ANY TYPE TO ECC_NOTE WITH ADMIN OPTION;  
 
GRANT UNDER ANY VIEW TO ECC_NOTE WITH ADMIN OPTION;  
 
 
GRANT "DBA" TO ECC_NOTE WITH ADMIN OPTION;  
GRANT "OLAP_DBA" TO ECC_NOTE WITH ADMIN OPTION;  
GRANT "OLAP_USER" TO ECC_NOTE WITH ADMIN OPTION;  
GRANT "SELECT_CATALOG_ROLE" TO ECC_NOTE WITH ADMIN OPTION;  
ALTER USER ECC_NOTE DEFAULT ROLE "DBA", "OLAP_DBA", "OLAP_USER", "SELECT_CATALOG_ROLE";  
 
ALTER USER test QUOTA UNLIMITED ON ECC_NOTE;