DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export to multi-files

  1. #1
    Join Date
    Oct 2000
    Posts
    28
    I want to export my database to multiple dmp files like dbname1.dmp ,dbname2.dmp etc.....Can somebody tell me the export option parameter to do so ??
    Sunil

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    I recently saw a note on Metalink, check it out.

  3. #3
    Join Date
    Sep 2000
    Posts
    384
    yes you can do that.There is a new parameter called filesize .

    filesize limits the size of each dmp file(ex-1024M,512M )
    in file=c:\exp_1.dmp,d:\exp_2.dmp like that you have to mention

    when the file size reaches the limit that is mentioned in the filesize parameter then it will skip to the next mentioned file ..
    it is that simple...
    Radhakrishnan.M

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    In which version it works
    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi,
    It was there prior to 8.1.5 but the size of the file is operating system dependent.
    For 32 bit OS it is 2G
    For 64 bit OS it is unlimited.

    This is from Oracle documentation

    Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name
    specified by the parameter FILE and continues until complete or the maximum value of FILESIZE is again reached. If you do not specify sufficient export filenames to complete the export, Export will prompt you to provide additional filenames.

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