how to use dbms_datapump for remaping tablespaces with cursor variables
Hi to all!
I'm trying to create a procedure which will import tables from a production database to a test database using datapump API. Some tables are partitioned with separate tablespaces per partition in production system, while in test all partitions are stored in a single tablespace. So I'm trying to remap the tablespaces to only one when importing into test. I'm trying
DBMS_DATAPUMP.METADATA_REMAP(
handle => h1,
name => 'REMAP_TABLESPACE',
old_value => 'FADJUDATA200708',
value => 'FADJUDATA',
object_type => 'TABLE');
which it works, but cannot use it for more than one partitions, as tablespace are hard-coded this way. So I tried the cursor
I'm trying to create a procedure which will import tables from a production database to a test database using datapump API. Some tables are partitioned with separate tablespaces per partition in production system, while in test all partitions are stored in a single tablespace. So I'm trying to remap the tablespaces to only one when importing into test. I'm trying
DBMS_DATAPUMP.METADATA_REMAP(
handle => h1,
name => 'REMAP_TABLESPACE',
old_value => 'FADJUDATA200708',
value => 'FADJUDATA',
object_type => 'TABLE');
which it works, but cannot use it for more than one partitions, as tablespace are hard-coded this way. So I tried the cursor
0