创建表空间:
创建账户:
CREATE TABLESPACE test_tablespace DATAFILE 'test_tablespace' SIZE 10M AUTOEXTEND ON NEXT 1M 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_TABLESPACE"
TEMPORARY TABLESPACE "TEMP"
PROFILE DEFAULT
QUOTA UNLIMITED ON "TEST_TABLESPACE";
GRANT "CONNECT" TO test;
GRANT "DBA" TO test;
GRANT "RESOURCE" TO test;
ALTER USER test DEFAULT ROLE "CONNECT", "DBA", "RESOURCE";