Solved

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

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

710 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