I have a table name but I am not sure in which schema that table exists. How to find the schema name?
Advertisement
Answer
Select owner from dba_tables where table_name = 'YOUR_TABLE_NAME'
Here you can find something more.
I have a table name but I am not sure in which schema that table exists. How to find the schema name?
Select owner from dba_tables where table_name = 'YOUR_TABLE_NAME'
Here you can find something more.