Oracle创建表空间和用户命令

create temporary tablespace TABDEV_TEMP_TABS tempfile 'D:\app\MrY\oradata\orcl\TABDEV_TEMP_TABS.DBF' size 50m autoextend on next 50m maxsize 2048m extent management local;

create tablespace TABDEV_TABS logging datafile 'D:\app\MrY\oradata\orcl\TABDEV_TABS.DBF' size 50m autoextend on next 50m maxsize 2048m extent management local;

create user user identified by pwd default tablespace TABDEV_TABS temporary tablespace TABDEV_TEMP_TABS ;

grant connect,resource,dba to uesr;