使用DBA用户登录创建
--查询表空间物理路径
select * from v$datafile;
--创建表空间
CREATE TABLESPACE tablesplacename DATAFILE 'D:\dmdbms\data\DAMENG\tablesplacename .dbf' SIZE 10240;
--创建用户
CREATE USER username IDENTIFIED BY usernameusername DEFAULT TABLESPACE tablesplacename temporary tablespace TEMP ;
--授权 dba权限
GRANT DBA TO username ;
注:一般创建
----------------------------------------------------------------------------------------------------------------------------
SYSDBA:CREATE USER USERNAME;--创建用户
SYSSSO:ALTER USER IDENTIFIED BY PASSWORD;--密码
SYSSSO:ALTER USER DEFAULT TABLESPACE TABLESPACENAME;--表空间
注:权限分离