Home » RDBMS Server » Server Administration » Space Management (10g R2)
Space Management [message #281039] Thu, 15 November 2007 07:55 Go to next message
hardeys
Messages: 4
Registered: May 2007
Location: India
Junior Member
We have a application which has a reporting DB Schema. This schema is used for developing reports. There is a Process to refresh this schema every night.

This process drops all the tables in the schema and re-creates the tables. I would like to know the impact on space management in table space if this process is used.Does is result in Fragmentation in tablespace ? Any other impact ?
Re: Space Management [message #281052 is a reply to message #281039] Thu, 15 November 2007 09:38 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No fragmentation above all if you use locally managed tablespace.

Regards
Michel
Previous Topic: newbie: total memory for an instance?
Next Topic: howto get the tablespace size and free space?
Goto Forum:
  


Current Time: Mon Dec 05 09:09:59 CST 2016

Total time taken to generate the page: 0.27313 seconds