896398 wrote:What is database version?
i am getting below mentioend error in db
ora1652 unable to increase temp segment by 128 in tablespace temp
how to increase tablespace.please help with command
to add temp file
CREATE temporary TABLESPACE DT_TEMP tempfile 'path/filename.dbf' SIZE 320M
Size can be specify according to requirement.
ALTER TABLESPACE lmtemp ADD TEMPFILE 'path/filename.dbf' SIZE 18M AUTOEXTEND ON;
sql>select file_name,tablespace_name,bytes/(1024*1024*1024) from dba_temp_filesIf size is higher than expected, then you can try shrink the temp file space and can do the transaction again.
sql>alter tablespace temp shrink spacecheck again the size. If tablespace shrinked enough to carry out your transaction, then proceed.