ITPub博客

If the tables are not really dropped in this process--therefore not releasing the tablespace--what happens when the dropped objects take up all of that space?[@more@]The answer is simple: that situation does not even arise. When a tablespace is completely filled up with recycle bin data such that the datafiles have to extend to make room for more data, the tablespace is said to be under "space pressure." In that scenario, objects are automatically purged from the recycle bin in a first

Ever had a need to export only certain procedures from one user to be recreated in a different database or user? Unlike the traditional export utility,Data Pump allows you to export only a particular type of object. For instance, the following command lets you export only procedures, and nothing else--no tables, views, or even functions:expdp ananda/iclaim directory=DPDATA1 dumpfile=expprocs.dmp include=PROCEDURE[@more@]To export only a few specific objects--say, function FUNC1 and procedure PRO

1. Oracle Database 10g: Program with PL/SQL 2. Oracle Database 10g: Program with PL/SQL LWC 3. Oracle Enterprise Manager 10g Grid Control 4. Oracle Database 10g: SQL Tuning Workshop 5. Oracle Database 10g: Real Application Clusters 6. Oracle Database 10g: Data Guard Administration 7. Oracle Database 10g: Implement Streams 8. Oracle Database 10g: Advanced PL/SQL 9. Oracle Database 10g: Security 10. Migrate from SQL Server to Oracle Database 10g 11. Migrate from Sybase to Oracle Database 10g 12. O

应用程序抛了如下的异常：SQL> exec PR_COMPARE_FREEZEBALANCE_TEMP();begin PR_COMPARE_FREEZEBALANCE_TEMP(); end;ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too smallORA-06512: at "MOCSACCT.PR_COMPARE_FREEZEBALANCE_TEMP", line 16ORA-06512: at line 1在告警日志中发现如下的异常：[@more@]Wed Mar 12 20:09:22 2008ORA-01555 caused by SQL statement below (Query Duration=11325 sec, SCN: 0x000d.7a79d7d1):Wed Mar 12 20:09:22 2008SELECT B.ACCTID,NVL(B.FR