Skip to Content
0
Former Member
Sep 13, 2014 at 08:18 AM

question about activate the PSAPTEMP to autoextend

482 Views

Dear all,

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!