oracle创建表空间和账户
创建表空间:
|
1 2 3 4 5 6 7 8 |
Sql代码 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; |
创建账户:
|
1 2 3 4 5 6 7 8 9 10 11 |
Sql代码 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"; |
