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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Editing results of Import with show=y

Re: Editing results of Import with show=y

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/07/20
Message-ID: <39771FA3.53CCFD9B@edcmail.cr.usgs.gov>#1/1

If you want to remove the quotes, why not use a text editor that support search and replace? Replace the quotes with a null string. I've done this lots of times and it has never felt like a "brute force edit".

HTH,
Brian

Robert Wagner wrote:
>
> 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?
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

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