Oracle 10g创建表空间和创建用户命令

9p2m7to9im

　　创建表空间 

CREATE TABLESPACE test DATAFILE
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\TEST1.DBF' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
　　
 
　　
　　创建用户

CREATE USER test IDENTIFIED BY "test"
DEFAULT TABLESPACE "TEST"
TEMPORARY TABLESPACE "TEMP"
PROFILE DEFAULT
QUOTA UNLIMITED ON "TEST";
GRANT UNDER ANY TABLE TO test WITH ADMIN OPTION;
GRANT UNDER ANY TYPE TO test WITH ADMIN OPTION;
GRANT UNDER ANY VIEW TO test WITH ADMIN OPTION;

GRANT "DBA" TO test WITH ADMIN OPTION;
GRANT "OLAP_DBA" TO test WITH ADMIN OPTION;
GRANT "OLAP_USER" TO test WITH ADMIN OPTION;
GRANT "SELECT_CATALOG_ROLE" TO test WITH ADMIN OPTION;
ALTER USER test DEFAULT ROLE "DBA", "OLAP_DBA", "OLAP_USER", "SELECT_CATALOG_ROLE";
ALTER USER test QUOTA UNLIMITED ON TEST;