Hot answers tagged oracle-11g
I don't know a 'legal' way to find out the tables visible in the ALL_TABLES view of another user, so I do some reengineering of the SYS.ALL_TABLES dictionary view and found the following expression in the where clause: and (o.owner# = userenv('SCHEMAID') or o.obj# in (select oa.obj# from sys.objauth$ oa where grantee# in ...
Try this... select owner,table_name,grantable from dba_tab_privs where grantee = 'SCOTT' and privilege = 'SELECT'; Change SCOTT to the user you are interested in.
As said earlier you will have to move all the 200+ tables in that tablespace to free up some space in your datafile and then resize to reclaim the space. But instead of running all those queries, 12c Enterprise manager does this task. You will have to navigate to Database Home > Storage > Tablespace. Select the tablespace you want to work on and click ...
Only top voted, non community-wiki answers of a minimum length are eligible