Home » RDBMS Server » Server Administration » Tablespace
Tablespace [message #190509] Thu, 31 August 2006 02:24 Go to next message
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 #190517 is a reply to message #190509] Thu, 31 August 2006 02:48 Go to previous messageGo to next message
aorehek
Messages: 52
Registered: August 2006
Member
Oracle database

[Updated on: Thu, 31 August 2006 02:52]

Report message to a moderator

Re: Tablespace [message #190535 is a reply to message #190517] Thu, 31 August 2006 03:38 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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 #190671 is a reply to message #190509] Thu, 31 August 2006 12:24 Go to previous messageGo to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

The tablespace is logical storage structure of oracle database with a set of datafiles. For ex: Your tablespace is containig the data in GB's or TB's and you want to take the cold backup .. Then you have to take the tablespace begin backup mode take the datafiles backup.

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.

Thanks,


Re: Tablespace [message #190674 is a reply to message #190671] Thu, 31 August 2006 12:41 Go to previous message
joy_division
Messages: 4640
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...
Previous Topic: deleting records
Next Topic: Oracle 10g/Fedora Core 4 - Error creating database
Goto Forum:
  


Current Time: Sun Dec 04 04:26:14 CST 2016

Total time taken to generate the page: 0.09921 seconds