# ETL Tool Importing Massive Size Data & Constraint Error

**URL:** <https://community.neo4j.com/t/etl-tool-importing-massive-size-data-constraint-error/62761>\
**Category:** ETL-Tool\
**Created:** [June 2, 2023, 8:56am UTC](https://community.neo4j.com/t/etl-tool-importing-massive-size-data-constraint-error/62761 "2023-06-02T08:56:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ozanbicer](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ozanbicer/32/28086_2.png) [@ozanbicer](https://community.neo4j.com/u/ozanbicer)\
**Post date:** [June 2, 2023, 8:56am UTC](https://community.neo4j.com/t/etl-tool-importing-massive-size-data-constraint-error/62761/1 "2023-06-02T08:56:34Z")

</div>

Hey everyone,

I'm working on importing a database from Oracle to Neo4j Desktop with ETL Tool Graph App. I've got 2 issues with that.

First one is when I import the data, I get this error even though import is completed.

" Invalid constraint syntax, ON and ASSERT should not be used. Replace ON with FOR and ASSERT with REQUIRE. (line 1, column 1 (offset: 0)) "CREATE CONSTRAINT ON (n:Mrrel) ASSERT n.aui IS UNIQUE"

I'm aware that this command is changed now but I don't know where ETL Tool gets this command from and I can't fix it.

Second problem is my database is huge. There are approximately 250million rows of data in total. Even importing 300 thousand rows takes around 2-3 hours. So importing 250million rows seems like impossible.

 ![etltool](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/7/8/78014ecb44ef913054f6979710cb1c1e2cb1489f.png)

Here's my ETL Tool screen. Changing settings here doesn't help

Is there any method to speed up this process? If anyone has an idea I'd love to hear it.

Thanks.

---

<div class="post-metadata">

**Author:** ![dana\_canzano](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/dana_canzano/32/27392_2.png) [@dana\_canzano](https://community.neo4j.com/u/dana_canzano)\
**Post date:** [June 2, 2023, 11:14am UTC](https://community.neo4j.com/t/etl-tool-importing-massive-size-data-constraint-error/62761/2 "2023-06-02T11:14:44Z")

</div>

@ozanbicer

1. i presume this is an export from Oracle and into a Neo4j v5.8.0 database. Correct? or is it a different Neo4j version?

2. is your data, and specifically a significant portion, from Oracle thus mapped to nodes with name `:Mrrel`. Since the constraint is not created and as a constraint thus automatically creates an index on said label/property perhaps the abscence of said constraint and accompanying index is leading to the performance degradation. Can you manually create the constraint in the Neo4j database itself prior to export?

---

<div class="post-metadata">

**Author:** ![ozanbicer](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ozanbicer/32/28086_2.png) [@ozanbicer](https://community.neo4j.com/u/ozanbicer)\
**Post date:** [June 2, 2023, 12:13pm UTC](https://community.neo4j.com/t/etl-tool-importing-massive-size-data-constraint-error/62761/3 "2023-06-02T12:13:01Z")

</div>

1. Yes it's an export from Oracle to Neo4j v5.8.0. Also I've tried with a Neo4j 5.3.0 database, but same problem remains.

2. Actually, Mrrel is a pretty small portion of my database. But as far as I have observed, I am getting this error in every table/label.

Even though I define the constraints manually, it still tries to create the same constraints with the depreceated command and because of this I keep getting the same error.

I don't know how much this error affects the performance, but defining constraints is not a big problem for me. The main problem is data transfer speed. For a that large database, maybe I should try offline-bulk import mentioned here. [Neo4j ETL - Neo4j ETL Docs](https://neo4j.com/labs/etl-tool/1.5.0/) But I guess ETL Tool Graph App doesn't support that? and I believe I will get the same constraint error there too.