Solved

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

Posted on 2008-10-07
6
759 Views
Last Modified: 2013-12-18
how do i import/bcp a flat file into table in database?
0
Comment
Question by:gogoshar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 27

Accepted Solution

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

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


0
 
LVL 27

Expert Comment

by:Tolomir
ID: 22661446
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 250 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

635 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