export CLOB data in flat file from oracle 8i
I am in a bad situation. The oracle system crashed and i am trying to retrieve from backup. The backup was hot online backup and for some reason didnt happen correctly. Only thing remaining is DBF and redo log. I somehow managed to recreated the control files. But i cannot login to oracle using sqlplus using any user. Only thing that works is server manager and connect as internal. Now i need to retrieve data from tables having CLOB data to a flat file.
using oracle 8.1.