Oracle常用命令集
1. 查询数据库中有几个表空间:
select tablespace_name from dba_tablespaces;
select distinct tablespace_name from tabs;
select count(distinct tablespace_name) from tabs;
查询所有用户:
select username from dba_users;
创建用户并为其指定表空间:
create user user_test identified by user_test default tablespace ts_test ;
为某一用户指定表空间: