RE: EXP / IMP ISSUE

From: Don Granaman <DonGranaman_at_solutionary.com>
Date: Tue, 14 Jun 2011 15:06:08 -0500
Message-ID: <FD98CB0EE75EEA438CAF4DA2E6071C420EA9364421_at_MAIL.solutionary.com>

exp .... compress=N

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eriovaldo Andrietta Sent: Tuesday, June 14, 2011 2:55 PM
To: ORACLE-L
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-l

Received on Tue Jun 14 2011 - 15:06:08 CDT

This message: [ Message body ]
Next message: Joseph Reid: "Oracle Golden Gate"
Previous message: David Fitzjarrell: "Re: EXP / IMP ISSUE"
In reply to: Eriovaldo Andrietta: "EXP / IMP ISSUE"
Next in thread: Remigiusz Sokolowski: "Re: EXP / IMP ISSUE"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message