In Oracle 12c Release 2 version, Oracle introduced a feature which provided us ability to create partitions on External Tables. In the Oracle 19c version, Oracle introduced a new feature called Hybrid Partitioning which allows us to create some partitions external to database i.e. flat files and some partitions in the tablespace i.e internal to database.
With the help of this feature, we can move less used old partitions to external source i.e. Linux file system and most active partitions in the database.
In this demo, we will create a Hybrid Partitioned Table called DATA with 4 partitions DATA_2019, DATA_2020, DATA_2021 & DATA_2022. Data for year 2019, 2020 & 2021 are stored in flat files in OS directory
These 3 flat files contains data for year 2019, 2020 and 2022 separated by whitespace.
Step 5: Check if the created table DATA is Hybrid partitioned table?
Using this new feature we can move older partitions of a table which are not active to some other cheaper storage outside the database – whereas the active table data remains inside the Oracle database.
Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.