use dbms_metadata to change compression

[jaxtell]

Hi,
I'm trying to use the dbms_metadata package to make a copy of a table, changing only the name and the compression. I want to change "compress for oltp" to "compress for query low parallel". Can I do this with dbms_metadata, or is there another way to do it?

Thanks

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[Dagon]

Can't you just get the create table statement from dbms_metadata and then do a REPLACE(<table script>, 'compress for oltp', compress for query low parallel') on it?

For Oracle-related work, contact me through Linked-In.

 

[jaxtell]

Yes, and that is my current strategy. But it seems more like a hack than the right way to do it.

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/