Oracle: show indexes status

1	select index_name, status from all_indexes where status != 'VALID';

OSX 10.8: Connect to Windows 8 host on LAN