i want to view all the constraints on a table, the space a table occupies how do i do it
1. select * from user_constraints where table_name = 'MYTABLE' 2. select bytes,blocks from user_segments where segment_name = 'MYTABLE'; Hope this helps Gert
THANKS. IT HELPED.
Forum Rules