-
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
tanaw
-
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
-
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
-
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..
tanaw
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|