From: Sreejith S Nair <>
Date: Wed, 15 Jun 2011 15:00:51 +0530
Message-ID: <>

if you are using datapump you can use TRANSFORM:SEGMENT_ATTRIBUTES:n

Default: none
Enables you to alter object creation DDL for specific objects, as well as for all
applicable objects being loaded.
Syntax and Description
TRANSFORM = transform_name:value[:object_type]

The transform_name specifies the name of the transform. The possible options are
as follows:
■ SEGMENT_ATTRIBUTES - If the value is specified as y, then segment attributes
(physical attributes, storage attributes, tablespaces, and logging) are included,
with appropriate DDL. The default is y.

From: Remigiusz Sokolowski <> To: <>
Date: 06/15/2011 12:37 PM

Subject:        Re: EXP / IMP ISSUE
Sent by:

W dniu 14.06.2011 21:55, Eriovaldo Andrietta pisze:
> Hello,
> I would like to get a way to export data withoout storage.
> 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
> 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

Assuming imp/exp only (and not data pump) then, not remember well, but the key is first to create empty table without any constraints or indexes or rows. I think I used for it exp/imp as well and with rows=N the definition was different, but not sure at the moment, it was few years ago - if that will not work You may build this table manually by pulling out a definition with dbms_metadata. Then set parameter IGNORE=Y and imp loads to already existing table so no problem with previous storage settings.

Data pump is much more convenient with such manipulations, but suppose You have no such option

Pole nakazi

Remigiusz Sokolowski <>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77

Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia,

wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828,
dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku,
VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711--

DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."

Received on Wed Jun 15 2011 - 04:30:51 CDT

Original text of this message