aipibang1266-CSDN博客

转载 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 ch...

2012-05-18 12:01:00 176

转载 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...

2012-05-15 13:37:00 295

转载 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="-Dc...

2012-05-11 05:53:00 106

转载 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 off...

2012-05-10 15:50:00 354

转载 impdp不创建索引、主外键

在impdp中追加exclude=index,constraint转载于:https://www.cnblogs.com/rambler/archive/2012/05/03/2480844.html

2012-05-03 16:47:00 961

转载去掉oracle dblink长长的domain 后缀

select * from global_name; update global_name aset a.global_name='&SidName'; SHUTDOWN IMMEDIATE STARTUP select * from global_name; 重建dblink select * from user_db_links;转载于:https://w...

2012-04-25 14:36:00 274

转载分享几本unix书籍和一款远程管理软件

vim 101 hacks Sed and Awk 101 Hacks Linux 101 Hacks TightVNC 转载于:https://www.cnblogs.com/rambler/archive/2012/04/18/2455091.html

2012-04-18 12:07:00 83

转载 expdp fiashback_time 、flashback_scn

在9iexp数据的时候，为保持数据一致性，使用consistent=y参数用expdp 的fiashback_time或flashback_scn 可以实现同样的功能。例如： SELECT to_char(DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER,’9999999999999′) from dual; select current_scn ...

2012-04-13 16:36:00 474

转载 oracle killed会话不释放

一般情况下，在杀一个会话的时候，直接执行alter system kill session ‘sid,serial#’; Administrator's Guide说，当session是active的时候，alter system kill session 只是将session标识为killed 或者pseudo状态，并不会释放session持有的资源，所以我们在执行完alter s...

2012-04-12 11:14:00 189

转载 ORA-01157: cannot identify/lock data file

Wed Apr 11 22:13:53 2012Errors in file d:\oracle\product\10.2.0\admin\sdh\bdump\sdh_dbw0_1552.trc:ORA-01157: cannot identify/lock data file 12 - see DBWR trace fileORA-01110: data file 12: 'C:\...

2012-04-12 09:37:00 77

转载 oracle 重建Listener

1.DOS窗口执行，删除注册表服务 sc delete OracleOraDb10g_home1TNSListenerLISTENER_XXXX 2.用net manager配置listener转载于:https://www.cnblogs.com/rambler/archive/2012/04/11/2442760.html...

2012-04-11 17:52:00 240

转载 ORA-02298: 无法验证 - 未找到父项关键字

@$ORACLE_HOME\RDBMS\ADMIN\utlexcpt.sql;EXCEPTIONS 子句帮助识别违反约束的行TRUNCATE TABLE EXCEPTIONS;ALTER TABLE "SCOTT"."ADDRESS" ADD FOREIGN KEY ("PARENTADDRESSID") REFERENCES "SCOTT"."ARDADDRESS"...

2012-04-10 17:28:00 710

转载 dblink ora-600

select * from dual@dblink ORA-00600: 内部错误代码, 参数: [2252], [2934], [296062546], [], [], [], [], [] 数据库用startup force 方式启动出现上面的错误提示，DBLINK不能用正常启动数据库就可以了 shutdown immediate startup转载于:https://ww...

2012-03-28 17:11:00 320

转载 oracle warp代码加密

oracle 提供了wrap工具加密代码语法如下：wrap iname=input_file oname=output_fileSELECT ascii('D') FROM dual;SELECT ascii(' ') FROM dual;-- create as a text file c: emp\unwrapped.sql CREATE OR REPL...

2012-03-28 14:03:00 136

转载 oracle 如果记录不存在就插入，存在就更新或删除

MERGE <hint> INTO <table_name>USING <table_view_or_query>ON (<condition>)WHEN MATCHED THEN <update_clause>DELETE <where_clause>WHEN NOT MATCHED THEN <insert...

2012-03-26 13:37:00 788

转载用expdp impdp迁移用户

