How to split and load records

{System.Data.OracleClient.OracleException: ORA-01795: maximum number of expressions in a list is 1000


string[] list_key = {1,2,3,.................................... 10000}
string split = "'" + string.Join("','", list_key) + "'";

Oracle query - select * from Tablename where column1 in (" + split+ ")";

When I run the query which has 10000 in alist, giving out the error mentioned.

How to split into 500 and select itthen have to load into Datatable