love wife love life —Roger的Oracle/MySQL数据恢复博客

Phone:18180207355 提供专业Oracle/MySQL数据恢复、性能优化、迁移升级、紧急救援等服务

关于ORA-1652的一点简单总结

本站文章除注明转载外,均为本站原创: 转载自love wife love life —Roger的Oracle/MySQL数据恢复博客

本文链接地址: 关于ORA-1652的一点简单总结

10 Responses to “关于ORA-1652的一点简单总结”

  1. roger Says:

    大家可以参考下tom精辟回答 关于ora-1652 http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:36859040165792

  2. 老熊 Says:

    你这个查询表空间利用率的脚本存在BUG,比如某个表空间完全耗尽时,dba_free_space里是没有这个表空间的数据的,这样关联出来就会丢失这个表空间的信息。应该使用外关联。

  3. roger Says:

    to 熊哥:这个到没注意过 只是知道有几个关于dba_free_space的bug。 10204+ 还有这个问题? 你指的bug有具体的bug号没 ?

  4. roger Says:

    Freespace=0 in the Repository Admin Utility but tablespace does have freespace [ID 133758.1]

    ——————————————————————————–

    修改时间 16-FEB-2011 类型 PROBLEM 状态 PUBLISHED

    *** Checked for relevance on 16-Feb-2011 ***

    Problem Description
    ——————-
    In the RAU one or more Tablespaces show 0 for freespace. When you go into
    SQLPLUS with the select statement:

    select tablespace_name, sum(bytes)/1024/1024 from dba_free_space
    group by tablespace_name;

    Shows lots of space for that tablespace

    Solution Description
    ——————–
    Regrant all of the permissions in the install manual for the repository owner.

    GRANT EXECUTE ON DBMS_LOCK TO ;
    GRANT EXECUTE ON DBMS_PIPE TO ;
    GRANT CREATE TABLE TO ;
    GRANT CREATE VIEW TO ;
    GRANT CREATE PROCEDURE TO ;
    GRANT CREATE SYNONYM TO ;
    GRANT CREATE SEQUENCE TO ;
    GRANT SELECT ON sys.v_$nls_parameters TO WITH GRANT OPTION;
    GRANT SELECT on sys.V_$PARAMETER TO ;
    GRANT SELECT ON dba_rollback_segs TO ;
    GRANT SELECT ON dba_segments TO ;
    GRANT CREATE ANY SYNONYM TO ;
    GRANT DROP ANY SYNONYM TO ;
    GRANT CREATE PUBLIC SYNONYM TO ;
    GRANT DROP PUBLIC SYNONYM TO ;
    GRANT ck_oracle_repos_owner to ;
    GRANT CONNECT, RESOURCE TO ;

    Explanation
    ———–
    Designer requires all permissions that are given in the install manual to
    operate properly.

  5. 老熊 Says:

    不是指Oracle的BUG,我的意思是你的脚本有缺陷。比如一个表空间的所有空间都已经用完的时候,dba_free_space里面就不会有这个表空间的记录了。

  6. roger Says:

    to 熊哥: 哈哈 了解了。。。。

  7. love wife & love life ——Roger » Blog Archive » 关于ora-1652的一点总结–续(详解rowid,index entry header) Says:
  8. maclean Says:
  9. roger Says:
  10. 深圳耳鼻喉医院 Says:

    I have been browsing on-line more than 3 hours these days, yet I never discovered any attention-grabbing article like yours. It’s lovely value sufficient for me. In my view, if all web owners and bloggers made just right content material as you probably did, the web will likely be much more helpful than ever before.

Leave a Reply

You must be logged in to post a comment.