Oracle创建表空间以和用户语句
程序员文章站
2022-06-23 16:23:09
记录一下常用的语句,便于以后使用…
create tablespace tablespacename
datafile 'e:\data\oracledata\xxx.dbf&...
记录一下常用的语句,便于以后使用…
create tablespace tablespacename
datafile 'e:\data\oracledata\xxx.dbf' size 200m
autoextend on next 100m maxsize unlimited logging
extent management local autoallocate
segment space management auto;
create user username identified by password default tablespace tablespacename temporary tablespace temp;
grant connect,resource,dba to username ;