首先是:
知道表的名字:可以通过查询DBA_OBJECTS 视图找到对应属于的用户,然后再查询dba_users视图表
select * from dba_objects tt where tt.object_name='VIEWT';
OWNER VIEWTOO
OBJECT_NAME VIEWT
SUBOBJECT_NAME
OBJECT_ID 52514
DATA_OBJECT_ID 52514
OBJECT_TYPE TABLE
CREATED 2010/7/5 11:33:31
LAST_DDL_TIME 2010/7/7 16:51:10
TIMESTAMP 2010-07-07:16:44:20
STATUS VALID
TEMPORARY N
GENERATED N
SECONDARY N
select username,default_tablespace from dba_users where username='VIEWTOO';
USERNAME VIEWTOO
DEFAULT_TABLESPACE USERS
(
select * from dba_users kk where kk.username in (
select gg.owner from dba_objects gg
where gg.object_name='EPG_ASSET_BASE')
)
这样就查出了某个表对应的用户以及对应的默认表空间
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15713890/viewspace-667504/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15713890/viewspace-667504/