Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Oracle database (11g2). But i don't know how to find a text in all of table on a database. Because there are so many tables, can't find down by one column, one table... it takes me a lot of times. Is there any way to do this ? Or any tools, software can help me to do this ? Please help me! Thank in advance.

share|improve this question
1…; but your real problem is apparent lack of documentation. Your time would be better spend documenting your schema than going on wild goose chases that might turn up nothing. – Mat Dec 9 '12 at 14:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.