What is the use of EXP/IMP double quotation marks
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!
