Shulou(Shulou.com)05/31 Report--

Editor to share with you what is the use of EXP/IMP double quotes, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

There will be case differences when exporting the table, so double quotation marks need to be used.

Restrictions on table names:

1. By default, the database stores uppercase table names. If there are cases where table names are mixed or lowercase, double quotation marks should be used.

two。 You need to use\ escape on some operating systems. Here is an example

Command line:

TABLES='\ "Emp\"

Interactive mode

"Emp"

Parameter file:

TABLES=' "Emp" (single quotation mark plus double quotation mark)

1. Table names cannot have # marks unless double quotation marks are used Similarly, in the parameter file, if the table contains the # sign, the export utility will execute the remaining statements as commands, so if the table name contains the # sign, it is best to add double quotation marks.

For example, if the parameter file contains TABLES= (emp#, dept, mydata), then the # sign is followed by commands and will not be exported correctly. If double quotation marks are added, the export will proceed normally.

It is worth noting that some operating systems only need single quotation marks to exercise the meaning of double quotation marks, different operating systems have different superficial restrictions, we should pay attention to the environment of the operating system.

If you connect as a SYS user, you must specify AS SYSDBA. The operating system may use AS SYSDBA as another command, so double quotation marks may be used.

[oracle@lzl ~] $vi parfile_lzl.txt

[oracle@lzl ~] $cat parfile_lzl.txt

Userid=sys/oracle as sysdba

File=/home/oracle/exp_lzl.dmp

Log=/home/oracle/exp_lzl.log

Tables=scott.emp

Buffer=102400

Rows=y

[oracle@lzl ~] $exp parfile=parfile_lzl.txt

LRM-00112: multiple values not allowed for parameter 'userid'

LRM-00113: error when processing file 'parfile_lzl.txt'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help

EXP-00000: Export terminated unsuccessfully

[oracle@lzl ~] $vi parfile_lzl.txt

[oracle@lzl ~] $cat parfile_lzl.txt

Userid= "sys/oracle as sysdba"

File=/home/oracle/exp_lzl.dmp

Log=/home/oracle/exp_lzl.log

Tables=scott.emp

Buffer=102400

Rows=y

[oracle@lzl ~] $exp parfile=parfile_lzl.txt

Export: Release 11.2.0.3.0-Production on Mon Jul 10 16:50:19 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path...

Current user changed to SCOTT

. . Exporting table EMP 14 rows exported

Export terminated successfully without warnings.

The above is all the content of the article "what is the use of EXP/IMP double quotes". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.