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

Thread: export 2 gig limit

  1. #1
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    I want to find out if we have a 2 gig limit on export files in
    8.1.7 (32 bit) Oracle version
    I know it is not there for 8.1.6(64 bit)

    Please let me know this is urgent
    KN

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    This limit is the reason of your OS being 32-bit. Not oracle.
    If your OS is 64-bit you do not have this limitation.
    svk

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    If your Oracle is installed on NT platform, yes 2G, on most Unix platforms 64G.


  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by julian
    If your Oracle is installed on NT platform, yes 2G, on most Unix platforms 64G.
    How's that? I have daily export on one of our NT box exceeding 35 GB in one pice....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    How's that? I have daily export on one of our NT box exceeding 35 GB in one pice....
    At the time of writing most versions of export use the default file open API when creating an export file. This means that on many platforms it is impossible to export a file of 2Gb or larger to a file system file.

    There are anyhow several options available to overcome 2Gb file limits with export.




  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Well, AFAIK on NT "by default" you are not limited to 2GB size for export, at least if you are storing to NTFS formated volume. There is no special option you have to enable for that on the OS level, you get that by default...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Apr 2001
    Posts
    108

    Export files > 2 Gbytes

    JModic,

    Can you read from your 35 Gbyte export file? When I was a young dba (can that really happen?) I was using export for my backups and I thought everything was ok. I had one database that would create a 3 Gbyte .dmp file in Unix. I thought everything was ok until I tried to restore one night and couldn't read any of the export files. Called Oracle and they told me that even though Oracle would create the export file > 2 Gbytes, import could not read it on my version of Oracle/Solaris. Just an FYI.
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Thanks for the warning, but on NT there is no such isue. I've read huge (>2GB) export files many times on many different releases, never had any problem...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jmodic
    Thanks for the warning, but on NT there is no such isue. I've read huge (>2GB) export files many times on many different releases, never had any problem...
    Yes, I recently read that .dmp > 2G is rather an Unix issue (which could be solved anyway).

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