Oracle export file size 2 GB Overview

Source: Internet
Author: User

My summary will certainly help you:

2 GB Export File Size

When writing this article, most export versions use the default file processing API to create export files.

. This means that files larger than 2 GB cannot be exported on many platforms.

Here are some ways to overcome them:
Generally, files larger than 2 GB can be exported to bare devices.
You can use named pipes on UNIX to compress/split files.
Can be exported to disk
Oracle8i allows exporting data to multiple files instead of a large file.




Other 2 GB export problems

The maximum extent size of Oracle is 2 GB. Unfortunately

Export has a problem, that is, when compress = y is specified, the next file may be exported

The storage clause may be larger than 2 GB. This causes import

An error occurs.

Compress = y can modify the storage clause initial to specify whether to compress the data segment of the fragment.

To facilitate the use of large extent during reconstruction.

For details about this issue, see [BUG: 708790] and [Note: 62436.1].




Typical 2 GB + export error:
.. Exporting table bigexport
EXP-00015: Error on Row 10660 of table
Bigexport,
Column mycol, datatype 96
EXP-00002: Error in writing to export file
EXP-00002: Error in writing to export file
EXP-00000: Export terminated unsuccessfully


In [BUG: 185855], we also mentioned a problem: Create tablespace generated when the full database is exported

The command uses bytes as the unit. If the data file generated during import is greater than 2 GB

Caused a ora-2237 error.
The solution is to first create a tablespace (replace bytes with m) and then import the file.

Supplement:

The following methods can be taken for an export large file:
1. Bare Device
For example, direct output to/dev/rlvtest.

2. Named Pipe (under UNIX)
Mknod/tmp/imp_pipe P
Compress </tmp/exp_pipe> export. dmp. Z &
Exp file =/tmp/exp_pipe userid = xxx/xxx tables =...

Mknod/tmp/imp_pipe P
Uncompress <export. dmp. z>/tmp/imp_pipe &
IMP file =/tmp/imp_pipe userid = xxx/xxx tables =...

3. Compression/file Splitting: (The following is only valid in KSh :)
Echo | exp file = & gt; (compress | split-B 1024 M-expdmp -)

Userid = xxx/xxx tables =...
Echo | imp file = <(cat expdmp-* | zcat) USERID = xxx/xxx

Tables =...

4. The tape can be directly backed up.
For example, exp file =/dev/rmt0 ....

5. In Oracle8i +, you can use filesize and file to generate inverted

Multiple files.
**************************************** **********************
5. Command Line-full export
  
Exp userid = cams/CAMs @ cams full = y inctype = complete
File = (/tmp/2004020601.dmp,/tmp/2004020602.dmp,/tmp/2004020603.dmp)
Filesize = 2 GB log =/tmp/20040206.log
  
This command completely exports the full database data. The maximum size of each file to be exported to multiple files is 2 GB, and the export process logs are logged.

.
  
Note:
  
(1) When full-Database Export is performed, the incremental export type is (complete) by default.

It is exactly the same.
  
6. Command Line-cumulative Export
  
Exp userid = cams/CAMs @ cams full = y inctype = cumulative
File = (/tmp/2004020601.dmp,/tmp/2004020602.dmp) filesize = 2 GB
Log =/tmp/20040206.log
  
This command cumulatively exports full-database data to multiple files. Each file has a maximum of 2 GB, and the export process record is daily.

Zhi.
  
Note:
  
(1) If you select the incremental export type, you must select full = Y, that is, you can only perform

Full accumulation or incremental export.
  
7. Command Line-incremental Export
  
Exp userid = cams/CAMs @ cams full = y inctype = Incremental
File = (/tmp/2004020601.dmp,/tmp/2004020602.dmp) filesize = 2 GB
Log =/tmp/20040206.log
  
This command cumulatively exports full-database data to multiple files. Each file has a maximum of 2 GB, and the export process record is daily.

Zhi.

 

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.