Forum Stats

  • 3,872,668 Users
  • 2,266,452 Discussions
  • 7,911,278 Comments

Discussions

Hi,I can see the Table name and Tablespace name in My Oracle Database,but i am not able to see the T

Mickel John
Mickel John Member Posts: 56
edited Mar 28, 2017 9:34AM in MySQL Community Space

Hi,I can see the Table name and Tablespace name in My Oracle Database,but i am not able to see the Table metadata??

pastedImage_0.png\

Whenever i tried to get the table metadata, it shows like this,

pastedImage_2.png

How can I check the metadata????

Please help me,

Thank you.

Best Answer

  • Barbara Boehmer
    Barbara Boehmer Member Posts: 4,625 Gold Trophy
    edited Mar 28, 2017 1:21AM Answer ✓

    Since you are using an Oracle database, not a MySQL database, this question should have been posted in the SQL and PL/SQL forum space:

    SQL and PL/SQL

    Try:

    select table_name from user_tables;

    or try:

    select owner, table_name from all_tables;

    You may find that you are not the owner of the table and do not have select privileges.

Answers