Maximum Export file size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Maximum Export file size

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,

    I was wondering that on operating systems with a file size limit what will happen if we do a export which is greater than file size limit.

    Can people with VLDB even use oracles export utility .

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If your export file tries to exceed the OS maximum size, it will fail. People on platforms that typically run into this (Unix) will split the export file into multiple pieces (using a named pipe and split/gzip/etc) or have multiple export files and limiting the size of the export file.

    Exporting a VLDB is futile.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by marist89
    split the export file into multiple pieces (using a named pipe and split/gzip/etc)
    How do we do this???

    Originally posted by marist89
    or have multiple export files and limiting the size of the export file.
    Do you mean have multiple export routines which exports the DB schema by schema or table by table. Please confirm.

    Originally posted by marist89
    Exporting a VLDB is futile. [/B]
    why???

    Thanks a lot jeff
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by ronnie
    Originally posted by marist89
    split the export file into multiple pieces (using a named pipe and split/gzip/etc)
    How do we do this???


    There are several examples in these forums. Use http://www.dbasupport.com/forums/search.php and search for split or compress. Also, look at http://www.oracle.com/oramag for several examples.


    Originally posted by marist89
    or have multiple export files and limiting the size of the export file.
    Do you mean have multiple export routines which exports the DB schema by schema or table by table. Please confirm.


    No, I mean using exp with files=a1.dmp, a2.dmp, a3.dmp filesize=2000M ...

    Code:
    C:\>exp help=y
    
    Export: Release 8.1.7.0.0 - Production on Fri Jun 21 11:27:57 2002
    
    (c) Copyright 2000 Oracle Corporation.  All rights reserved.
    
    
    
    You can let Export prompt you for parameters by entering the EXP
    command followed by your username/password:
    
         Example: EXP SCOTT/TIGER
    
    Or, you can control how Export runs by entering the EXP command followed
    by various arguments. To specify parameters, you use keywords:
    
         Format:  EXP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
         Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
                   or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
    
    USERID must be the first parameter on the command line.
    
    Keyword  Description (Default)        Keyword      Description (Default)
    --------------------------------------------------------------------------
    USERID   username/password            FULL         export entire file (N)
    BUFFER   size of data buffer          OWNER        list of owner usernames
    FILE     output files (EXPDAT.DMP)    TABLES       list of table names
    COMPRESS import into one extent (Y)   RECORDLENGTH length of IO record
    GRANTS   export grants (Y)            INCTYPE      incremental export type
    INDEXES  export indexes (Y)           RECORD       track incr. export (Y)
    ROWS     export data rows (Y)         PARFILE      parameter filename
    CONSTRAINTS export constraints (Y)    CONSISTENT   cross-table consistency
    LOG      log file of screen output    STATISTICS   analyze objects (ESTIMATE)
    DIRECT   direct path (N)              TRIGGERS     export triggers (Y)
    FEEDBACK display progress every x rows (0)
    FILESIZE maximum size of each dump file
    QUERY    select clause used to export a subset of a table
    
    The following keywords only apply to transportable tablespaces
    TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
    TABLESPACES list of tablespaces to transport
    
    Export terminated successfully without warnings.
    Originally posted by marist89
    Exporting a VLDB is futile. [/B]
    why???

    Thanks a lot jeff [/B][/QUOTE]
    Why would you want to spend 24 hours exporting a DB? The data will be so inconsistent that it will be wothless.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jun 2002
    Posts
    4
    No just use the filesize parameter in the export utility and in the file option specify multiple files.

    Another good way is to pipe this to gzip or any other zip utility on the fly.

  7. #7
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Another alternative I use (on Unix and some other systems, haven't done it on NT, but it should work) is to export to a tape device. It creates an unlabeled ANSI tape whose size is limited to the tape capacity. (In AIX, most times, use 'file=/dev/rmt0' or something like that.) In theory, that can be 80-100GB or more (depending on the drive.)
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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