CODEWITHSUNDEEP
sqloracle-databaseoracle11goracle11gr2
Adeel ASIF
Adeel ASIF

Reputation: 3524

Select oracle schema which only contains specific table

I'm looking for a way to select all schema on my oracle server, which only contain the table "mytable"

How can i do this ?

I already have a query who list all schema in my database.

SELECT username FROM all_users;

Thank you !

Upvotes: 1

Views: 345

Answers (1)

Adriano Carneiro
Adriano Carneiro

Reputation: 58595

You can look this up on the all_tables system table:

select distinct owner
from all_tables
where table_name = 'mytable'

Upvotes: 3

Related Questions