RE: temp tablespace

From: Kieran Murray <Kieran.Murray_at_esat.com>
Date: Thu, 4 Jan 2001 14:25:18 -0000
Message-Id: <10731.125706@fatcity.com>

Is you want a tablespace to be temporary you cannot have any permanent objects in there
(e.g. tables, indexes)...

run the following to find out whats in your tablespace..

select owner, segment_name, segment_type from dba_segments
where tablespace_name = <your_tablespace_name>;

Rgds,
Kieran

-----Original Message-----
From: Sajid Iqbal [mailto:siqbal_at_vianetworks.co.uk] Sent: 04 January 2001 13:20
To: Multiple recipients of list ORACLE-L Subject: temp tablespace

Hello

I am trying to change my temporary tablespace to be temporary as its permanent at the moment.

This has been highlighted be errors such as unable to extend temp segment in tablespace temp !

When i try to make the chage I get the following error !

ERROR at line 1:
ORA-01662: tablespace 'TEMP' is non-empty and cannot be made temporary

Any ideas

--

Sajid Iqbal
Database Administrator

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sajid Iqbal
INET: siqbal_at_vianetworks.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

http://www.marketplace.ie
Ireland's Home for eBusiness

Received on Thu Jan 04 2001 - 08:25:18 CST