Importing data


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Importing data

  1. #1
    Sandy Guest

    Importing data


    I have just recently started working with Oracle 8i and have a SQL Server
    background. When we wanted to import large amounts of data into a table
    in the db we sould use a "bulk copy". Oracle doesn't appear to have anything
    like this.

    Can anyone give me a tip on taking data in a flat file and importing into
    an Oracle db.

    Thanks!

  2. #2
    dnagel Guest

    Re: Importing data

    it does, but its a command line (dos) program...

    Can't recall the name off-hand...

    D.

    "Sandy" <smbcat@nol.net> wrote in message news:3ce3afad$1@10.1.10.29...
    |
    | I have just recently started working with Oracle 8i and have a SQL Server
    | background. When we wanted to import large amounts of data into a table
    | in the db we sould use a "bulk copy". Oracle doesn't appear to have anything
    | like this.
    |
    | Can anyone give me a tip on taking data in a flat file and importing into
    | an Oracle db.
    |
    | Thanks!



  3. #3
    Guy Smith Guest

    Re: Importing data


    Sandy,

    You are looking for the SQL Loader utility.

    http://www.orafaq.com/faqloadr.htm

    O'Reilly publishes a book on the utility if the Oracle documentatoin is not
    enough for you.

    Guy Smith

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center