Re: EXP / IMP ISSUE
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Tue, 14 Jun 2011 13:04:10 -0700 (PDT)
Message-ID: <246740.19214.qm_at_web65413.mail.ac4.yahoo.com>
Date: Tue, 14 Jun 2011 13:04:10 -0700 (PDT)
Message-ID: <246740.19214.qm_at_web65413.mail.ac4.yahoo.com>
I expect you used the default for compress (which is likely Y); you should explicitly declare compress=N and try your export again. You may find the initial extents more to your liking. David Fitzjarrell ________________________________ From: Eriovaldo Andrietta <ecandrietta_at_gmail.com> To: ORACLE-L <oracle-l_at_freelists.org> Sent: Tue, June 14, 2011 12:55:22 PM Subject: EXP / IMP ISSUE Hello, I would like to get a way to export data withoout storage. STORAGE(INITIAL 400293888 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "xxx" LOGGING NOCOMPRESS. Because the initial extent is too big and I am getting error. The solution can be in exp for do not consider storage when export or when using the Imp in order to do not consider the storage data exported. Note: I used list the DDL via indexfile, but now I need to change all INITIAL that has big value. This is too exaustive, because there are lot of tables. Best Regards Eriovaldo
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 14 2011 - 15:04:10 CDT