Tool for managing Oracle database export files

[tanaw]

Hello

Does anyone know handy tool which can be used for
changing some parameters in database export file ?
I need to change INITIAL EXTENT and NEXT parameters for every table in whole export file in order to minimize database size.

Thanks

[aarroyob]

Hi Tanaw,

I f you OS is a Unix, you could execute the next to make legible your .dmp file:

$ strings export.dmp > export.txt

Then if you edit this file you could change so as you want

Hope this helps

Angel

[aarroyob]

Hi again,

If the OS is Windows, and you would to modify only tables' storage you could make an export with the options rows=no and indexfile=name_of_file (this generate a file in txt with the table code and index)

Then you will be able to modify the tables' sql ...

Try with this

[tanaw]

Thank you aarroyob but that is not what I need..
I'm searching for GUI tool that could let's say -
count up INITIALs and NEXTs for all tables (perhaps grouping by tablespaces) and could change those values by user request (for example, divide by 10) for every or several tables, and could do some more transformations of export file that can be done..
That is my vision of such tool because after some investigation of format of Oracle database export file I think such tool can be easily written..