RE: AWS Data Migration Service - Storage Allocation For Large Empty Table

I’m assuming your target is RDS Oracle and not PostgreSQL or another RDBMS. AWS Data Migration Service is not a block level copy, it’s simply reading and writing the data, row by row, with commit points that you can customize based on your needs.

The target will auto-allocate space as needed, so while you will end up with some space overhead on the target, it will likely be very low (based on your PCTFREE settings on the object).

Thanks,
Scott

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Ethan Post Sent: Wednesday, October 2, 2024 10:02 AM To: oracle-l <oracle-l_at_freelists.org> Subject: AWS Data Migration Service - Storage Allocation For Large Empty Table

***This email is from an external source. Only open links and attachments from a Trusted Sender.***

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?

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. This email and its attachments may collect your personal information to improve Lincoln’s products or to provide you with services related to its products. For more information, please see our privacy policy.<https://www.lincolnfinancial.com/public/general/privacy> Thank You.**

--
http://www.freelists.org/webpage/oracle-l