How large Oracle tablespaces should be?
The Oracle tablespaces should be as large as the ds files from where the data is exported from, although in practice the tablespaces won’t grow that large. Special attention should be payed to the UNDO tablespace. When replicating data, the UNDO tablespace should be large enough to store the records from the largest collection being replicated. When synchronising it should be large enough to hold all the data changed since the last synchronisation.
