Rebuilding Indexes and Recreating Partitions. From Old Tbl to New Tbl. Sql Queries!

[graham_o]

you need to run a sqlplus command first in the sqlplus text editor.

SET LONG 999999

then run the select dbms_metadata.... command.