DBMS_METADATA do not format the output in a proper way.
RDBMS Version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
Operating System and Version : Windows 2003 server
DBMS_METADATA formats output wrong
Hi.
When i am trying to extract ddl with dbms_metadata.get_ddl then some of the create table statments got wrong format. It is global temporary tables i am extracting. Either it wrap over to a new row or it "jumps" over a hole row and then the statement is unusable. This happens for some of the tables and not for other. My guess is that the string/line is to long. The "Create" statement in combination with "global temporary table" makes it too long. The name of the table is not too long (of course).
Operating System and Version : Windows 2003 server
DBMS_METADATA formats output wrong
Hi.
When i am trying to extract ddl with dbms_metadata.get_ddl then some of the create table statments got wrong format. It is global temporary tables i am extracting. Either it wrap over to a new row or it "jumps" over a hole row and then the statement is unusable. This happens for some of the tables and not for other. My guess is that the string/line is to long. The "Create" statement in combination with "global temporary table" makes it too long. The name of the table is not too long (of course).
0