dbms_metadata set_remap_param tablespace

From: Ronald Rood <devnull_at_ronr.nl>
Date: Sun, 22 Apr 2007 22:19:55 +0200
Message-ID: <0001HW.C251900B0064AF6CF0182648@news.individual.net>

Hi,

I must be missing something but fail to see what ... When I try to use the remap tablespace transformation I get the ddl returned without tablespace assignment instead of what I was hoping for, the new value for the tablespace that I tried to remap the table to.

Does anybody know of simple example that shows how to use this ? I already lost my hair ... ;-)

objectOpenHandle := dbms_metadata.open(object_type => object.type, network_link => 'bron');
dbms_metadata.set_filter(objectOpenHandle,'NAME',object.name); dbms_metadata.set_filter(objectOpenHandle,'SCHEMA',object.owner); objectTransHandle:=dbms_metadata.add_transform(objectOpenHandle,'DDL'); dbms_metadata.set_remap_param(objectTransHandle,'TABLESPACE',

                    object.remap_from, object.remap_to);

objectDDLs := dbms_metadata.fetch_ddl(objectOpenHandle);

Here objectDDLs(1).ddltext contains sql of the table but has no tablespace. Without the set_remap_param it shows the complete ddl, including tablespace.

--
With kind regards / met vriendelijke groeten,
Ronald

http://ronr.blogspot.com/
http://ronr.nl/unix-dba

Received on Sun Apr 22 2007 - 15:19:55 CDT