equal
deleted
inserted
replaced
42 / |
42 / |
43 |
43 |
44 Database info. |
44 Database info. |
45 ============== |
45 ============== |
46 |
46 |
|
47 List of users:: |
|
48 |
|
49 select distinct(OWNER) from ALL_TABLES; |
|
50 |
47 List of current user owned tables:: |
51 List of current user owned tables:: |
48 |
52 |
49 select * from USER_TABLES; |
53 select * from USER_TABLES; |
|
54 select TABLE_NAME from USER_TABLES; |
|
55 |
|
56 List of tables by owner:: |
|
57 |
|
58 select OWNER || '.' || TABLE_NAME from ALL_TABLES |
|
59 order by OWNER; |
50 |
60 |
51 List of current user table sizes:: |
61 List of current user table sizes:: |
52 |
62 |
53 select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS |
63 select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS |
54 group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES); |
64 group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES); |
63 |
73 |
64 select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes |
74 select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes |
65 left outer join user_extents on user_extents.segment_name = table_name |
75 left outer join user_extents on user_extents.segment_name = table_name |
66 group by index_name, table_name |
76 group by index_name, table_name |
67 order by table_name; |
77 order by table_name; |
|
78 |
|
79 List of tables without primary keys:: |
|
80 |
|
81 select OWNER || '.' || TABLE_NAME from ALL_TABLES |
|
82 where TABLE_NAME not in ( |
|
83 select distinct TABLE_NAME from ALL_CONSTRAINTS where CONSTRAINT_TYPE = 'P' |
|
84 ) and OWNER in ('USER1', 'USER2') |
|
85 order by OWNER, TABLE_NAME; |
68 |
86 |
69 List of currenct user constraints:: |
87 List of currenct user constraints:: |
70 |
88 |
71 select * from USER_CONSTRAINTS; |
89 select * from USER_CONSTRAINTS; |
72 |
90 |