Tool for managing Oracle database export files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Tool for managing Oracle database export files

  1. #1
    Join Date
    Nov 2001
    Posts
    3
    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

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  4. #4
    Join Date
    Nov 2001
    Posts
    3

    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
  •  


Click Here to Expand Forum to Full Width