Shulou(Shulou.com)06/01 Report--

When using exp, you should pay attention to the following points

The current client version, the target client version, note that you need to set the character set, that is, NLS_LANG

Refer to the settings of the oracle character set

The NLS_LANG format is:

[NLS_LANGUAGE] _ [NLS_TERRITORY]. [NLS_CHARACTERSET].

NLS_LANGUAGE refers to the language used by Oracle messages, showing the month and day in the date.

NLS_TERRITORY refers to the ratio of goods and the format of numbers, regions, and the habit of calculating days and dates.

NLS_CHARACTERSET refers to the character set that controls the use of client applications

Select* from nls_database_parameters

Such as: NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

SQL > SELECT USERENV ('language') FROM DUAL

USERENV ('LANGUAGE')

AMERICAN_AMERICA.ZHS16GBK

Http://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreInstall18.html

Logical derivation

Exp user1/password@db1 file=TABLE1.dmp log=TABLE1.log

Tables=table1 buffer=10485760 constraints=n compress=n statistics=none

Indexes=n triggers=n grants=n

1. Table schema export

Exp hr/hr file=hr.dmp tables=employees,locations log=hr.log

Exp hr/hr file=hr.dmp tables=\ (employees,locations\) log=hr.log

Exp hr/hr file=hr.dmp tables=scott.emp log=scott.log

(exp_full_database permission required)

Grant exp_full_database to hr

two。 User mode export

Exp hr/hr file=hr_all.dmp owner=hr log=hr_all.log

Exp hr/hr file=hr_scott.dmp owner=\ (hr,scott\) log=hr_scott.log

3. Database schema export

Exp_full_database permission is required)

Exp hr/hr file=full.dmp full=y log=full.log

4. Transferable tablespace mode

To be replenished

Other parameters use:

Do not export indexes, constraints, authorizations, and triggers

Exp hr/hr file=all.dmp indexes=n constraints=n grants=n triggers=n

File size limit estimate the size of the exported data

Select sum (bytes) / 1024 Universe 1024 from user_segments

The expected exported dmp file size cannot exceed the system limit (fat32 single file cannot exceed 4G fat32 NTFS single file cannot exceed 2T Magi ext3 ideally cannot exceed 2T)

Exp hr/hr file=limits1.dmp,limits2.dmp filesize=2048M log=limits.log

Exp hr/hr file=limits1.dmp,limits2.dmp filesize=130K log=limits.log

If you specify the size of filesize, you must specify a file name for the file parameter, separated by commas. If more files are specified than are actually generated, extra files will not be generated. If it is less than the actual generated file, you will be prompted to enter a new file name during the export process, such as Export file: expdat.dmp >

Parameter file usin

Cat parameter.txt

Userid=scott/tiger

File=scott.dmp

Tables=emp

Log=scott.log

Exp parfile=parameter.txt

Export according to condition

Cat parameter.txt

Userid=scott/tiger

File=scott.dmp

Tables=emp

Query='whereempno = 7369'

Log=scott.log

Exp parfile=parameter.txt

Or

Exp scott/tiger file=scott.dmp tables=emp query= "'where empno=7369'" log=scott.log

A string exists in the condition

Cat parameter.txt

Userid=scott/tiger

File=scott.dmp

Tables=emp

Query='wheresal < 8000 and job =''SALESMAN'''

Log=scott.log

Exp parfile=parameter.txt

Export only table structure

Expscott/tiger file=scott.dmp rows=n owner=scott log=scott.log

Direct parameter

If there is blob,clob in the exported object, the direct path export will report an error.

8iGrade9i pays special attention to the fact that direct=y is generally added to a single table, and the direct method is generally not used according to the user or database.

Individuals in the use of the general use of system to operate.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.