i want to view all the constraints on a table,
the space a table occupies
how do i do it
Printable View
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.