Database partitioning
When a user creates a study in Oracle DMW, he or she must specify a study size of either Small, Medium, or Large for the volume of data expected, relative to other studies. The system uses this value, together with lookup values that you can modify, to determine which database partition to use for storing certain types of data in internal cross-study tables.