Re: Make legible DDL from exported *.dmp file?

From: <jtesta_at_my-dejanews.com>
Date: Fri, 25 Sep 1998 12:51:33 GMT
Message-ID: <6ug3kl$rbi$1@nnrp1.dejanews.com>

I've been toying with the idea, but figured someone out there already did it.

So if anyone has, please speak up, or maybe i'll take up the challenge, writing drop column was a good experience, this might be one also.

joe
http://www.oracle-dba.com

In article <6uejj7$t7m$1_at_garnet.tc.umn.edu>, hause011_at_garnet.tc.umn.edu (Steven Hauser) wrote:
> So nobody in the Unix world using Oracle has ever written a pretty printer
> for the double quote polluted, token chopped DDL spew that comes from an
> oracle export utility?
>
> Example from the stuff that is PeopleSoft:
> "CREATE TABLE "PS_CRSE_OFFER" ("CRSE_ID" VARCHAR2(6) NOT NULL, "EFFDT" DATE "
> ", "CATALOG_NBR" VARCHAR2(10) NOT NULL, "COURSE_APPROVED" VARCHAR2(1) NOT NU"
> "LL, "CAMPUS" VARCHAR2(5) NOT NULL, "SCHEDULE_PRINT" VARCHAR2(1) NOT NULL, ""
> "CATALOG_PRINT" VARCHAR2(1) NOT NULL, "SCHED_PRINT_INSTR" VARCHAR2(1) NOT NU"
> "LL, "ACAD_ORG" VARCHAR2(10) NOT NULL, "ACAD_CAREER" VARCHAR2(4) NOT NULL, ""
>
> --
>
> ---------------------------------------------------------
> Steven Hauser, hause011_at_tc.umn.edu
> Phone: (612)626-7135
> Fax: (612)625-6853
> ---------------------------------------------------------
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 25 1998 - 07:51:33 CDT