select * from all_tables where owner not in ('SYS','SYSTEM')
select * from all_tab_columns a where a.owner in ('用户一','用户二'....)
如果是这样,就用 select * from all_tables a where a.owner='username'
先根据select * from all_users; 找到系统用户创建的最大时间(一般是oracle安装的日期) 然后 select * from all_tables where owner not in (select username from all_users where created>to_date(....));
select * from all_tables a where a.owner='username'
select * from all_tables a where a.owner=upper('username');
同意bzszp(www.bzszp.533.net) 但应该是in不是not in吧?select * from all_tables where owner in (select username from all_users where created>to_date(oracle create date));
同意xhy818(zh1860 应该是in不是not in吧?select * from all_tables where owner in (select username from all_users where created>to_date(oracle create date));
select * from all_tables a where a.owner='username'
找到系统用户创建的最大时间(一般是oracle安装的日期)
然后
select * from all_tables where owner not in
(select username from all_users
where created>to_date(....));
但应该是in不是not in吧?select * from all_tables where owner in
(select username from all_users
where created>to_date(oracle create date));
应该是in不是not in吧?select * from all_tables where owner in
(select username from all_users
where created>to_date(oracle create date));