Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

question about activate the PSAPTEMP to autoextend

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!

Tags:
Former Member
replied

I would create a file at the OS level called TSCreate.sh and have these commands added to it.

brspace -c force -o process,time -f tsextend -t PSAPTEMP -f sapdata1 -s 1024 -a yes -m 31744 -i 128

brspace -c force -o process,time -f tsextend -t PSAPTEMP -f sapdata2 -s 1024 -a yes -m 31744 -i 128

brspace -c force -o process,time -f tsextend -t PSAPTEMP -f sapdata3 -s 1024 -a yes -m 31744 -i 128

brspace -c force -o process,time -f tsextend -t PSAPTEMP -f sapdata4 -s 1024 -a yes -m 31744 -i 128

Execute the script as orasid.

Good Luck

RB

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question