select distinct fullclassname from md_class where classtype=206 and id in (select distinct bizInterfaceID from md_bizitfmap where classid ='md_class表中的ID字段值');
2.查询主子查询接口的SQL
select * from md_bizitfmap t where t.bizinterfaceid='md_class表中的ID字段值';
3.后台UI主界面配置的先关参数表
sm_paramregister
4.消息类型表
sm_msg_msgtype
5.同步两个表数据
第一步.建立dblink
create public database link standardbase
connect to nc636_standard_0211 identified by "1"
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 20.10.129.87)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora11g)
)
)';
第二步.插入需要同步的数据
insertinto tb_md_excelfile @standardbase select * from tb_md_excelfile t where t.pk_obj='0001ZA10000000003A7Q'6.oracle表死锁解决
--锁表查询SQL:
SELECT object_name, machine, s.sid,s.serial#
FROM gv$locked_object l, dba_objects o,gv$session s
WHERE l.object_id =o.object_id
AND l.session_id = s.sid;
找到被锁定的表,解锁
复制代码代码如下:
--释放SESSION SQL:
--alter system kill session 'sid, serial#';
ALTERsystem kill session '23, 1647';
7.查找元数据业务接口模块位置
select ownmodule from md_component whereid in(select componentid from md_class where name like '%IBDObject%')
8.缓存相关表
BD_cachetabversion
相关类:TableVersionMonitor
在删除oracle表中某一行数据时,误把表中所有数据删除,可用闪回功能进行数据恢复,步骤如下:
1.执行此语句,若有数据,即可闪回,第一个参数为某个时间点
select * from table_name asof timestamp to_timestamp('2016-03-29 17:15:30','yyyy-mm-dd hh24:mi:ss')
2.闪回数据
flashback table table_name to timestampto_timestamp('2016-03-29 17:15:30','yyyy-mm-dd hh24:mi:ss');
若执行语句报错:表没有开启行移动功能,则执行如下语句
3.开启行移动功能
alter tablebd_refinfo enable row movement;
10.Oracel子树查询
start with v.parentoid=XXX connect by prior v.oid=v.parentoid
//说明:从parentoid=xxx的开始查找,用oid字段和parentoid字段建立父子关系
11.系统增加后台参数表pub_sysinit
pub_sysinittemp