没有合适的资源?快使用搜索试试~ 我知道了~
解决10g exp不能导出9i数据库的问题
5星 · 超过95%的资源 需积分: 10 107 下载量 143 浏览量
2009-09-13
21:23:00
上传
评论
收藏 27KB TXT 举报
温馨提示
试读
17页
解决10g exp不能导出9i数据库的问题 解决10g exp不能导出9i数据库的问题
资源推荐
资源详情
资源评论
Rem this patch is release by eygle
Rem use to Oracle9i database to solve 10g export can not export Oracle9i database error
Rem this patch is only use to education purpose
Rem before you apply this patch to your product database
Rem rememeber Do a full test
Rem I have test this patch on Oracle9.2.0.3 and Oracle9.2.0.4.
CREATE OR REPLACE VIEW exu9rls (
objown, objnam, polgrp, policy, polown, polsch, polfun, stmt,
chkopt, enabled, spolicy) AS
SELECT u.name, o.name, r.gname, r.pname, r.pfschma, r.ppname,
r.pfname,
DECODE(BITAND(r.stmt_type, 1), 0, '', 'SELECT,') ||
DECODE(BITAND(r.stmt_type, 2), 0, '', 'INSERT,') ||
DECODE(BITAND(r.stmt_type, 4), 0, '', 'UPDATE,') ||
DECODE(BITAND(r.stmt_type, 8), 0, '', 'DELETE,'),
r.check_opt, r.enable_flag,
DECODE(BITAND(r.stmt_type, 16), 0, 0, 1)
FROM sys.user$ u, sys.obj$ o, sys.rls$ r
WHERE u.user# = o.owner# AND
r.obj# = o.obj# AND r.ptype is null AND
(UID IN (o.owner#, 0) OR
EXISTS (
SELECT role
FROM sys.session_roles
WHERE role = 'SELECT_CATALOG_ROLE'))
UNION
SELECT u.name, o.name, r.gname, r.pname, r.pfschma, r.ppname,
r.pfname,
DECODE(BITAND(r.stmt_type, 1), 0, '', 'SELECT,') ||
DECODE(BITAND(r.stmt_type, 2), 0, '', 'INSERT,') ||
Rem use to Oracle9i database to solve 10g export can not export Oracle9i database error
Rem this patch is only use to education purpose
Rem before you apply this patch to your product database
Rem rememeber Do a full test
Rem I have test this patch on Oracle9.2.0.3 and Oracle9.2.0.4.
CREATE OR REPLACE VIEW exu9rls (
objown, objnam, polgrp, policy, polown, polsch, polfun, stmt,
chkopt, enabled, spolicy) AS
SELECT u.name, o.name, r.gname, r.pname, r.pfschma, r.ppname,
r.pfname,
DECODE(BITAND(r.stmt_type, 1), 0, '', 'SELECT,') ||
DECODE(BITAND(r.stmt_type, 2), 0, '', 'INSERT,') ||
DECODE(BITAND(r.stmt_type, 4), 0, '', 'UPDATE,') ||
DECODE(BITAND(r.stmt_type, 8), 0, '', 'DELETE,'),
r.check_opt, r.enable_flag,
DECODE(BITAND(r.stmt_type, 16), 0, 0, 1)
FROM sys.user$ u, sys.obj$ o, sys.rls$ r
WHERE u.user# = o.owner# AND
r.obj# = o.obj# AND r.ptype is null AND
(UID IN (o.owner#, 0) OR
EXISTS (
SELECT role
FROM sys.session_roles
WHERE role = 'SELECT_CATALOG_ROLE'))
UNION
SELECT u.name, o.name, r.gname, r.pname, r.pfschma, r.ppname,
r.pfname,
DECODE(BITAND(r.stmt_type, 1), 0, '', 'SELECT,') ||
DECODE(BITAND(r.stmt_type, 2), 0, '', 'INSERT,') ||
DECODE(BITAND(r.stmt_type, 4), 0, '', 'UPDATE,') ||
DECODE(BITAND(r.stmt_type, 8), 0, '', 'DELETE,'),
r.check_opt, r.enable_flag,
DECODE(BITAND(r.stmt_type, 16), 0, 0, 1)
FROM sys.user$ u, sys.obj$ o, sys.rls$ r
WHERE u.user# = o.owner# AND
r.ptype is not null AND
r.ptype = o.obj# AND
(UID IN (o.owner#, 0) OR
EXISTS (
SELECT role
FROM sys.session_roles
WHERE role = 'SELECT_CATALOG_ROLE'))
/
CREATE OR REPLACE VIEW exu10adefpswitches (
nlslensem, optlevel, codetype, warnings ) AS
SELECT a.value, b.value, c.value, d.value
FROM sys.v$parameter a, sys.v$parameter b, sys.v$parameter c,
sys.v$parameter d
WHERE a.name = 'nls_length_semantics' AND
b.name = 'plsql_optimize_level' AND
c.name = 'plsql_code_type' AND
d.name = 'plsql_warnings'
/
GRANT SELECT ON sys.exu10adefpswitches TO PUBLIC;
CREATE OR REPLACE VIEW exu9typtu (
tname, towner, ownerid, toid, mtime, typobjno, tabobjno,
audit$, sqlver, property,
DECODE(BITAND(r.stmt_type, 8), 0, '', 'DELETE,'),
r.check_opt, r.enable_flag,
DECODE(BITAND(r.stmt_type, 16), 0, 0, 1)
FROM sys.user$ u, sys.obj$ o, sys.rls$ r
WHERE u.user# = o.owner# AND
r.ptype is not null AND
r.ptype = o.obj# AND
(UID IN (o.owner#, 0) OR
EXISTS (
SELECT role
FROM sys.session_roles
WHERE role = 'SELECT_CATALOG_ROLE'))
/
CREATE OR REPLACE VIEW exu10adefpswitches (
nlslensem, optlevel, codetype, warnings ) AS
SELECT a.value, b.value, c.value, d.value
FROM sys.v$parameter a, sys.v$parameter b, sys.v$parameter c,
sys.v$parameter d
WHERE a.name = 'nls_length_semantics' AND
b.name = 'plsql_optimize_level' AND
c.name = 'plsql_code_type' AND
d.name = 'plsql_warnings'
/
GRANT SELECT ON sys.exu10adefpswitches TO PUBLIC;
CREATE OR REPLACE VIEW exu9typtu (
tname, towner, ownerid, toid, mtime, typobjno, tabobjno,
audit$, sqlver, property,
剩余16页未读,继续阅读
资源评论
- slc19892015-11-18同楼上 感觉没什么用。。。
- qian3388992012-12-19感觉没什么用啊。还是要用9i的才行。
- java_wangcg2013-09-04谢谢分享 十分有用
hlf48641715
- 粉丝: 45
- 资源: 103
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功