Menu
When I query ALL_TAB_COLUMNS in Oracle, I see tables called
BIN$frKctA83wMPgQEOSh0Az+A==$0 BIN$frKctA8cwMPgQEOSh0Az+A==$0 BIN$frQ1pdU2TgXgQEOSh0APxA==$0 BIN$frQ1pdVGTgXgQEOSh0APxA==$0 There is no corresponding entry in ALL_TABLES. What are those?
214
A table is the basic unit of data organization in an Oracle database. A table describes an entity, which is something of significance about which information must be recorded.
DBA_TABLES describes all relational tables in the database. Its columns are the same as those in ALL_TABLES . To gather statistics for this view, use the ANALYZE SQL statement. Scripting on this page enhances content navigation, but does not change the content in any way.
to get list of tables. and Run this: SELECT Count(*) FROM DBA_TABLES; to get the count of tables.
Oracle Database provides information about all of the tables, views, columns, and procedures in a database. This information about information is known as metadata. It is stored in two locations: data dictionary tables (accessed via built-in views) and a metadata registry.
Since version 10g, dropped tables (also dropped objects in general) are put in the recycle bin and can be restored easily. The names you see are tables in the recycle bin.
You can bypass the recycle bin by adding the PURGE keyword in your DROP statements.
You will find additional information in the Administrator's Guide Documentation.
91
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
