-
export CLOB data in flat file from oracle 8i
hi,
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.
Any suggestions?
using oracle 8.1.
-
Hi
In case you are unable to bring back your database online then depending upon how much you are willing to spend maybe you should send a email to
http://www.ora600.be/
regards
Hrishy
-
any export option
in the server manager i can fire queries and using that retrieve most of the text data using spool.
now i need to retrieve the clob data only.
i dont care if DB comes up or not as long as i have the data.
-
Hi
Pardon me if this sounds rude.
Here is a advice please hire a DBA you don't have a clue of what you are talking about.
Hire DBA's and provide jobs in the downturn.
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|