Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

oracle : how do i import/bcp a flat file into table in database?

Posted on 2008-10-07
6
Medium Priority
?
769 Views
Last Modified: 2013-12-18
how do i import/bcp a flat file into table in database?
0
Comment
Question by:gogoshar
  • 3
6 Comments
 
LVL 27

Accepted Solution

by:
Tolomir earned 1000 total points
ID: 22661426
comfortable way would be to use a tool like that:

http://www.withdata.com/oraloader.html


0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 1000 total points
ID: 22662908
If your file follows a specific format that is the same for each row you can just use SQL Loader (don't need to buy any third-party tools for that).

0
 
LVL 27

Expert Comment

by:Tolomir
ID: 22663367
Here is a FAQ for the sql loader:

http://www.orafaq.com/wiki/SQL*Loader_FAQ



0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question