How to find an Oracle table by a known value in it?

Question

Oracle

I know some value that should be stored somewhere in the database (it definitely exists in the database because there is an interface through which I see this value).
I do not know the table in which it is stored. I want to know.
I have WebLogik which shows me this value. (therefore traceback in tags)

Answer 1

usually in such situations, requests from the weblogic look at the oracle side at the moment when it shows you the value. oracle has a web administrka, there you can see all the requests that arrive at the database. I prefer toad for oracle, it also shows what each session is doing.

Answer 2

If the sizes of the database and tables allow, you can, in the most primitive form, completely select each table, spool it into a text file and look for a value there, grep or find, as it is more convenient. You can run such a search at night.
Even the schema name is not known?