<div>
Have you ever considering drop index and create in the end.
</div>


Have you ever considering drop index and create in the end.

<div>
I don't believe you can 'disable' an index. &nbsp;I think you will need to drop it.
</div>


I don't believe you can 'disable' an index.  I think you will need to drop it.

<div>
To drop indexes the load process should be terminated otherwise it will give &quot;RESOURCE BUSY&quot; error. Isn't it?<br />
So, I just wanna make those indexes unusable.<br />

</div>


To drop indexes the load process should be terminated otherwise it will give "RESOURCE BUSY" error. Isn't it?
So, I just wanna make those indexes unusable.


<div>
I can drop and recreate after load is done.<br />
I wanna make sure whether i can make them unusable on the fly or not?
</div>


I can drop and recreate after load is done.
I wanna make sure whether i can make them unusable on the fly or not?

<div>
<div class="content wysiwyg-content">
I am loading 300million records into a table. It has been taking long time to insert. <br />
I want to disable Indexes on that table to make it faster. Can i disable them with out stopping the load process?<br />

</div>
</div>


I am loading 300million records into a table. It has been taking long time to insert. 
I want to disable Indexes on that table to make it faster. Can i disable them with out stopping the load process?


How to disable indexes while inserting data?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.