Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Make legible DDL from exported *.dmp file?
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, ""
--
Phone: (612)626-7135 Fax: (612)625-6853 ---------------------------------------------------------Received on Thu Sep 24 1998 - 18:11:35 CDT