摘要:
As of Oracle Database 10g, you can use the flashback table and flashback databasecommands to simplify your data-recovery efforts. The flashback table commandautomates the process of restoring a full table to its prior state. The flashbackdatabase command flashes back an entire database, and it req.. 阅读全文
摘要:
Oracle调度是指定时的启动程序,执行相应的操作,Oracle10G中dbms_job包(位于SYS用户下),Oracle已经提供了DBMS_SCHEDULER用来替代它。逐步的摒弃dbms_job包。This package is deprecated and has been supplanted by DBMS_SCHEDULER.dbms_job包下使用的参数: -- JOB is the number of the job being executed. -- WHAT is the PL/SQL procedure to execute. -- The job must... 阅读全文
摘要:
Tablespaces and the Structure of the Database People who have worked with computers for any period of time are familiar with the concept of afile; it’s a place on disk where information is stored, and it has a name. Its size is usually not fixed: Ifyou add information to the file, it can grow larg.. 阅读全文