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.
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
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
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..
Click Here to Expand Forum to Full Width