05 2012 档案

EXP-00032: Non-DBAs may not export other users
摘要：Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport done in ZHS16GBK characte... 阅读全文
posted @ 2012-05-18 12:01 DB&*NIX 阅读(1519) 评论(0) 推荐(0)
impdp ORA-39125
摘要：处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSORA-39125: 在 KUPW$WORKER.PUT_DDLS 中 Worker 发生意外的致命错误 (在调用 DBMS_METADATA.CONVERT [TABLE_STATISTICS] 时)ORA-06502: PL/SQL: 数字或值错误 LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"ORA-0651 阅读全文
posted @ 2012-05-15 13:37 DB&*NIX 阅读(2364) 评论(0) 推荐(0)
jconsole的配置
摘要：windows:set JAVA_OPTS=-Dcom.sun.management.jmxremote.port=<port> -Dcom.sun.management.jmxremote.authenticate=false-Dcom.sun.management.jmxremote.ssl=falseAIX\Linuxexport JAVA_OPTS="-Dcom.sun.manageme... 阅读全文
posted @ 2012-05-11 05:53 DB&*NIX 阅读(638) 评论(0) 推荐(0)
oracle 组件在DBA_REGISTRY 中显示 invalid
摘要：1. connect to the database as sysdba:sqlplus "/ as sysdba"2. shutdown immediate3. startup upgrade4. spool catalog.log@D:/Ora10gHome/rdbms/admin/catalog.sqlspool off5. spool catproc.log@D:/Ora10gHome... 阅读全文
posted @ 2012-05-10 15:50 DB&*NIX 阅读(1381) 评论(0) 推荐(0)
impdp不创建索引、主外键
摘要：在impdp中追加exclude=index,constraint 阅读全文
posted @ 2012-05-03 16:47 DB&*NIX 阅读(1495) 评论(0) 推荐(0)