-- ---- ---- ---- Ron Reidy Lead DBA Array BioPharma, Inc.
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of Sinardy Sent: Friday, July 01, 2005 4:39 AM To: Mladen Gogala Cc: Oracle-L Subject: Re: Temp tbs with no temp file
But why it allow the tablespace without datafile.
The 10g Concept said:
Databases, tablespaces, and datafiles are closely related, but they have important differences:
* An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data.
* Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.
* A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consisting of two datafiles (for a total of six datafiles).
My situation, seems like a bit different, don't you think so? Or
Regards, Sinardy
-- -- Original Message -- -- From: "Mladen Gogala" < <mailto:gogala@(protected)> gogala@(protected)> To: < <mailto:all_about_oracle@(protected)> all_about_oracle@(protected)> Cc: "Oracle-L" < <mailto:oracle-l@(protected)> oracle-l@(protected)> Sent: Friday, July 01, 2005 6:30 PM Subject: Re: Temp tbs with no temp file
On 07/01/2005 06:15:19 AM, Sinardy wrote:
> Why Oracle allow to have temporary tablespace without the temp file?
Because tablespace is a logical and not a physical structure.
> > What should I do?
Add one.
-- Mladen Gogala Oracle DBA
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><SPAN class=915454814-01072005><FONT face=Arial color=#0000ff size=2>Could this have been a RMAN duplicate?</FONT></SPAN></DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV> <P><FONT face=Arial size=2>-- ---- ---- ----</FONT> <BR><FONT face=Arial size=2>Ron Reidy</FONT> <BR><FONT face=Arial size=2>Lead DBA</FONT> <BR><FONT face=Arial size=2>Array BioPharma, Inc.</FONT> </P> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-- --Original Message-- --<BR><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]<B>On Behalf Of </B>Sinardy<BR><B>Sent:</B> Friday, July 01, 2005 4:39 AM<BR><B>To:</B> Mladen Gogala<BR><B>Cc:</B> Oracle-L<BR><B>Subject:</B> Re: Temp tbs with no temp file<BR><BR></FONT></DIV> <DIV><FONT face=Arial size=2>But why it allow the tablespace without datafile.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>The 10g Concept said:</FONT></DIV> <DIV> <P><FONT face=Arial size=2>Databases, tablespaces, and datafiles are closely related, but they have important differences:</FONT></P> <UL> <LI type=disc> <P><FONT face=Arial size=2>An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data.</FONT></P> <LI type=disc> <P><FONT face=Arial color=#ff0000 size=2>Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.</FONT></P> <LI type=disc> <P><FONT face=Arial size=2>A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consisting of two datafiles (for a total of six datafiles).</FONT></P></LI></UL></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>My situation, seems like a bit different, don't you think so? Or </FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Regards,</FONT></DIV> <DIV><FONT face=Arial size=2>Sinardy</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>-- -- Original Message -- -- </FONT> <DIV><FONT face=Arial size=2>From: "Mladen Gogala" <</FONT><A href="mailto:gogala@(protected)"><FONT face=Arial size=2>gogala@(protected)</FONT></A><FONT face=Arial size=2>></FONT></DIV> <DIV><FONT face=Arial size=2>To: <</FONT><A href="mailto:all_about_oracle@(protected)"><FONT face=Arial size=2>all_about_oracle@(protected)</FONT></A><FONT face=Arial size=2>></FONT></DIV> <DIV><FONT face=Arial size=2>Cc: "Oracle-L" <</FONT><A href="mailto:oracle-l@(protected)"><FONT face=Arial size=2>oracle-l@(protected)</FONT></A><FONT face=Arial size=2>></FONT></DIV> <DIV><FONT face=Arial size=2>Sent: Friday, July 01, 2005 6:30 PM</FONT></DIV> <DIV><FONT face=Arial size=2>Subject: Re: Temp tbs with no temp file</FONT></DIV></DIV> <DIV><FONT face=Arial><BR><FONT size=2></FONT></FONT></DIV><BR><FONT face=Arial size=2>On 07/01/2005 06:15:19 AM, Sinardy wrote:<BR><BR>> Why Oracle allow to have temporary tablespace without the temp file?<BR><BR>Because tablespace is a logical and not a physical structure.<BR><BR>> <BR>> What should I do?<BR><BR><BR>Add one.<BR><BR>-- <BR>Mladen Gogala<BR>Oracle DBA<BR><BR><BR></FONT></BODY><P align=left style="MARGIN-RIGHT: 0px"><FONT face =Tahoma size=2><FONT color=#0000ff> <HR> </FONT></FONT><FONT face=Tahoma size=2><FONT color=#0000ff>This electronic message transmission is a PRIVATE communication which contains information <BR >which may be confidential or privileged. The information is intended to be for the use of the individual <BR>or entity named above. If you are not the intended recipient, please be aware that any disclosure, <BR>copying, distribution or use of the contents of this information is prohibited. Please notify the sender <BR>of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), <BR>and then delete it from your system.</FONT></FONT></P></HTML>
