Re: TEMP Tablespace problem
In 9i you could issue an drop tablespace temp including contents and datafiles. (First make sure that this tablespace is not a default temporary tablespace). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 5:54 AM What is the Oracle version? At 06:24 PM 9/30/2003 -0800, you wrote: Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: TEMP Tablespace problem
9.2i [EMAIL PROTECTED] 09/30/03 08:54PM What is the Oracle version?At 06:24 PM 9/30/2003 -0800, you wrote:Hi!!I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller.Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday).Wolfgang BreitlingCentrex Consulting Corporationhttp://www.centrexcc.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wolfgang Breitling INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: TEMP Tablespace problem
This table do not have any file, how I understood this is the table space that the queries uses. They tell me that if I run a query that need mode that the actual space it will be made that the TEMP tablespace grow. [EMAIL PROTECTED] 09/30/03 10:09PM If the TEMP tablespace is a temporary tablespace, i.e. made of temp files rather than datafiles, then you can't offline it. It would have to be dropped and rebuilt.At 07:34 PM 9/30/2003 -0800, you wrote:Maybe you can create another temp tablespace (called temp_new) on anotherdisk, assign all users to temp_new, then offline the old temp tablespace,drop the old temp tablespace, and finally remove the old temp datafilesfrom OS.Wolfgang BreitlingOracle7, 8, 8i, 9i OCP DBACentrex Consulting Corporationhttp://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wolfgang Breitling INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: TEMP Tablespace problem
If you can stop the users then simply drop the tablespace and remove the datafile, then crate new smaller temp. If you can not stop the users do: 1) Create newsmall temp; 2) Alter all users to use the new temp. 3) Drop temp , after you are sure that none of the users is using it. Yechiel AdarMehish - Original Message - From: Teresita Castro To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 4:19 PM Subject: Re: TEMP Tablespace problem 9.2i [EMAIL PROTECTED] 09/30/03 08:54PM What is the Oracle version?At 06:24 PM 9/30/2003 -0800, you wrote:Hi!!I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller.Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday).Wolfgang BreitlingCentrex Consulting Corporationhttp://www.centrexcc.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wolfgang Breitling INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: TEMP Tablespace problem
Where did you look for this file? Use v$tempfile or dba_temp_files. Anyway, your case is a good reason why not to enable autoextend in temp and rbs tablespaces without extra care. If you got DBA access to your database, you could: 1) create temporary tablespace new_temp 2) alter database default temporary tablespace new_temp 3) drop tablespace temp including contents and datafiles (might take time) 4) create temporary tablespace temp ... 5) alter database default temporary tablespace temp 6) drop tablespace new_temp including contents and datafiles If you don't have DBA access nor OS access, then you have to wait until your administrator comes back or hack yourself into serverroom to get physical access to your server. Tanel. - Original Message - From: Teresita Castro To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 5:39 PM Subject: Re: TEMP Tablespace problem This table do not have any file, how I understood this is the table space that the queries uses. They tell me that if I run a query that need mode that the actual space it will be made that the TEMP tablespace grow. [EMAIL PROTECTED] 09/30/03 10:09PM If the TEMP tablespace is a temporary tablespace, i.e. made of temp files rather than datafiles, then you can't offline it. It would have to be dropped and rebuilt.At 07:34 PM 9/30/2003 -0800, you wrote:Maybe you can create another temp tablespace (called temp_new) on anotherdisk, assign all users to temp_new, then offline the old temp tablespace,drop the old temp tablespace, and finally remove the old temp datafilesfrom OS.Wolfgang BreitlingOracle7, 8, 8i, 9i OCP DBACentrex Consulting Corporationhttp://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wolfgang Breitling INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: TEMP Tablespace problem
I have Oracle 9.2i I already run the query and the tablespace TEMP have CONTENTS=TEMPORARY AND EXTENT_MAN=LOCAL Can I run this line to fix the size of my tablespace? SQL alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M; I mean is the same or I have to change something? [EMAIL PROTECTED] 09/30/03 10:04PM Teresita, spelling the word "administrator" with the capital letteris a good thing. Furthermore, if you have version 9i, you can do thefollowing, little known, thing:SQL alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M;Database altered.If it's Oracle 8i, you can actually have a permanent, dictionary based tablespace acting as a temporary tablespace. In version 9, however, youcan't. Here is the query to find out what do you have: 1 select tablespace_name,contents,extent_management 2 from dba_tablespaces 3* order by contentsSQL /TABLESPACE_NAME CONTENTS EXTENT_MAN-- - --SYSTEM PERMANENT LOCALDRSYS PERMANENT LOCALEXAMPLE PERMANENT LOCALINDX PERMANENT LOCALUSERS PERMANENT LOCALXDB PERMANENT LOCALTOOLS PERMANENT LOCALTEMP TEMPORARY LOCALUNDOTBS1 UNDO LOCAL9 rows selected.SQLIf the column contents reads "TEMPORARY" for the given tablespace, you candrop it and recreate it without any harm. Note that in 8i you don't have "UNDO" tablespaces and your system tablespace cannot be LMT.On 2003.09.30 22:24, Teresita Castro wrote: Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday).-- Mladen GogalaOracle DBA-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mladen Gogala INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: TEMP Tablespace problem
Yes you can. On Wed, 2003-10-01 at 11:29, Teresita Castro wrote: I have Oracle 9.2i I already run the query and the tablespace TEMP have CONTENTS=TEMPORARY AND EXTENT_MAN=LOCAL Can I run this line to fix the size of my tablespace? SQL alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M; I mean is the same or I have to change something? [EMAIL PROTECTED] 09/30/03 10:04PM Teresita, spelling the word administrator with the capital letter is a good thing. Furthermore, if you have version 9i, you can do the following, little known, thing: SQL alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M; Database altered. If it's Oracle 8i, you can actually have a permanent, dictionary based tablespace acting as a temporary tablespace. In version 9, however, you can't. Here is the query to find out what do you have: 1 select tablespace_name,contents,extent_management 2 from dba_tablespaces 3* order by contents SQL / TABLESPACE_NAMECONTENTS EXTENT_MAN -- - -- SYSTEM PERMANENT LOCAL DRSYS PERMANENT LOCAL EXAMPLEPERMANENT LOCAL INDX PERMANENT LOCAL USERS PERMANENT LOCAL XDBPERMANENT LOCAL TOOLS PERMANENT LOCAL TEMP TEMPORARY LOCAL UNDOTBS1 UNDO LOCAL 9 rows selected. SQL If the column contents reads TEMPORARY for the given tablespace, you can drop it and recreate it without any harm. Note that in 8i you don't have UNDO tablespaces and your system tablespace cannot be LMT. On 2003.09.30 22:24, Teresita Castro wrote: Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: TEMP Tablespace problem
I don't think that you can reduce temp datafile much below bytes_used value in v$temp_space_header. I could reduce the file few kilobytes, but not much compared to it's size. In order to reduce bytes_used, you need to bounce instance (if there isn't any nifty tricks for releasing temp segment otherwise). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 6:34 PM Yes you can. On Wed, 2003-10-01 at 11:29, Teresita Castro wrote: I have Oracle 9.2i I already run the query and the tablespace TEMP have CONTENTS=TEMPORARY AND EXTENT_MAN=LOCAL Can I run this line to fix the size of my tablespace? SQL alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M; I mean is the same or I have to change something? [EMAIL PROTECTED] 09/30/03 10:04PM Teresita, spelling the word administrator with the capital letter is a good thing. Furthermore, if you have version 9i, you can do the following, little known, thing: SQL alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M; Database altered. If it's Oracle 8i, you can actually have a permanent, dictionary based tablespace acting as a temporary tablespace. In version 9, however, you can't. Here is the query to find out what do you have: 1 select tablespace_name,contents,extent_management 2 from dba_tablespaces 3* order by contents SQL / TABLESPACE_NAMECONTENTS EXTENT_MAN -- - -- SYSTEM PERMANENT LOCAL DRSYS PERMANENT LOCAL EXAMPLEPERMANENT LOCAL INDX PERMANENT LOCAL USERS PERMANENT LOCAL XDBPERMANENT LOCAL TOOLS PERMANENT LOCAL TEMP TEMPORARY LOCAL UNDOTBS1 UNDO LOCAL 9 rows selected. SQL If the column contents reads TEMPORARY for the given tablespace, you can drop it and recreate it without any harm. Note that in 8i you don't have UNDO tablespaces and your system tablespace cannot be LMT. On 2003.09.30 22:24, Teresita Castro wrote: Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel
TEMP Tablespace problem
Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday).
Re: TEMP Tablespace problem
What is the Oracle version? At 06:24 PM 9/30/2003 -0800, you wrote: Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: TEMP Tablespace problem
Maybe you can create another temp tablespace (called temp_new) on another disk, assign all users to temp_new, then offline the old temp tablespace, drop the old temp tablespace, and finally remove the old temp datafiles from OS. HTH. Guang On Tue, 30 Sep 2003, Teresita Castro wrote: Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: TEMP Tablespace problem
Teresita, spelling the word administrator with the capital letter is a good thing. Furthermore, if you have version 9i, you can do the following, little known, thing: SQL alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M; Database altered. If it's Oracle 8i, you can actually have a permanent, dictionary based tablespace acting as a temporary tablespace. In version 9, however, you can't. Here is the query to find out what do you have: 1 select tablespace_name,contents,extent_management 2 from dba_tablespaces 3* order by contents SQL / TABLESPACE_NAMECONTENTS EXTENT_MAN -- - -- SYSTEM PERMANENT LOCAL DRSYS PERMANENT LOCAL EXAMPLEPERMANENT LOCAL INDX PERMANENT LOCAL USERS PERMANENT LOCAL XDBPERMANENT LOCAL TOOLS PERMANENT LOCAL TEMP TEMPORARY LOCAL UNDOTBS1 UNDO LOCAL 9 rows selected. SQL If the column contents reads TEMPORARY for the given tablespace, you can drop it and recreate it without any harm. Note that in 8i you don't have UNDO tablespaces and your system tablespace cannot be LMT. On 2003.09.30 22:24, Teresita Castro wrote: Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a disk that is full, so if we can not make it smaller we are going to be in a serius trouble ( our Administrator is not here until Monday). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: TEMP Tablespace problem
If the TEMP tablespace is a temporary tablespace, i.e. made of temp files rather than datafiles, then you can't offline it. It would have to be dropped and rebuilt. At 07:34 PM 9/30/2003 -0800, you wrote: Maybe you can create another temp tablespace (called temp_new) on another disk, assign all users to temp_new, then offline the old temp tablespace, drop the old temp tablespace, and finally remove the old temp datafiles from OS. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
TEMP Tablespace Problem
Somehow I deleted the TEMP tablespace but not the datafile. How do I go about recreating this tablespace? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: TEMP Tablespace Problem
Hi Assuming that you actually use the TEMP tablespace as a real temp tablespace and didn't put any actual data in it, you can just go ahead recreate it by reusing the old datafile. Ken Janusz schrieb: Somehow I deleted the TEMP tablespace but not the datafile. How do I go about recreating this tablespace? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: TEMP Tablespace Problem
Use the REUSE option on the CREATE TABLESPACE command. Ken Janusz ken.janusz To: Multiple recipients of list ORACLE-L @sufsys.com [EMAIL PROTECTED] Sent by: rootcc: Subject: TEMP Tablespace Problem 12/11/2001 10:50 AM Please respond to ORACLE-L Somehow I deleted the TEMP tablespace but not the datafile. How do I go about recreating this tablespace? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: TEMP Tablespace Problem
Ken - I assume you dropped the TEMP tablespace, which doesn't delete the datafile. I'm assuming you are on Unix. Just remove the data file and recreate the TEMP tablespace the same way as you originally did. I believe that the temp tablespace settings for all users will be unaffected, but you might check one or two to make sure. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 11, 2001 9:50 AM To: Multiple recipients of list ORACLE-L Somehow I deleted the TEMP tablespace but not the datafile. How do I go about recreating this tablespace? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).