[Oracle] LINUX下Oracle数据库用户创建方法详解

SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF
E:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF
E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF
E:\APP\ADMINISTRATOR\ORADATA\ORCL\EXAMPLE01.DBF
5 rows selected

SQL> select status,fuzzy,tablespace_name,name from v$datafile_header;
STATUS FUZZY TABLESPACE_NAME    NAME
------- ----- ------------------------------ --------------------------------------------------------------------------------
ONLINE YES  SYSTEM       E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
ONLINE YES  SYSAUX       E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF
ONLINE YES  UNDOTBS1      E:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF
ONLINE YES  USERS       E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF
ONLINE YES  EXAMPLE      E:\APP\ADMINISTRATOR\ORADATA\ORCL\EXAMPLE01.DBF
5 rows selected

CREATE TABLESPACE test datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\testNS.dbf'
size 600M autoextend on next 50m maxsize unlimited;

CREATE USER testUser IDENTIFIED BY abc DEFAULT TABLESPACE test;

grant connect,resource,dba to testUser;