Oracle 使用命令行创建新账户

进入cmd：

--以sys账户进入

sqlplus sys/admin as sysdba;

--创建表空间
create temporary tablespace SMS_Temp
tempfile 'E:\oracle\product\10.2.0\oradata\orcl\SMS_Temp.dbf' size 20M
autoextend on;

create tablespace SMS_Data
datafile 'E:\oracle\product\10.2.0\oradata\orcl\SMS_Data.dbf' size 20M
autoextend on;

  
   ---创建用户
CREATE USER SMS IDENTIFIED BY admin
DEFAULT TABLESPACE SMS_DATA
TEMPORARY TABLESPACE SMS_TEMP;

-- ROLES
GRANT "RESOURCE" TO SMS ;
GRANT "CONNECT" TO SMS ;
GRANT "DBA" TO SMS ;

-- SYSTEM PRIVILEGES

-- QUOTAS
ALTER USER SMS QUOTA UNLIMITED ON SMS_DATA;

-- USER SQL
ALTER USER SMS
DEFAULT TABLESPACE SMS_DATA
TEMPORARY TABLESPACE SMS_TEMP
ACCOUNT UNLOCK ;

-- ROLES
ALTER USER SMS DEFAULT ROLE "RESOURCE","CONNECT","DBA";

-- SYSTEM PRIVILEGES
REVOKE UNLIMITED TABLESPACE FROM SMS;

-- QUOTAS
ALTER USER SMS QUOTA UNLIMITED ON SMS_DATA;