in+reference+to

有些时候，手头没有官方文档，也不能上网时，遇到一个错误，还挺麻烦的，

还好，安装了ORACLE数据库的机器，自带查错的脚本，就是oerr 。

文件位置在:

[oracle@host01 ~]$ which oerr
/u01/app/oracle/product/19.3.0/db_1/bin/oerr
[oracle@host01 ~]$ ls -ltr /u01/app/oracle/product/19.3.0/db_1/bin/oerr
-rwxr-xr-x 1 oracle oinstall 703 Jan  1  2000 /u01/app/oracle/product/19.3.0/db_1/bin/oerr
[oracle@host01 ~]$
[oracle@host01 ~]$ file /u01/app/oracle/product/19.3.0/db_1/bin/oerr
/u01/app/oracle/product/19.3.0/db_1/bin/oerr: POSIX shell script, ASCII text executable
[oracle@host01 ~]$
[oracle@host01 ~]$
[oracle@host01 ~]$ cat /u01/app/oracle/product/19.3.0/db_1/bin/oerr
#!/bin/sh
#
# $Id: oerr.sh /linuxamd64/4 2011/10/09 12:09:37 pkharter Exp $
# Copyright (c) 1994, 2011, Oracle and/or its affiliates. All rights reserved.
#
# Usage: oerr facility error
#
# This shell script is a driver to invoke oerr.pl using the perl shipped in
# Oracle home.  
#

#
# Turn on script tracing if, requested
[ "$ORACLE_TRACE" = "T" ] && set -x

#
# If ORACLE_HOME is not set, we will not be able to locate
# the facilities file or message text file.
if [ ! "$ORACLE_HOME" ]
then
        echo "ORACLE_HOME not set.  Please set ORACLE_HOME and try again." 1>&2
        exit 1
fi

PERL_DIR=$ORACLE_HOME/perl
PERL_BIN=$PERL_DIR/bin
export PERL_BIN

$PERL_BIN/perl $ORACLE_HOME/bin/oerr.pl "$@"

exit 0


可以看出，是使用PERL写的一段代码，有兴趣的可以去看看。

具体使用，比如我们遇到一个错误，比如引用分区创建报错：

ORA-14652: 不支持引用分区外键
报重庆思庄19c OCP周末班，送大礼包

这个时候，就可以直接使用oerr ora 14652 ,马上就可以看到错误了。


[size=18.6667px][oracle@host01 ~]$ oerr ora 14652
14652, 00000, "reference partitioning foreign key is not supported"
// *Cause:  The specified partitioning foreign key was not supported
//          for reference-partitioned tables. All columns of the
//          partitioning foreign key must be constrained NOT NULL with
//          enabled, validated, and not deferrable constraints. Furthermore,
//          a virtual column cannot be part of the partitioning foreign key.
//* Action: Correct the statement to specify a supported
//          partitioning foreign key.

是不是很方便。

段宽初4687Report作业写作 -
宁农罗17853734955 ______ 在众多的英文论文作业中,最麻烦工作量最大的估计要数Report了,因为Report与其它英文论文最明显的差别就是在文中数据和图表的统计,光是数据统计和制作图标就需要花费留学生们很多时间,更别说还有Report其他部分要写呢,所以当留...

段宽初4687＂in reference to＂是固定搭配吗?怎么用啊? -
宁农罗17853734955 ______ in reference to: 关于,有关 In reference to the interview our representative have with you, we offer to your goodselves our service as shipping- agent. 经本公司代表与您方面洽结果,本公司愿承担为贵公司的船运代理人. He spoke in reference ...

段宽初4687关于英语Report writing怎么写 -
宁农罗17853734955 ______ 1.结构方面:Report一般由Table of Contents, Executive Summary, Introduction, Body, Conclusion/Recommendation, Reference六部分组成.2.语言方面:Report中,如果题目是假如你是某公司CEO或其他某个角色,可以使用第一人称;如果没...

段宽初4687“in book”和“on book”在表示“书里的内容”时有什么区别呢?二者可以互换吗? -
宁农罗17853734955 ______ 介词in一般指事物的内部,on指在某物的上面.表示书里的内容时一般使用in. 只不过这里的“on the books”是一个固定短语,译为“有记载、有案可查”

段宽初4687在会议上为什么不能用in the meeting 呢? -
宁农罗17853734955 ______ 1、在会议上当然可以用in the meeting.它可以表示during the meeting这个时间方面的含义,另外它还有在某个会议室开会的空间方面的含义.这个用法在英语国家里一直都在普遍被使用. 2、表达和它相近含义的介词是at,at the meeting更加强...

段宽初4687Will he know what this is in reference to? 解析 -
宁农罗17853734955 ______ Will he know what this is in reference to?他会知道这个是关于什么的吗?in reference to something 是个成语,意思是参照某事/物.句子成分:Will(助动词) he(主语) know(谓语) what this is in reference to(宾语从句)?宾语从句成分(主系表):what(先行代词,引导从句同时作介词to的前置宾语) this(主语) is(系动词) in reference to(介词短语作表语)

段宽初4687in reference to的同义词 -
宁农罗17853734955 ______[答案] 同义词: about sth concenning sth. 答案二选一即可.

段宽初4687＂in reference to＂是固定搭配吗?Rachel:Oh,God,ask them what they want.Monica:(on phone) Could you please tell me what this is in reference to?＂in ... -
宁农罗17853734955 ______[答案] in reference to:关于,有关 In reference to the interview our representative have with you,we offer to your goodselves our service as shipping- agent. 经本公司代表与您方面洽结果,本公司愿承担为贵公司的船运代理人. He spoke in reference to the ...

段宽初4687indirect reference是什么意思 -
宁农罗17853734955 ______ indirect reference 间接参考 网 络 间接照应 [例句]Syrian officials again blamed armed gangs for the violence an indirect reference to islamists who it claims are trying to ignite sectarian chaos.叙利亚官员再次谴责武装分子制造了骚乱,他间接地指向伊斯兰教主义者,据称他们正试图挑起宗派混战.