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;