---
title: "Discussion on \"5X File Loads from Object Storage with DBMS_CLOUD.COPY_DATA\" | Hashnode"
description: "Discussion on \"5X File Loads from Object Storage with DBMS_CLOUD.COPY_DATA\". Learn how to improve data load times from Object Storage by 5X using dbms_cloud.copy_data"
url: "https://hashnode.com/posts/5x-file-loads-with-dbmscloudcopydata/65cec9b8f93032a7566067f7"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [5X File Loads from Object Storage with DBMS\_CLOUD.COPY\_DATA](https://blog.cloudnueva.com/5x-file-loads-with-dbmscloudcopydata?utm_source=hashnode&utm_medium=feed)

Learn how to improve data load times from Object Storage by 5X using dbms\_cloud.copy\_data

Feb 16, 2024 · 9 min read · blog.cloudnueva.com  
Updated Feb 22, 2024  
Read the article

-   [#oci](https://hashnode.com/tag/oci)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#integration](https://hashnode.com/tag/integration)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 3

Markdown supported · ⌘↵ to post

[padmanathan venkadasamy](https://hashnode.com/@paddy1973)

[Oct 10, 2024](https://hashnode.com/posts/5x-file-loads-with-dbmscloudcopydata/65cec9b8f93032a7566067f7/comment/67085669bd1b0681aa08e13b)

Very nice

[Jon Dixon](https://hashnode.com/@orclapex)

[Oct 12, 2024](https://hashnode.com/posts/5x-file-loads-with-dbmscloudcopydata/65cec9b8f93032a7566067f7/comment/67085669bd1b0681aa08e13b#reply-670a73c2b617d337fcdb0a10)

Thank You.

[D Explorer](https://hashnode.com/@deepika70)

[Sep 10, 2024](https://hashnode.com/posts/5x-file-loads-with-dbmscloudcopydata/65cec9b8f93032a7566067f7/comment/66e0121ae36f3e40016cc18e)

Thanks, It's a Great Blog John! I got this working with csv files. Is there a similar functionality to copy data from json file? Could you advise please?

[Sudhesh Nayak](https://hashnode.com/@Sudhesh)

[May 9, 2024](https://hashnode.com/posts/5x-file-loads-with-dbmscloudcopydata/65cec9b8f93032a7566067f7/comment/663c15e840055fdc812c91cc)

Thanks, John. Great article. I do use Copy\_data a lot for csv/text files. However, I was wondering if you have a similar solution when the file has a header (data values not column names), detail and a trailer? How can one handle such files?

[Jon Dixon](https://hashnode.com/@orclapex)

[May 12, 2024](https://hashnode.com/posts/5x-file-loads-with-dbmscloudcopydata/65cec9b8f93032a7566067f7/comment/663c15e840055fdc812c91cc#reply-66412e586d15ab70fa87c829)

Thank you for the feedback. It has been a long time since working with these kinds of files. I think you are going to have to process the file with custom PL/SQL.