ORACLE创建表空间,用户并赋予权限

select * from dba_users where default_tablespace='OracleLearning';

select * from dba_directories;

CREATE TABLESPACE OracleLearning

         LOGGING

         DATAFILE 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\OracleLearning.DBF'

         SIZE 1024m

         AUTOEXTEND ON

         NEXT 32M MAXSIZE UNLIMITED

         EXTENT MANAGEMENT LOCAL;

         

  create user OracleLearning   identified by LQL850034044 default tablespace OracleLearning;       

grant dba,connect,resource to OracleLearning;