Home » SQL & PL/SQL » SQL & PL/SQL » Bulk insert in index table (10.2.1.0)
Bulk insert in index table [message #589557] Mon, 08 July 2013 09:21 Go to next message
pratik4891
Messages: 53
Registered: February 2011
Member

Could anyone please let me know why bulk insert is not possible in a table which has index?
Any reference to a document will be helpful too

Thanks for you help Smile


Re: Bulk insert in index table [message #589559 is a reply to message #589557] Mon, 08 July 2013 09:24 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
What precise definition of bulk insert are you using?
Because I'm pretty sure it is possible.
Re: Bulk insert in index table [message #589662 is a reply to message #589557] Tue, 09 July 2013 09:42 Go to previous messageGo to next message
Bill B
Messages: 1049
Registered: December 2004
Senior Member
You might be thinking of DIRECT ACCESS load, which will invalidate the indexes on the table being loaded. The indexes on the table will need to be refreshed after the load.
Re: Bulk insert in index table [message #589698 is a reply to message #589557] Wed, 10 July 2013 02:29 Go to previous messageGo to next message
pratik4891
Messages: 53
Registered: February 2011
Member
Below is the error I am having

ORA-26002: Table has index defined upon it
Re: Bulk insert in index table [message #589702 is a reply to message #589698] Wed, 10 July 2013 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-26002: Table %s has index defined upon it.\n
 *Cause:   Parallel load was specified into a table which has index
           defined upon it.
 *Action:  Drop index(es) defined upon table, or don't use parallel load,
           or use SKIP_INDEX_MAINTENANCE option.


Copy and paste what you did and got.
How could you think we can debug something we don't see?

Before further post, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Bulk insert in index table [message #589739 is a reply to message #589702] Wed, 10 July 2013 07:13 Go to previous messageGo to next message
pratik4891
Messages: 53
Registered: February 2011
Member
Appreciate all the responses ,actually all the loads are done by informatica tool .So I am not sure how to set the parameters there.
But please let me know why parallel = TRUE option fail the table load

I want to know the reason behind it
Re: Bulk insert in index table [message #589742 is a reply to message #589739] Wed, 10 July 2013 07:28 Go to previous message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the "Action" part of my post.

Regards
Michel
Previous Topic: Rollback issue
Next Topic: How to use timeout in plsql
Goto Forum:
  


Current Time: Sat Apr 19 16:33:57 CDT 2014

Total time taken to generate the page: 0.29562 seconds