创建表空间
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;
