| temfile & datafile [message #62775] |
Thu, 12 August 2004 23:22  |
soumya
Messages: 9
Registered: April 2004
|
Junior Member |
|
|
hi
what the difference between tempfile and datafile.
while we creating temporary tablespace in 8i we use datafile
clause in creating temporary tablespaces.but what exact difference
between tempfile and datafile
|
|
|
|
| Re: temfile & datafile [message #62778 is a reply to message #62775] |
Fri, 13 August 2004 01:47  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Tempfile and Datafile are the OS files which are actualy bind with a temporary tablespace in oracle. While creating a dictionary managed temporary tablespace, you have to use DATAFILE clause to specify the files and while creating locally managed temporary tablespace you have to use TEMPFILE clause to specify the files.
For more info about dictionary managed and locally managed tablespaces refer oracle doc.
Daljit Singh
|
|
|
|
| Re: temfile & datafile [message #62781 is a reply to message #62778] |
Fri, 13 August 2004 03:46 |
soumya
Messages: 9
Registered: April 2004
|
Junior Member |
|
|
i know about it but is there any
diffeence internally in datafile and tempfile
cos i migrated to dictionary to local and while creating unique index i got error that why i recreated
with tempfile
any difference
with
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
