如何把数据库中的视图结构导出来?
我现在用下面语句可以把FUNCTION, PACKAGE BODY,PROCEDURE 的结构(就是代码了)倒出来,可是视图VIEW却不可以.
select TEXT from dba_source where owner='owner_name' and type='type_name' and name='name' order by line;请问要怎么处理?
我现在用下面语句可以把FUNCTION, PACKAGE BODY,PROCEDURE 的结构(就是代码了)倒出来,可是视图VIEW却不可以.
select TEXT from dba_source where owner='owner_name' and type='type_name' and name='name' order by line;请问要怎么处理?
tools——〉Export User Objects,里面FUNCTION, PACKAGE BODY,PROCEDURE,VIEW都可以导出来,简单方便
create or replace view sys.dba_source as
select u.name, o.name,
decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY',
'UNDEFINED'),
s.line, s.source
from sys.obj$ o, sys.source$ s, sys.user$ u
where o.obj# = s.obj#
and o.owner# = u.user#
and o.type# in (7, 8, 9, 11, 12, 13, 14)
union
select u.name, o.name, 'JAVA SOURCE', s.joxftlno, s.joxftsrc
from sys.obj$ o, x$joxfs s, sys.user$ u
where o.obj# = s.joxftobn
and o.owner# = u.user#
and o.type# = 28