CODEWITHSUNDEEP
oracle-database
kk luo
kk luo

Reputation: 599

query user_tables and result is empty

I use select * from user_tables to check tables. And the result is empty. Is this because my username don't have authority to check this table or I didn't log as sysdba which I don't have authority?

Upvotes: 0

Views: 753

Answers (1)

Popeye
Popeye

Reputation: 35900

It means that you have not created any table yet in your schema.

User_tables view shows the tables which is owned by your user.

Following query shows the same result as user_tables view.

Select * from all_tables
Where owner = 'your_user';

Or

Select * from DBA_tables
Where owner = 'your_user';

Upvotes: 1

Related Questions