I would like to activate the PSAPTEMP to autoextend before start the index / table compression.
Is the below command OK?
brspace -f tsextend -t PSAPTEMP -s 5120 -a yes -i 100 -m 15360 -f <sapdata_dir>
My question what should be the value of <sapdata_dir>?
I run the following script -->select * from dba_data_files where tablespace_name='PSAPTEMP'
However there is no entry.
If i use the command as below , could i run it when the database is open?
ALTER DATABASE DATAFILE '<path_and_name>' AUTOEXTEND ON;
Thank you so much!