| Tablespace [message #190509] |
Thu, 31 August 2006 02:24  |
muneeb01
Messages: 1
Registered: August 2006
Location: INDIA
|
Junior Member |
|
|
|
Why exactly is a Tablespace needed? A tablespace may contain 1 or more datafiles, while a datafile belongs to only one tablespace. But what is the purpose of having a logical group of datafiles as a tablespace?
|
|
|
|
|
|
| Re: Tablespace [message #190535 is a reply to message #190517] |
Thu, 31 August 2006 03:38  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
|
"A database is divided into logical storage units called tablespaces, which group related logical structures together. For example, tablespaces commonly group together all application objects to simplify some administrative operations."
|
|
|
|
|
|
| Re: Tablespace [message #190674 is a reply to message #190671] |
Thu, 31 August 2006 12:41 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| goudelly wrote on Thu, 31 August 2006 13:24 |
I mean to say.. the tablespaces cant move one location to other location or backup purpose. The datafiles are in OS level files we can move easly.
|
Not entirely accurate. You can move a tablespace. You'd have to move the underlying o/s physical files and then you'd use the alter database command to "rename" the files to their new location. And then there's transportable tablespaces...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