计算schema在原库的空间大小select SEGMENT_TYPE,sum(a.bytes)/1024/1024/1024 from USER_EXTENTS a group by A.SEGMENT_TYPE;建立表空间或扩张新库的表空间CREATE TABLESPACE orcl_index_o1 DATAFILE SIZE 10240M AUTOEX...

2012-03-22 16:54:00 100

转载编译oracle数据库失效对象

$ORACLE_HOME\RDBMS\ADMIN\UTLRP.SQL转载于:https://www.cnblogs.com/rambler/archive/2012/03/22/2411359.html

2012-03-22 11:41:00 62

转载 how to enforce DISTINCT in the sql view for Microstrategy report to remove duplicates

MSTR报表某个报表执行极慢，查看报表SQL，自动加了个distinct,而该报表数据量极大，打开vldb属性，将之前的【使用默认集成值】勾掉，选择【无distinct,无group by】 By default, MicroStrategy considers that the attributes defined are the Primary Key of the resp...

2012-03-16 14:56:00 94

转载 oracle create Force View

Force ... Forces The Creation Of A View Even When The View Will Be Invalid. NoForce Is The Default 强制建立一个view,即使创建后该view失效 SQL> select * from xyz; select * from xyz ORA-00942: 表或视图不...

2012-03-14 13:25:00 1552

转载 oracle ddl 触发器

建立一个日志表CREATE TABLE ddl_log (operation VARCHAR2(30),obj_owner VARCHAR2(30),object_name VARCHAR2(30),sql_text VARCHAR2(64),attempt_by VARCHAR2(30),attempt_dt DATE);在truncate 操作前...

2012-03-14 10:39:00 89

转载 ORA-01775 looping chain of synonyms

在用oracle10g impdp功能的时候提示 ORA-39001: invalid argument valueORA-01775: looping chain of synonyms 用下面的SQL，查出对象已经不存在的同义词，然后删除掉该同义词 SELECT * FROM DBA_SYNONYMS WHERE TABLE_OWNER = '&owner'...

2012-03-14 09:28:00 410

转载 ORA-02429

drop index inx_01 ORA-02429: cannot drop index used for enforcement of unique/primary keyalter table emp drop constraint inx_01 ;drop index inx_01;转载于:https://www.cnblogs.com/ram...

2012-03-12 16:07:00 58

转载 oracle architecture

该图来自:http://kamranagayev.com/2009/08/10/oracle-10gr2-architecture-learn-it-by-heart/转载于:https://www.cnblogs.com/rambler/archive/2012/03/07/2383621.html

2012-03-07 15:22:00 118

转载 oracle 集合操作符

操作符：UNION、描述：组合每个查询返回的所有行，并删除重复行SELECT*FROM emp WHERE deptno=10 UNION SELECT*FROM emp WHERE sal>500操作符：UNION ALL、描述：组合每个查询返回的所有行，并包括重复行SELECT*FROM emp WHERE deptno=10 UNION ALL SELECT*FROM e...

2012-03-07 12:45:00 76

转载 cirtix外网web发布

转载于:https://www.cnblogs.com/rambler/archive/2012/03/01/2375044.html

2012-03-01 09:45:00 79

转载 rman的脚本

先判断flash_recovery_area的利用率，如果超过10%则自动调度rman对日志进行归档AIX Version 6.1,Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi#!/bin/shecho "---------------begin date-------------...

2012-02-21 15:54:00 52

转载 ORA-04030: 在尝试分配 64544 字节 (sort subheap,sort key) 时进程内存不足

做imp导入的时候报这个错误提示SQL> SQL> show parameter sga NAME TYPE VALUE------------------------------------ ----------- -----------------------------...

2012-02-21 09:54:00 491

转载 oracle job 用法小结

新建jobdbms_job.submit(JOB OUT BINARY_INTEGER,WHAT IN VARCHAR2, NEXT_DATE IN DATE DEFAULT SYSDATE, INTERVAL IN VARCHAR2 DEFAULT 'NULL',NO_PARSE IN BOO...

2012-02-21 09:51:00 61

aipibang1266的博客