| Table Space [message #387000] |
Tue, 17 February 2009 09:49  |
dr46014
Messages: 49
Registered: February 2007
|
Member |
|
|
Hi All
I am working on a datawarehousing environment.Here we have differnet table spaces for different partitioned on a range partitioned FACT table.
Do we need to create different table space for different partitions?How this will help the DBA to manage the things.If a single table space is there and i want to drop say last months partiiton how can i free up spaces if table has a single table space
|
|
|
|
| Re: Table Space [message #387011 is a reply to message #387000] |
Tue, 17 February 2009 10:19  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | How this will help the DBA to manage the things.
|
The answer is in:
| Quote: | .If a single table space is there and i want to drop say last months partiiton how can i free up spaces if table has a single table space
|
It is hard so the help of the first point.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
