To gather information related to temp tablespace and tempfiles, pls use
the following views :
v$sort_usage
v$sort_segment
v$tempfile
Regards
Rajesh Chauhan
----- Forwarded by Rajesh K Chauhan/e-Centre/PLL on 04-05-05 12:39 PM
-----
"Bridget" <oracledba-ezmlmshield-x54329874.[Email address protected]
04-05-05 12:27 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
TEMP tablespace
Hi question
how do I find the size of tablespace TEMP and how do I extend it . An
import failed and I believe it was during an index creation with the
following errors below
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Thu Apr 28 19:33:32 2005
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Thu Apr 28 19:38:22 2005
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Thu Apr 28 19:42:34 2005
When I run the query below it does not seem to have the tablespace TEMP .
Please help very confused
SQL> select tablespace_name from dba_tablespaces ;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
DRSYS
INDX
TOOLS
USERS
XDB
USERS_UPG
ACTEST
AUDIT_ARCHIVE
11 rows selected.
<font face="Times New Roman" size="3">
<p>------------------------------------------------------------------------------</p>
<p> This email is intended only for the use of the individual(s) to whom
it is addressed and may be privileged and confidential. Unauthorised use
or disclosure is prohibited. If you receive this e-mail in error, please
advise immediately and delete the original message. This message may have
been altered without your or our knowledge and the sender does not accept
any liability for any errors or omissions in the message.</p>
<p>====================================================</p>
</font>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page