Everything in the schema on Server B is dropped before import, so I have an empty schema to begin with. I am not sure I understand what you meant by "dropping the indexes before import"? Did you mean export/import indexes separately? I guess I could do that. Right now I just try to keep the program simple because the time is not an issue. I just want to know if there is an "easy and simple" way to increase the imp speed without changing the program too much.
Guang > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Ron Thomas > Sent: Tuesday, May 27, 2003 1:50 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: would imp speed affect by setting indexes to NOLOGGING? > > > > Have you considered dropping the indexes before import, then > rebuilding parallel nologging? > > Ron Thomas > Hypercom, Inc > [EMAIL PROTECTED] > Each new user of a new system uncovers a new class of bugs. > -- Kernighan > > > > > > [EMAIL PROTECTED] > > > Sent by: To: > [EMAIL PROTECTED] > > [EMAIL PROTECTED] cc: > > > Subject: > would imp speed affect by setting indexes to NOLOGGING? > > > > > 05/27/2003 11:19 > > > AM > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > Hi, > > Would the imp speed increase by setting all indexes to NOLOGGING? > > I have a schema with 249 tables and 442 indexes and I have a > weekly schema > refresh program running as this: > > exp schema from Server A (Oracle 8173 on Sun Solaris box) > ftp dump file from Server A to Server B, the dump file size > is 1.9GB after > compression > imp schema on Server B (also Oracle 8173 on Sun Solaris box), the imp > usually take about 7 hours. > > With everything elase the same, last week I changed all indexes in the > schema on Server A to "NOLOGGING" (they were all set to > "logging" before), > hoping to increase the speed of imp on Server B. Because I thought the > "create index ... nologging" would reduce redo log writing, therefore > increase the imp speed quite a bit (there are some big > indexes there!). But > this morning I found the imp still took about the same time as before, > although I was told that the system I/O seems to be lower. > > Does anyone have similar experience? TIA. > > Guang > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: gmei > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ron Thomas > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
