Home » SQL & PL/SQL » Client Tools » ORA-01795: maximum number of expressions in a list is 1000 (Toad,9.1,linux)
ORA-01795: maximum number of expressions in a list is 1000 [message #358511] Tue, 11 November 2008 12:13 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I have one tables with 5000 records.

I have extracted insert statements from this table in schema browser using "create insert for selected rows" option in Toad 9.1

It shows error "ORA-01795: maximum number of expressions in a list is 1000".

But i able to extracted insert statements for 1000 records.

How can resolve this problem?

Thanks,
Micahel.
Re: ORA-01795: maximum number of expressions in a list is 1000 [message #358517 is a reply to message #358511] Tue, 11 November 2008 12:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Split the list.

Regards
Michel
Re: ORA-01795: maximum number of expressions in a list is 1000 [message #380396 is a reply to message #358517] Sun, 11 January 2009 17:58 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
There is a miximum number of elements allowed in an IN list and it is 1000. Go beyond this and you get this error. I suspect toad has generated a query that exceeds this limit.

The two most common approaches to getting around this are:

1) split the workload up such that you never generate more than 1000 items in an IN list (this was suggested already)

2) join to a table that contain the list of values you want. There is no limit with this method as it is a simple join.

Good luck, Kevin
Previous Topic: When does exiting Sqlplus not commit an insert statement?
Next Topic: Oracle toad related problem
Goto Forum:
  


Current Time: Fri Dec 02 22:40:32 CST 2016

Total time taken to generate the page: 0.05134 seconds