Home » RDBMS Server » Server Administration » Tablespaces, Oracle
Tablespaces, Oracle [message #61244] Wed, 07 April 2004 06:22 Go to next message
Yass Zoel
Messages: 7
Registered: April 2004
Junior Member
I was wondering if someone can tell me if there is an advantage and/or disadvantages for creating many tablespaces for the same table (backup recovery, performance, administration tasks,..etc).

I have schema who got One huge table (40 GB). This contains 3 years worth of info downloaded every monthy, so far I have 20 tablespaces. The DBA was in charge, was creating a tablespace for the new month and then load that month's data in it. I am leaning towards changing that process and structure, but I thought I'd seek an expert advice. Thanks in advance...

Y-

Report message to a moderator

Re: Tablespaces, Oracle [message #61246 is a reply to message #61244] Wed, 07 April 2004 11:18 Go to previous messageGo to next message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
We can store the data of same table in different tablespace based on range .
Look for table partioning .

Have data files on different disk for each tablespace

Satish Shrikhande

Report message to a moderator

Re: Tablespaces, Oracle [message #61267 is a reply to message #61244] Thu, 08 April 2004 05:57 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Having multiple tablespaces gives you a better control in terms of phyiscal placement of objects.It doesnt mean they are phyiscally separated ,but gives you the option and control to tune them better.

Other benefits might be easy reclaim of space (say when dropping partition), transporting specific objects, high availability during tablespace recovery etc.

But again too many tablespaces(how many depends) might also add to admin efforts.

-Thiru

Report message to a moderator

Re: Tablespaces, Oracle [message #62062 is a reply to message #61246] Wed, 23 June 2004 03:40 Go to previous messageGo to next message
Rizwan Ahmed Siddiqui
Messages: 1
Registered: June 2004
Junior Member
i want to partition the 40 to 45gb of data in to 12 partions, How can i do that, i have the specified data into 2 partioned currently.
plz suggest me.

Report message to a moderator

Re: Tablespaces, Oracle [message #62069 is a reply to message #62062] Wed, 23 June 2004 05:08 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
What is the range field ?
like 1if you have year field then you can got for this
1989 - 1 partition
1990 - 2 partition
1991 - 2 partition
.
.
.
2004 - n partition

This si just an example

Report message to a moderator

Previous Topic: Locking occurring when performing SELECT with ORDER BY
Next Topic: difference between the dictionary and locally managed tablespaces in recovery process
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:25:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.