Oracle Tablespace

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Duncan_McCunn_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Oracle Tablespace

Post by Duncan_McCunn_(Guest) » Thu Jul 21, 2005 4:34 am

When running some RR reports the Temp Tablespace is being used up. Currently this is set at 2GB but it runs out and returns oracle error 1652 unable to extend tablespace.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Oracle Tablespace

Post by kfleming » Thu Jul 21, 2005 8:00 am

This would depend on the SELECT that is issued by the report and the table structure definitions within Oracle.____Kathleen__R&R Support

Duncan_McCunn_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Oracle Tablespace

Post by Duncan_McCunn_(Guest) » Thu Jul 21, 2005 9:42 am

Kathleen____Thanks for the update. The select will problably be from the default dialog. From your reply I am guessing this will do a full table scan?____

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Oracle Tablespace

Post by kfleming » Thu Jul 21, 2005 1:10 pm

You use Database->Show SQL to see the SELECT.____If there is no WHERE clause, then you would be getting back all records.____Kathleen__R&R Support__

Post Reply