Oracle Database issues

[mdrew9]

I am connection to an Oracle DB and I am writing a SQL query for the data I want. As of right now this table in this DB is small, the table is 1259 rows. The SQL query I wrote requires a small refinement, but bringing up the table properties and clicking "design" locks up Excel completely. The query as it is populates fine into the PP window, so there shouldn't be a problem with the query. Am I doing something wrong here?

 

[mdrew9]

This just takes a real long time to come up, but it does come up.

 

[miguel.escobar]

It depends on your query but selecting a table with 10 columns and 1million rows actually takes me about 10 minutes to load from Oracle 10g XE, just to give you an idea. People have created multiple optimized connectors for this type of situation that you can look up online but most of those offers will require you to pay a yearly fee.

Hope this helps