Editing results of Import with show=y

In a now-deleted thread in this newsgroup ("Editing dump file before Import??"), Sybrand Bakker pointed out:

>>You should *NEVER EVER!!* edit the dump file. If you want to change

     create tablespace statements, use the following procedure:
     run imp with the following parameters
     show=y full=y log=<anyfilename>
     In <anyfilename> you will find a dump of *all* commands including
     the create tablespace statements. You could easily edit that file, pull
the
     statements out and change them.

I've tried doing this, but the resulting file puts all statements in double quotes. For example:

"CREATE TABLE "TBLJOBS" ("LOTSERIAL" NUMBER(11, 0) NOT NULL ENABLE, "FLD"
"JOB" VARCHAR2(8) NOT NULL ENABLE, "FLDRELATD_INFO" VARCHAR2(50)) PCTFR"
"EE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 10240
NEXT"
" 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST
GROU"
"PS 1 BUFFER_POOL DEFAULT) TABLESPACE "USER_DATA""
. . skipping table "TBLJOBS"
"GRANT DELETE ON "TBLJOBS" TO "MYUSER""
"GRANT INSERT ON "TBLJOBS" TO "MYUSER""
"GRANT SELECT ON "TBLJOBS" TO "MYUSER""
"GRANT UPDATE ON "TBLJOBS" TO "MYUSER""
"ALTER TABLE "TBLJOBS" ADD UNIQUE ("LOTSERIAL") USING INDEX PCTFREE 10 "
"INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1
MAXE"
"XTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
DEFAULT"
") TABLESPACE "USER_DATA" ENABLE"
 After I edit this quoted script, is there a simple way of making SQL*Plus accept it?

Also, why DOES the "Show=y" mode put the results in double-quotes and drop the semicolons at the end of the statements? Received on Wed Jul 19 2000 - 00:00:00 CDT