51CTO博客开发
测试环境一段sql，无法跑出结果，在生产环境同样的sql，秒出，后来发现select后面的自定义函数对应的包失效，尝试重新编译包，无法编译。找到锁住的包的会话，全部杀掉，重新编译。SELECT 'alter system kill session ' || '''' || sid || '
--case when 的行转列select e.job as "工作"，case e.deptno when 10 then sal end as " 部门 10 工资",case e.deptno when 20 then sal end as "部门 20 工资",case e.deptno when 30 then sal end as "部门 30 工资",e.sal as
--Join Predicate Pushdowncreate table emp1 as select * from scott.emp create table emp2 as select * from scott.emp create index idx_emp1 on emp1(empno);create index idx_emp2 on emp2(empno);create or r
--标量子查询select e.empno, e.ename, e.sal, e.deptno, (select d.dname from dept d where e.deptno = d.deptno)as dname from emp e--插入一条数据insert into emp(empno,deptno
Can this feature be disabled without administrative access?Yes. This can be done by deleting any previously downloaded versionlist.xml files and instructing IE to stop updating the XML file. This can
oracle ASM替换存储和主机：1.在新的主机当安装单机GRID,和数据库软件，可以从源主机上拷贝，然后克隆操作2.把新的存储挂在旧的主机上，建立新的磁盘组，用back as copy 把数据库备份到新的磁盘组上，然后新的存储从旧的主机上取消映射，3.把旧的OCR 导出，并导入新的主机上，./ocrconfig -export /tmp/033_asm.ocr./ocrconfig -expo
copy 备份：[oraprod@ebsprod ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 20 11:28:50 2016 Copy
把EBS 数据库从11.1.0.7升级到11.2.0.4后，无法登陆[oraprod@ebsprod PROD_ebsprod]$ sqlplus / as sysdbaERROR:ORA-01804: failure to initialize timezone informationSP2-0152: ORACLE may not be functioning properlyFIX:####
修密码前一定备份一下，SQL> create table fnd_user_20160614 as select * from fnd_user;Table created.SQL> create table fnd_oracle_userid_20160614 as select * from fnd_oracle_userid; Table created.如果修改失败
SELECT REQUEST_ID, a.user_name, f.ACTUAL_START_DATE DATE_STARTED, DECODE(TRUNC(sysdate - ACT
yum install gcc \glibc \glibc-common \glibc-devel \glibc-devel \libgcc \libgcc \libstdc++ \libstdc++ \libstdc++ \libstdc++ \make \gdbm \gdbm \libXp \libXp \libaio \libaio \libgomp \sysstat \util-linux
--创建用户DECLAREv_user_name VARCHAR2 (100) := upper('&Enter_User_Name');v_description VARCHAR2 (100) := 'NEW Test User';BEGIN fnd_user_pkg.createuser(x_user_name => v_user_name, x_owner
http://blog.delphix.com/ron/2014/06/18/oracle-ebs-r12-2-install/ http://appsdbaworkshop.blogspot.com/2013/10/oracle-applications-r122-installation.html
首先，通过 select userenv('language') from dual;SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252查询oracle服务器端的编码， 如为： SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252 显示什么编码 就设置什么编码 在我们的客户端需要和服务器端的编
-查看EBS用户的所有职责：SELECT frt.responsibility_name, furg.END_DATE FROM fnd_user_resp_groups furg, fnd_responsibility fr, &n
AIX上用tar更换java版本的时候发生此问题，但ps -ef检查后并未发现相关进程。用”slibclean”命令清一下系统的动态库 搞定！由于netback空间增长，无法找到具体的文件，服务器上有oracle数据库。可以执行slibclean清除，释放空间
--row_numberSELECT ename, deptno, rownum, row_number() over(ORDER BY deptno) rn, rank() over(ORD
--测试数据create table test as select * from dba_objects;insert into test select * from test;--查看是否有重复数据select * from test order by object_id;--用rowid删除select rowid,a.* from test a order by object_id;--根据
1.[root@sf01 ~]# cat /etc/sysconfig/networkNETWORKING=yesHOSTNAME=sf01[root@sf01 ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1
备库出现这个错误： Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.128.10)(PORT=49295))WARNING: inbound connection timed out (ORA-3136)由于主库修改了OS的密码，没有重新生成orapwdxxx。。
配置好主库参数文件：添加：*.log_archive_config='DG_CONFIG=(CWFOL,CWFOLB)'*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CWFOL'*.log_archive_dest_2='SERVI
blacklist { devnode "^sdk"}defaults { user_friendly_names no}multipaths { multipath { wwid 360080e50002c8e94000014a356a18b17&nbs
编辑eth0DEVICE=eth0TYPE=EthernetONBOOT=yesMASTER=bond0SLAVE=yesBOTTPROTO=none编辑eth1DEVICE=eth1ONBOOT=yesMASTER=bond0SLAVE=yesBOTTPROTO=none编辑bond0DEVICE=bond0BOOTPROTO=staticIPADDR=10.10.128.13NETMASK=2
[root@aix /]# mpio_get_config -AvFrame id 0: Storage Subsystem worldwide name: 608e5002c57fe0000513fe561 Controller count: 2 Partition count: 1&nb
[root@cwerp home]# df -hdf: `/mnt': Stale file handleFilesystem Size Used Avail
SQL> drop user a cascade; drop user a cascade * ERROR 位于第 1 行: ORA-01940: 无法删除当前已连接的用户解决方法:SQL>
select 'alter table '||table_name||' move tablespace rpt;' from user_tables;select 'alter index '||index_name||' rebuild tablespace RPT_IDX;' from user_indexes;CREATE OR REPLACE PROCEDURE BATCH_REBUIL
SELECT 'EDCRAWDATA' AS TABLE_NAME, SUM(size_gb) AS TOTAL_GB FROM (SELECT a.owner,
准备参数文件：[oracle@erpdev ~]$ cat pfileCWERPDB.ora CWERPDB.__db_cache_size=8959033344CWERPDB.__java_pool_size=67108864CWERPDB.__large_pool_size=100663296CWERPDB.__oracle_base='/home/u0
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
