EXP-00091处理!

EXP-00091: Exporting questionable statistics.
5 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table NEW_CATEGORY 169 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table NEW_PROJECT^C
EXP-00056: ORACLE error 1013 encountered
ORA-01013: user requested cancel of current operation
. . exporting table NEW_TASK^C
EXP-00056: ORACLE error 1013 encountered
ORA-01013: user requested cancel of current operation
. . exporting table PROJECT_TYPES^C
EXP-00056: ORACLE error 1013 encountered
ORA-01013: user requested cancel of current operation
. . exporting table TASK_TYPES^C
EXP-00056: ORACLE error 1013 encountered
ORA-01013: user requested cancel of current operation
. about to export OPS$ORACLE's tables via Conventional Path ...^C
EXP-00056: ORACLE error 1013 encountered
ORA-01013: user requested cancel of current operation^C^C
EXP-00000: Export terminated unsuccessfully

$ sqlplus /

SQL*Plus: Release 9.2.0.7.0 - Production on Mon Aug 10 14:03:42 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

SQL> select * from v$nls_parameters where
2 parameter='NLS_CHARACTERSET';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
UTF8


SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
$ set NLS_LANG=AMERICAN_AMERICA.UTF8
$ export NLS_LANG=AMERICAN_AMERICA.UTF8
$ exp / file=cpprd_full.dmp full=y


Export: Release 9.2.0.7.0 - Production on Mon Aug 10 14:06:28 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Export done in UTF8 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table AQ$_INTERNET_AGENTS 0 rows exported
. . exporting table AQ$_INTERNET_AGENT_PRIVS 0 rows exported
. . exporting table DEF$_AQCALL 0 rows exported
. . exporting table DEF$_AQERROR 0 rows exported
. . exporting table DEF$_CALLDEST 0 rows exported
. . exporting table DEF$_DEFAULTDEST 0 rows exported
. . exporting table DEF$_DESTINATION 0 rows exported
. . exporting table DEF$_ERROR 0 rows exported
. . exporting table DEF$_LOB 0 rows exported
. . exporting table DEF$_ORIGIN 0 rows exported
. . exporting table DEF$_PROPAGATOR 0 rows exported
. . exporting table DEF$_PUSHED_TRANSACTIONS 0 rows exported
. . exporting table DEF$_TEMP$LOB 0 rows exported
. . exporting table HELP 918 rows exported
. . exporting table LOGSTDBY$APPLY_MILESTONE 0 rows exported
. . exporting table LOGSTDBY$APPLY_PROGRESS
. . exporting partition P0 0 rows exported
. . exporting table LOGSTDBY$EVENTS 0 rows exported
. . exporting table LOGSTDBY$PARAMETERS 0 rows exported
. . exporting table

R语言代码 `exp <- exp[!duplicated(exp$symbol),]` 的作用是**去除数据框 `exp` 中 `symbol` 列存在重复值的行**,仅保留每组重复值中的第一个出现的行。 ### 执行过程解析 1. **`duplicated()` 函数**: - 该函数用于检测数据框或向量中是否存在重复值。 - 在代码中,`duplicated(exp$symbol)` 检测 `exp` 数据框中 `symbol` 列的每个元素是否重复。 - 返回一个逻辑向量,其中 `TRUE` 表示对应位置的值是重复的(即该值在此前已经出现过),而 `FALSE` 表示未重复。 2. **逻辑取反 `!`**: - 对 `duplicated(exp$symbol)` 的结果取反,将 `TRUE` 变为 `FALSE`,`FALSE` 变为 `TRUE`。 - 这意味着原本表示重复的值变为 `FALSE`,非重复的值变为 `TRUE`。 3. **子集选择 `exp[...]`**: - 使用逻辑向量筛选数据框 `exp`。 - `exp[!duplicated(exp$symbol),]` 会返回所有 `symbol` 值唯一的行,即删除了后续重复的行。 4. **赋值操作 `<-`**: -处理后的结果重新赋值给 `exp`,更新数据框内容。 ### 示例 假设原始数据框 `exp` 如下: ```r exp <- data.frame( symbol = c("A", "B", "A", "C", "B", "D"), value = c(10, 20, 30, 40, 50, 60) ) ``` 执行代码后: ```r exp <- exp[!duplicated(exp$symbol),] ``` 结果将是: ```r symbol value 1 A 10 2 B 20 4 C 40 6 D 60 ``` 最终,数据框 `exp` 中只保留了 `symbol` 列的唯一值,去除了后续重复的行。 ### 相关问题 1. 如何在R语言中根据多列去重? 2. R语言中还有哪些方法可以去除数据框中的重复行? 3. `duplicated()` 函数能否用于矩阵或列表?如何使用?
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值