How can i know the list of tables created in each DB using Oracle ? I want to delete the unnecessary ones.
Asked
Active
Viewed 245 times
-3
-
`tables created with their names` Could you clarify this part? – default locale Jan 21 '15 at 03:41
-
Ask it nicely. `Show tables` perhaps... – Jan 21 '15 at 03:43
-
Can you re frame the question so that it can be understood better.? – Venkata Krishna Jan 21 '15 at 03:49
2 Answers
0
This question/answer should give you the details you need: Get list of all tables in Oracle?
but in summary...
-- If you have access
SELECT owner, table_name
FROM dba_tables
-- Will show what your user has access to
SELECT owner, table_name
FROM all_tables
Community
- 1
- 1
Navik Hiralal
- 757
- 1
- 6
- 17
