Results 1 to 5 of 5

Thread: [RESOLVED] .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net

  1. #1

    Thread Starter
    PowerPoster make me rain's Avatar
    Join Date
    Sep 2008
    Location
    india/Hubli
    Posts
    2,208

    Resolved [RESOLVED] .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net

    i am from MySql + vb.net back ground

    my task is to take the query output from the DB2 9.7 and create the .dbf file for ORACLE 10g
    in this connection i need some advises

    what exactly is this .Dbf file is , is this just like a .sql file
    is there any way to create the .Dbf file from DB2 database using ado.net
    The averted nuclear war
    My notes:

    PrOtect your PC. MSDN Functions .OOP LINUX forum
    .LINQ LINQ videous
    If some one helps you please rate them with out fail , forum doesn't expects any thing other than this

  2. #2
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,226

    Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net

    .dbf is the extension of the file that oracle uses to store its data.


    Database datafiles are physical files stored on disk. These files are used to store data on disk. You cannot directly write to these files.
    That is what RDBMS systems were invented for. You can use a tool like sqlplus or TOAD or your client program to login to the oracle database and then update the data that is held in these files.


    .dbf also incidentally happens to be the same extension used by the dBaseIII systems. These files are different from the oracle datafiles I mentioned earlier.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog

  3. #3

    Thread Starter
    PowerPoster make me rain's Avatar
    Join Date
    Sep 2008
    Location
    india/Hubli
    Posts
    2,208

    Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net

    thanks abhi for reply
    is it possible to execute the .sql files with in oracle , i mean the file with series of INSERT statements to an existing table of oracle
    The averted nuclear war
    My notes:

    PrOtect your PC. MSDN Functions .OOP LINUX forum
    .LINQ LINQ videous
    If some one helps you please rate them with out fail , forum doesn't expects any thing other than this

  4. #4
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,226

    Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net

    Quote Originally Posted by make me rain View Post
    thanks abhi for reply
    is it possible to execute the .sql files with in oracle , i mean the file with series of INSERT statements to an existing table of oracle
    The short answer is YES. You would execute it at the SQL PLUS prompt after logging into the database server.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog

  5. #5

    Thread Starter
    PowerPoster make me rain's Avatar
    Join Date
    Sep 2008
    Location
    india/Hubli
    Posts
    2,208

    Re: .Dbf files ( DB2 9.7 to ORACLE 10 ) through ado.net

    Thanks abhijit ji
    it worked
    The averted nuclear war
    My notes:

    PrOtect your PC. MSDN Functions .OOP LINUX forum
    .LINQ LINQ videous
    If some one helps you please rate them with out fail , forum doesn't expects any thing other than this

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