Michelle Lacy Posted April 29, 2020 Share Posted April 29, 2020 Hello, When setting up my Oracle data connection using Data Connectors, as the dialgoue box tries to load the tables from the database. I get the error message "ORA-01795: maximum number of expressions in a list is 1000". I am assuming because to load the tables the connector is requesting all tables in said schema. If there are more than 1000 tables, it will not load. Is there a way to limit the number of tables the connector is pulling down Michelle Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted April 30, 2020 Share Posted April 30, 2020 Try using the Database connector, which allows you to create a custom query. Click on the blue "+" sign, then click on 'Other'. Click on 'Load data with ODBC, OLE DB or ADO.NET data provider', then you can select the "OracleClient Data Provider" Data source type. Enter the details for the connection to see you tables, then you can modify the SQL statement to bring in your data. This will allow you to limit the number of tables that are being accessed. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now