temporary tables in PSAPUSER1D during cube compression
We are now compressing the fact tables for a large number of historical InfoCubes that are no longer being loaded, but whose fact tables were not compressed before.
The compression jobs are broken up into smaller pieces for each cube, and no more than 2 compression jobs are scheduled to run at one time.
One of these compression jobs has failed with the following error in the job log :
System error: ORA-01653: unable to extend table SAPR3./BI0/0400016502I by 128 in tablespace PSAPUSER1D
I am curious to understand why the temporary tables for cube compression are created in the PSAPUSER1D tablespace ? Typically this is a smaller sized tablespace. And for BW jobs that have large data
sizes, the temporary tables would be better located in a tablespace that provides more wiggle room for temporary use.
Upon running this select below, I find that 15 such tables are currently found in PSAPUSER1D :
select tablespace_name from dba_tables where table_name
What configuration changes can be made to change the default location of these temporary tables during fact table compression ?
If there is no such configuration setting, is it then necessary to increase the size of the PSAPUSER1D tablespace in order to continue with the fact table compressions ?
Thank you very much,