how can we dynamically import only last four partitions of the Table ?
The Requirement is like this.
We take full export of a schema using expdp. There's one Huge Partition Table in the schema which gets new partitions periodically. We need to import this in another Database (rest of the tables) and the partitioned table with their latest last four partitions. We need to automate this and have to write a script so that it should pick up dynamically the last four partitions and Import the Table.
Is it possible ?
Can we import it using the QUERY option of impdp and querying the dba_tab_partitions ?
Any help would be greatly appreciated.