Home » RDBMS Server » Server Utilities » Re: general information on importing
Re: general information on importing [message #70640] Wed, 10 July 2002 06:10
Grant
Messages: 578
Registered: January 2002
Senior Member
As you create, insert, and drop objects the tablespace (datafile associated with the tablespace) becomes fregmented. The command "SQL> alter tablespace TABLESPACENAME coalesce;" will defragment the data file and coalesce the blocks to make larger contiguous chunks.

Report message to a moderator

Previous Topic: Export utility
Next Topic: EXP-00056 Error while Exporting
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 21:36:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.