| ORA-01795: maximum number of expressions in a list is 1000 [message #358511] |
Tue, 11 November 2008 12:13  |
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 #380396 is a reply to message #358517] |
Sun, 11 January 2009 17:58  |
 |
Kevin Meade
Messages: 2103
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
