When we ran the PORAv530-540.sql upgrade script we received an error at the end of the script because it could not find the tablespace named STTEMP. Can you please tell me how/when this tablespace should have been created?
STTEMP should exist in the beginning of stat implementation
Here is the DDL to create STTEMP tablespace:
Create Temporary Tablespace STTEMP Tempfile
'[MOUNTPT]/STTEMP01.DBF' SIZE 75M AUTOEXTEND ON NEXT 20M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;