Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Make legible DDL from exported *.dmp file?

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

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 24 Sep 1998 18:11:35 -0500
Message-ID: <6uejj7$t7m$1@garnet.tc.umn.edu>


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
---------------------------------------------------------
Received on Thu Sep 24 1998 - 18:11:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US