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 -> exp/imp DDL

exp/imp DDL

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: Sat, 22 Jan 2000 07:15:22 -0500
Message-ID: <86c8d0$dgs$1@bgtnsc01.worldnet.att.net>


When using export/import to capture DDL, it adds quotation marks to it. SQL Plus complains about this. Is there a way to get around this?

Sample Output:

"CREATE TABLE "T" ("X" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRA"
"NS 255 LOGGING STORAGE(INITIAL 524288) TABLESPACE "UTILS""
"CREATE INDEX "DUMMY" ON "T" ("X" ) PCTFREE 10 INITRANS 2 MAXTRANS 255
STOR"
"AGE(INITIAL 524288) TABLESPACE "UTILS" LOGGING"
SQL> "CREATE TABLE "T" ("X" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRA"
unknown command beginning ""CREATE TA..." - rest of line ignored. SQL> "NS 255 LOGGING STORAGE(INITIAL 2048) TABLESPACE "USER"" unknown command beginning ""NS 255 LO..." - rest of line ignored. SQL> "CREATE INDEX "DUMMY" ON "T" ("X" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STOR"
unknown command beginning ""CREATE IN..." - rest of line ignored. SQL> "AGE(INITIAL 524288) TABLESPACE "USER" LOGGING" unknown command beginning ""AGE(INITI..." - rest of line ignored. For a list of known commands enter HELP and to leave enter EXIT. Received on Sat Jan 22 2000 - 06:15:22 CST

Original text of this message

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