oracle - How do you query for blank schemas? -
I am trying to find an empty schema within my oracle server.
I One way to query for a list of empty schemas DBA_TAB_COLS , but not success. Example: Choose TABLE_COUNT from DBA_TAB_COLS group (OBNER, COUNT (separate (TABLE_NAME)) by OWNER
If "blank schema" is a schema, there is no table
Choose from Username dba_users where u is not present (selection 1 to dba_tables t where t.owner = u.username); If you want to search for schema, Not even an object, which is a key of the schema If you do not have an ebay, you want to use dba_objects in the subquery instead of dba_tables . For any of these, however, you have dba _ * Obligations will be required to query objects.
Comments
Post a Comment