Solved

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

Posted on 2008-10-07
6
742 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 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now