CREATE SMALLFILE TABLESPACE mytest DATAFILE 'd:\oracle\product\10.2.0\oradata\orcl10\mytest.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE USER mytest IDENTIFIED BY mytest DEFAULT TABLESPACE mytest TEMPORARY TABLESPACE TEMP;
GRANT CONNECT,DBA,RESOURCE TO mytest;
commit
oracle 创建表空间/用户名/授权
最新推荐文章于 2021-04-04 01:17:12 发布