--创建临时表空间
create temporary tablespace eos_temp tempfile 'D:\oracle\product\10.2.0\oradata\orcl\eos_temp.dbf' size 10m autoextend on next 10m maxsize unlimited extent management local;
--创建数据表空间
create tablespace eos_space logging datafile 'D:\oracle\product\10.2.0\oradata\orcl\eos_data.dbf' size 20m autoextend on next 20m maxsize unlimited extent management local;
--创建用户并指定表空间
create user eos identified by eos default tablespace eos_space temporary tablespace eos_temp;
--给用户授予权限
grant connect,resource,dba to eos;
--连接用户或用户登录
conn eos/eos;
--查询该用户名中的表
select table_name from user_tables where user='eos';