temp tablespace frequently gets full and everytime we shutdown apps and dbs.is there any other solution for this issue?
As the name suggest temporary tablespace does not permanent data. Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables.
It will automatically reuse the space.
Is autoextend enable in your temp tablespace.
i already answered that question here: Re: My temporary_tablespace 95% filled up in production