Oracle建立表空间和用户

原文链接点击此处

完整例子：

--表空间CREATE TABLESPACE sdtDATAFILE 'F:\tablespace\demo' size 800M         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; --索引表空间CREATE TABLESPACE sdt_IndexDATAFILE 'F:\tablespace\demo' size 512M                  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;     --2.建用户create user demo identified by demo default tablespace demo; --3.赋权grant connect,resource to demo;grant create any sequence to demo;grant create any table to demo;grant delete any table to demo;grant insert any table to demo;grant select any table to demo;grant unlimited tablespace to demo;grant execute any procedure to demo;grant update any table to demo;grant create any view to demo;