DBA_TABLES
DBA_TABLES displays all tables in the database. This view is accessible only to users with system administrator rights.
Name |
Type |
Description |
---|---|---|
owner |
character varying(64) |
Table owner |
table_name |
character varying(64) |
Table name |
tablespace_name |
character varying(64) |
Name of the tablespace that contains the table |
status |
character varying(8) |
Whether the current record is valid |
temporary |
character(1) |
Whether the table is a temporary table
|
dropped |
character varying |
Whether the current record is deleted
|
num_rows |
numeric |
The estimated number of rows in the table |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot