Home » RDBMS Server » Server Administration » Table Space (UNIX Oracle 10g)
Table Space [message #387000] Tue, 17 February 2009 09:49 Go to next message
dr46014
Messages: 48
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 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: How do you patch several databases in intermediate stages?
Next Topic: Objecttype ' JOB' (merged)
Goto Forum:
  


Current Time: Fri Dec 02 14:02:00 CST 2016

Total time taken to generate the page: 0.15147 seconds