sysdba身份登录
sqlplus sys/***密码* as sysdba;
查看所有用户默认表空间
select username,default_tablespace from dba_users;
查看当前用户所有的表名和视图
select * from tab;
查看当前用户所有的表
select table_name from user_tables;
查看所有用户的表名
select table_name from all_tables;
sqlplus sys/***密码* as sysdba;
select username,default_tablespace from dba_users;
select * from tab;
select table_name from user_tables;
select table_name from all_tables;