RMAN duplicate partial duplicate with partitioned and subpartitioned tables
have the following issue
I have been asked to clone a subset of a very large database. Sofar nothing tricky and this works fine,
however...this database has a partitioned table with sub partitions spread over multiple tablespaces. some of which have not been cloned across as the requirement was the last few months worth of data.
RMAN clone command was succesful till the last bit where it tried to drop the tablespaces that were skipped. After that the database opened fine but subsequent selects on the table complain about missing datafiles (understandably) but I have no idea how to solve the problem.
I have been asked to clone a subset of a very large database. Sofar nothing tricky and this works fine,
however...this database has a partitioned table with sub partitions spread over multiple tablespaces. some of which have not been cloned across as the requirement was the last few months worth of data.
RMAN clone command was succesful till the last bit where it tried to drop the tablespaces that were skipped. After that the database opened fine but subsequent selects on the table complain about missing datafiles (understandably) but I have no idea how to solve the problem.
0