temporary table space?
443294Nov 13 2005 — edited Nov 13 2005Hi,
I created view called swartview. and when i execute
select * from swartview i get this error
ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP
wat does 128 denote?? 128 mb or kb..
Is it OK to add a datafile for teh tablespace PSAPTEMP?
If its a temporary tablespace wat is te syntax to add a tempfile??
alter tablespace psaptemp add tempfile..??
Kindly help..