Export utility can be used, to determine if there is a table level corruption.
exp system/manager TABLES='<table_name>' log=tbl_chk.log file=test.dmp
But we may have space constraint, when table is very large & we don’t have enough space to export that table. In this case, we can use ‘/dev/null’ as a output file. It will not create a physical file, but will read through the table
exp system/manager TABLES='<table_name>' log=tbl_chk.log file=/dev/null volsize=100g
NOTE: volsize defines the output file size. In this case it’s as good as unlimited.
Export logfile will have more details on corruption. Oracle support will be able to analyse the logfile & provide with the action plan.