How can i know the total no of tables created with their names!!!in SQL oracle Commands ?? So that i can drop the unnecessary tables......
Asked
Active
Viewed 224 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
- 697
- 1
- 6
- 17
