how to know in schema a table belongs ?
Hi ,
i need some help on oracle DB.
i have oracle 8i DB .
i use TOAD 7.0.56 version to connect to the DB and do operation on it.
I have many schema in my database .
I am looking for a table called "Mission" .
I dont know in which schema it belongs .
is it possible to know in which schema this table belongs ?
N.B : i have checked 3-4 schema to find the table manually . but as there are so many schemas , its difficult to carry on this process .
is there any query / some tricks which could tell me the schema name where this table could belongs ?
thank you