Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> exp/imp DDL
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
![]() |
![]() |