New answers tagged oracle-11g
You can also avoid the tnsnames.ora file by using the EZ Connect method. sqlplus firstname.lastname@example.org:1524/<service name goes here> You can get your service name by running lsnrctl status command.
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 ...
That could be caused by unindexed foreign keys. Tom Kyte has a query that you can use to find them. It could be as simple as adding a few indexes on the child tables. Unindexed Foreign Keys
Top 50 recent answers are included