Database Administration (MOSC)

MOSC Banner

DBMS_METADATA do not format the output in a proper way.

edited Dec 17, 2008 6:05AM in Database Administration (MOSC) 7 comments
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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center