tform dependencies maybe?
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/11/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Tables
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/11/2003 06:19 AM
Please respond to ORACLE-L
Subject:RE: Tablespaces - datafiles
LeRoy,
I just struggled with this last week. You can't move Temporary Data
files.
You need t
3/11/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Tablespaces - datafiles
LeRoy,
I just struggled with this last week. You can't move Temporary Data
files.
You need to drop
Title: RE: Tablespaces - datafiles
there
was an old (as in it's now fixed) VxFS bug that sparse files did not actually
free up the space after they were deleted. It will also cause df, du, and
ls to show different values.
Nick
-Original Message-From: Johnston, Tim
[m
2:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Tablespaces - datafiles
When a regular datafile is created, Oracle writes 0s to the blocks.
TEMPORARY files are created as 'sparse
Title: RE: Tablespaces - datafiles
Not on
that machine... Although we do have VxFS here and the behavior is the same
as UFS... As others have pointed out, it is using sparse files for
temporary tablespaces and these can "bite you" if you are not
careful...
Out of
curiosity, w
as
immediately created full size.
Platform dependencies maybe?
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/11/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cies maybe?
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/11/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Tablespa
Title: RE: Tablespaces - datafiles
are you using VxFS?
-Original Message-
From: Johnston, Tim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 11, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tablespaces - datafiles
Create the tablespace and look at it with
When a regular datafile is created, Oracle writes 0s to the blocks.
TEMPORARY files are created as 'sparse' files. Essentially, a header and
footer are created, space is allocated in the file control structures,
but nothing else is written. IIRC, this was introduced in Oracle8i, but
not really
06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Tablespaces - datafiles
LeRoy,
I just struggled with this last week. You can't move Temporary Data
files.
You need to dr
Title: RE: Tablespaces - datafiles
Yes, the ability to create "sparse" tempfiles is platform dependent.
At 11:42 AM 3/11/2003 -0800, you wrote:
>Tom,
>
>Do you have that doc ref handy?
>
>Using this SQL:
>
>create temporary tablespace temp3 tempfile '/u0
To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: Tablespaces - datafiles
>
>
> LeRoy,
>
> I just struggled with this last week. You can't move Temporary Data
> files.
> You need to dro
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Tablespaces - datafiles
LeRoy,
I just struggled with this last week. You can't move Temporary Data
files.
You need to drop and recreate the TEMP tablespace - creating the d
L <[EMAIL PROTECTED]>
cc:
Subject:RE: Tablespaces - datafiles
LeRoy,
I just struggled with this last week. You can't move Temporary Data
files.
You need to drop and recreate the TEMP tablespace - creating the data
files
in the correct directories.
On a side note - here is a
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Tablespaces - datafiles
LeRoy,
I just struggled with this last week. You can't move Temporary Data
files.
You need to drop and recreate the TEMP
Platform dependencies maybe?
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/11/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Tablespa
ACE to this new temporary
tablespace
6. Drop temp1 and remove it's OS files
HTH.
Guang
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of LeRoy
> Kemnitz
> Sent: Tuesday, March 11, 2003 8:39 AM
> To: Multiple recipients of list ORACLE-L
LeRoy,
I just struggled with this last week. You can't move Temporary Data files.
You need to drop and recreate the TEMP tablespace - creating the data files
in the correct directories.
On a side note - here is an interesting feature. When Oracle creates files
for the TEMP tablespace, it does n
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Mercadante,
> Thomas F
> Sent: Tuesday, March 11, 2003 9:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Tablespaces - datafiles
>
.
> Now here is the kicker. Let's say you have a disk that is 9
>
All -
I am having a problem with the datafiles in a temporary tablespace. I
need to move and rename three different datafiles in the tablespace. I
am able to take them offline - no problem. I cna make the changes at
the OS level. I am running on Unix. But I can't get the changes to
show up in
21 matches
Mail list logo
