How to select tablespace name with table name in oracle?

To select tablespace name which is containing specific table name in Oracle,

SELECT * FROM all_tables WHERE table_name LIKE 'ORDER%'

Above query searches for the table name which starts with “ORDER”

Django-Python Web based application developer.

Share This Post

Related Articles

Leave a Reply

© 2018 Techy Diary. All rights reserved.
Powered by Charvi Groups