Do you have Enterprise Manager?? It makes jobs like these easier. You can
check and extend the size from there. Let's know if you need further help
-----Original Message-----
From: Bridget
[mailto:oracledba-ezmlmshield-x54329874.[Email address protected]
Sent: Wednesday, May 04, 2005 7:58 AM
To: LazyDBA Discussion
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
This e-mail (and any attachments) contains information, which is
confidential and intended solely for the attention and use of the named
addressee(s). If you are not the intended recipient you must not copy,
distribute or use it for any purpose or disclose the contents to any person.
If you have received this e-mail in error, please notify us immediately at
[Email address protected] The information contained in this e-mail (and any attachments)
is supplied in good faith, but the sender shall not be under any liability
in damages or otherwise for any reliance that may be placed upon it by the
recipient. Any comments or opinions expressed are those of the originator
not of NTT Europe Ltd unless otherwise expressly stated.
This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com
Oracle LazyDBA home page