查看用户数据存放地点
SQL> select * from dba_users where username='TEST' ;
建表
SQL> create table test tablespace users as select * from dba_objects ;
Table created.
SQL>
查询用户下面的表
SQL>select * from user_tables ;
删除表(不进回收站)
SQL> drop table test purge ;
Table dropped.
SQL>