Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Sep 2005
    Thanked 0 Times in 0 Posts

    Question Oracle doubt-exporting

    hi all,

    how can i export data to .txt file from oracle.

    any solution to export data from oracle to sqlserver7.0

    it's urgent plsssssss......


  2. #2
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Near Chicago, IL, USA
    Thanked 32 Times in 31 Posts
    Look at the documentation for the "exp" utility for Oracle.
    And I don't know any way to directly move data from Oracle to Sql Server, since they have different data types. You'd need some sort of third party tool, more than likely.

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts