Skip to Content

Problem facing with data load from Huge flat file to Oracle

Hi All,

We are trying to load flat file(txt) file of 1.9GB and with ~29 columns.

We prepared an package to load the data into Oracle for this data load.

While executing it is inserting around 0.25 M records and it is failing.

please find the blow errors:

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jan 22, 2014 at 11:28 PM

    The Errors are related to Space issue but my server has lots of free space and in logs folder also lots of space available.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 24, 2014 at 10:17 PM


    err_snap.PNG (27.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 25, 2014 at 08:20 PM

    Hi Sreenivas,

    From the ' error message ' image looks like Table space issue or authorization issue. Please try to get in touch with BASIS as well to increase the size of the table.

    Also , i suppose for the DTP to be successful, preparing multiple packages instead of one and assigning sufficient no of background process to the load, may work.

    Please let know.😕

    Regards,
    Aparajit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 27, 2014 at 04:57 AM

    Hi Sreenivas,

    Please try with Data_transfer Transform and update the thread 😊

    Cheers,

    Shiva Sahu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.