Home » RDBMS Server » Server Administration » Space Management (10g R2)
Space Management [message #281039] Thu, 15 November 2007 07:55 Go to next message
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: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No fragmentation above all if you use locally managed tablespace.

Previous Topic: how to know the default next_extent, pct_increace on tables?
Next Topic: Oracle Error message ORA:12514 and 12154
Goto Forum:

Current Time: Mon Aug 21 09:07:43 CDT 2017

Total time taken to generate the page: 0.01279 seconds