DBMS_METADATA.GET_DDL output
1093893.1 says to do things like this to clean up the output of dbms_metadata.get_ddl:
SQL> set long 1000000
SQL> set heading off;
SQL> spool system_indexes.sql
SQL> SELECT DBMS_METADATA.GET_DDL('INDEX',t.index_name) ||';' FROM user_INDEXES t ;
but I find that I am still getting line-end chars and poorly formatted output such as:
CREATE USER "JOE_USER" IDENTIFIED BY VALUES 'S:2
54E4FC3102C59E68236815985FFAA5F3D65E3EF2
D4CD6D193741347B172;3BD2E13EDE585372'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
/
where the values are split over three lines with many blank characters after the readable characters displayed. Is there any way to get the output so it does not require so much manual labor to move a user? I tried some of the variations here:
SQL> set long 1000000
SQL> set heading off;
SQL> spool system_indexes.sql
SQL> SELECT DBMS_METADATA.GET_DDL('INDEX',t.index_name) ||';' FROM user_INDEXES t ;
but I find that I am still getting line-end chars and poorly formatted output such as:
CREATE USER "JOE_USER" IDENTIFIED BY VALUES 'S:2
54E4FC3102C59E68236815985FFAA5F3D65E3EF2
D4CD6D193741347B172;3BD2E13EDE585372'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
/
where the values are split over three lines with many blank characters after the readable characters displayed. Is there any way to get the output so it does not require so much manual labor to move a user? I tried some of the variations here:
0