s and extents in PERMANENT tablespaces in
DBA_SEGMENTS
and DBA_EXTENTS. For TEMPORARY tablespaces, query V$SORT_SEGMENT
and V$SORT_USAGE.
If you do have other segments already present in the tablespace, you would
have to
move them out (Export-Drop-Create_in_new_TBS-Import OR Copy-Drop-Rename)
OR
c
The difference between a Contents of TEMPORARY and one of PERMANENT is
that you can create permanent objects (like tables or indexes) in a
tablespace that is considered PERMANENT and you cannot in one that is
considered TEMPORARY.
you need to do the following:
select segment_name, segment_type f
Hi,
I have probably to beg you pardon for my question but I have a very short experince as
an Oracle dba and it is the first time I found a situation like the one I'm going to
describe to you.
Working on an existing Oracle database I found that all users had been defined with an
associated te
From what I've heard, temporary tablespaces based on temporary files locally
managed have the following behavior..
They don't de-allocate extents necessarily, otherwise there would be overhead in
using them again, (just a bitmap after all) (I am using 8.1.7 on AIX 4.3.3)
So questio
s gets flushed (gone) on db bounce.
Also rman full backups ignore these which is a big
plus. these are visible using v$tempfile or
dba_temp_files or somin like that
Deepak
--- "Daiminger, Helmut"
<[EMAIL PROTECTED]> wrote:
> Hi!
>
> I'm getting kinda confused con
t;
<[EMAIL PROTECTED]> wrote: > Hi!
>
> I'm getting kinda confused concerning the two types
> of temporary
> tablespaces:
>
> create tablespace NAME temporary... is the "old" way
> of creating a temporary
> tablespace for sorting purposes. It only allows fo
Title: difference between temporary tablespaces
Hi!
I'm getting kinda confused concerning the two types of temporary tablespaces:
create tablespace NAME temporary... is the "old" way of creating a temporary tablespace for sorting purposes. It only allows for sort
Hi Glen,
There are no disadvantages to using tempfile tablespaces. It should be standard
practice at 8i.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 22 May 2001 8:17
To: Multiple recipients of list ORAC
As long as you do not store perm objects in it, all is well.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/21/01 6:17 PM
Hi Steve,
Is there any disadvantage to using a tempfile tablespace for the TEMP
tablespaces used by the application? Apart from the fact that
From: Glen Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Monday, 21 May 2001 11:15
To: Multiple recipients of list ORACLE-L
Subject: Temporary Tablespaces
I am interested to know what the difference between a tablespace that
is
"created as temporary" and a "temporary tablespac
Hi Glen,
A tablespace created with the CREATE TEMPORARY TABLESPACE command uses tempfiles
instead of datafiles, and as such is often called a "tempfile tablespace". A
tempfile tablespace is equivalent to a locally managed datafile tablespace with
temporary contents, except that tempfiles do not p
Yes, Oracle will completely ignore the tempfile in terms of logging.
You cannot use LMT on a temporary tablespace, but you can do it on a
tempfile. You cannot make a temp file read only or move it which is another
diference with temporary tablespaces (temp files). Control file and
Major differenc is a temporary tablespace does not get logged in the redo
logs, and thus a performance gain on writes.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/20/01 9:15 PM
Greetings to All,
I am interested to know what the difference between a tablespace
Greetings to All,
I am interested to know what the difference between a tablespace that
is "created as temporary" and a "temporary tablespace" is. I am using
8.1.6.3.0.
There are two commands that can be used ...
create tablespace .. temporary;
and
create temporary tablespace ;
According
14 matches
Mail list logo