1.
select * from user_constraints where table_name = 'MYTABLE'
2.
select bytes,blocks from user_segments where segment_name = 'MYTABLE';
Hope this helps
Gert
|
Results 1 to 3 of 3
Thread: desc constraints of a tableThreaded View
|
Click Here to Expand Forum to Full Width |