Create and populate two tables in the test schema. GRANT CREATE SESSION, CREATE TABLE TO reclaim_user ![]() Create a tablespace and user for the test.ĭROP TABLESPACE reclaim_ts INCLUDING CONTENTS AND DATAFILES ĬREATE TABLESPACE reclaim_ts DATAFILE '/u01/app/oracle/oradata/DB11G/reclaim01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M ĬREATE USER reclaim_user IDENTIFIED BY reclaim_user DEFAULT TABLESPACE reclaim_ts QUOTA UNLIMITED ON reclaim_ts Each of the solutions presented require that this setup is done first. Setup Test Environmentīefore we can look at the solutions we need to create a test environment so we can clearly see the problem. You should *always* take backup before doing any structural changes to databases you care about. Remember, reorganising a tablespace is a big structural change. I consider this type of action a one-off task when something significant has happened in the tablespace. In many cases the space will be used as segments in the tablespace continue to grow. I do not advise reorganizing tablespaces every time a bit of free space appears. Enterprise Manager Tablespace Reorganization.In this article I will discuss a few of the ways of reclaiming this unused space. One or more segments (tables, partitions or indexes) have been moved to another tablespace leaving empty areas in the datafiles that previously held them.After the data is pruned the datafiles contain unused space that needs to be reclaimed. A lack of housekeeping/maintenance means that one or more tables have grown excessively. ![]() There are a number of scenarios that can lead to unused space in datafiles. Home » Articles » Misc » Here Reclaiming Unused Space in Datafiles
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |