export CLOB data in flat file from oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: export CLOB data in flat file from oracle 8i

  1. #1
    Join Date
    Oct 2008
    Posts
    2

    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.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #3
    Join Date
    Oct 2008
    Posts
    2

    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.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    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
  •  



Click Here to Expand Forum to Full Width