Trying to export data from a table to .dat file in a unix script using the SPOOL command.
However on execution only ~17k data is exported to file out of 91K data with an error in end of the file : ORA-08103 Object do not exist, though the objects exists in the database.
When I tried to export the data in csv, it exported only ~11k data with same error in the file. Exporting almost ~35 columns from the table.
spool ${DataDirectory}/output.dat;
select * from < Table_name >;
What could be the reason for not exporting complete data set and throwing a error even if object exist?
Attached is the screenshot of the script.