AWS Data Migration Service - Storage Allocation For Large Empty Table

From: Ethan Post <post.ethan_at_gmail.com>
Date: Wed, 2 Oct 2024 09:01:50 -0500
Message-ID: <CAMNhnU0BDsnxbs5aBtKH6+-i=5T_ze7hOtwUW=AC5+t1qpuSsQ_at_mail.gmail.com>



https://aws.amazon.com/tutorials/move-to-managed/migrate-oracle-to-amazon-rds/

Anyone here know how objects get created in the RDS instance? If I have a 1TB table in the database I am migrating from but it is 50% empty and needs to be rebuilt to recover space (Standard Edition) do I need to do that before migration or does the migration take care of that by starting with a smaller table and growing as the data is migrated? Or is space pre-allocated based on current size to include the empty space?

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 02 2024 - 16:01:50 CEST

Original text of this message