User_tables structure : USER_TABLES « System Tables Views « Oracle PL / SQL

Oracle PL / SQL
1. Aggregate Functions
2. Analytical Functions
3. Char Functions
4. Constraints
5. Conversion Functions
6. Cursor
7. Data Type
8. Date Timezone
9. Hierarchical Query
10. Index
11. Insert Delete Update
12. Large Objects
13. Numeric Math Functions
14. Object Oriented Database
15. PL SQL
16. Regular Expressions
17. Report Column Page
18. Result Set
19. Select Query
20. Sequence
21. SQL Plus
22. Stored Procedure Function
23. Subquery
24. System Packages
25. System Tables Views
26. Table
27. Table Joins
28. Trigger
29. User Previliege
30. View
31. XML
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Oracle PL / SQL » System Tables Views » USER_TABLES 
User_tables structure
 

SQL>
SQL> describe user_tables;
 Name                                                                                                  Null?    Type
 ----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------

 TABLE_NAME                                                                                            NOT NULL VARCHAR2(30)
 TABLESPACE_NAME                                                                                        VARCHAR2(30)
 CLUSTER_NAME                                                                                           VARCHAR2(30)
 IOT_NAME                                                                                               VARCHAR2(30)
 STATUS                                                                                                 VARCHAR2(8)
 PCT_FREE                                                                                               NUMBER
 PCT_USED                                                                                               NUMBER
 INI_TRANS                                                                                              NUMBER
 MAX_TRANS                                                                                              NUMBER
 INITIAL_EXTENT                                                                                         NUMBER
 NEXT_EXTENT                                                                                            NUMBER
 MIN_EXTENTS                                                                                            NUMBER
 MAX_EXTENTS                                                                                            NUMBER
 PCT_INCREASE                                                                                           NUMBER
 FREELISTS                                                                                              NUMBER
 FREELIST_GROUPS                                                                                        NUMBER
 LOGGING                                                                                                VARCHAR2(3)
 BACKED_UP                                                                                              VARCHAR2(1)
 NUM_ROWS                                                                                               NUMBER
 BLOCKS                                                                                                 NUMBER
 EMPTY_BLOCKS                                                                                           NUMBER
 AVG_SPACE                                                                                              NUMBER
 CHAIN_CNT                                                                                              NUMBER
 AVG_ROW_LEN                                                                                            NUMBER
 AVG_SPACE_FREELIST_BLOCKS                                                                              NUMBER
 NUM_FREELIST_BLOCKS                                                                                    NUMBER
 DEGREE                                                                                                 VARCHAR2(10)
 INSTANCES                                                                                              VARCHAR2(10)
 CACHE                                                                                                  VARCHAR2(5)
 TABLE_LOCK                                                                                             VARCHAR2(8)
 SAMPLE_SIZE                                                                                            NUMBER
 LAST_ANALYZED                                                                                          DATE
 PARTITIONED                                                                                            VARCHAR2(3)
 IOT_TYPE                                                                                               VARCHAR2(12)
 TEMPORARY                                                                                              VARCHAR2(1)
 SECONDARY                                                                                              VARCHAR2(1)
 NESTED                                                                                                 VARCHAR2(3)
 BUFFER_POOL                                                                                            VARCHAR2(7)
 ROW_MOVEMENT                                                                                           VARCHAR2(8)
 GLOBAL_STATS                                                                                           VARCHAR2(3)
 USER_STATS                                                                                             VARCHAR2(3)
 DURATION                                                                                               VARCHAR2(15)
 SKIP_CORRUPT                                                                                           VARCHAR2(8)
 MONITORING                                                                                             VARCHAR2(3)
 CLUSTER_OWNER                                                                                          VARCHAR2(30)
 DEPENDENCIES                                                                                           VARCHAR2(8)
 COMPRESSION                                                                                            VARCHAR2(8)
 DROPPED                                                                                                VARCHAR2(3)

SQL>
SQL> select table_name, tablespace_name
  2        from user_tables
  3        where rownum < 10
  4       order by table_name;

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
CCOL$                          SYSTEM
CDEF$                          SYSTEM
CON$                           SYSTEM
FET$                           SYSTEM
FILE$                          SYSTEM
PROXY_DATA$                    SYSTEM
PROXY_ROLE_DATA$               SYSTEM
TS$                            SYSTEM
UNDO$                          SYSTEM

rows selected.

SQL>
SQL>
SQL>

           
         
  
Related examples in the same category
1. query table_name, tablespace_name from user_tables
2. Query a table in user_table by table_name
3. Query user_tables for the table just created
4. To get a listing of all tables that you own
5. Get table name and table space for a table by its name
6. alter table emp move tablespace users and then check the result by querying user_tables
7. Create sql statements from user_tables
8. Verify the creation of the statistics by running the following queries:
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.