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 ?

Report message to a moderator

Re: Space Management [message #281052 is a reply to message #281039] Thu, 15 November 2007 09:38 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No fragmentation above all if you use locally managed tablespace.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 05:11:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.