--創建臨時表空間
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';