Oracle Create TableSpace SQL
–创建表空间 www.2cto.com
CREATE TABLESPACE TableSpaceName
NOLOGGING
DATAFILE 'path/tablespacename.dbf' SIZE 20M
autoExtend on next 10M
permanent online;
–创建用户 www.2cto.com
CREATE USER username IDENTIFIED BY password DEFAULT TABLESPACE TsinghuaLMS ACCOUNT UNLOCK;
–授权
GRANT oracle账号"CONNECT" TO username;
GRANT "RESOURCE" TO username;
GRANT "DBA" TO username;