Database oracle [duplicate]

Question

How can i know the list of tables created in each DB using Oracle ? I want to delete the unnecessary ones.

tables created with their names Could you clarify this part? — default locale
– default locale, Commented Jan 21, 2015 at 3:41
Can you re frame the question so that it can be understood better.? — Venkata Krishna
– Venkata Krishna, Commented Jan 21, 2015 at 3:49

Community · Accepted Answer · 2017-05-23 11:45:00Z

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

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Jan 21, 2015 at 3:43

Navik Hiralal

7871 gold badge6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Misunderstood · Accepted Answer · 2015-01-21 03:43:59Z

0

SHOW TABLES  IN `db`;

Where db is the name of your database.

answered Jan 21, 2015 at 3:43

Misunderstood

5,6791 gold badge20 silver badges25 bronze badges

Collectives™ on Stack Overflow

Database oracle [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related