摘要: ObjectivesAfter completing this lesson,you should be able to to do the following:Differentate between a procedure and a functionDescribe the uses of functionsCreate stored functionsInvoke a functionRemove a functionLesson AgendaWorking with functions:-Defferentiating between a procedure and a functi 阅读全文
posted @ 2013-04-20 23:13 ArcerZhang 阅读(284) 评论(1) 推荐(0) 编辑
摘要: ORA-00257: archiver error. Connect internal only, until freed.Oracle 10g数据库物理空间管理方式与以前Oracle发生了变化,对归档日志所在的Flash_Recovery_Area空间进行了另外限制 Flash_Recovery_Area空间缺省安装时比较小,只有2GB,容易用完解决过程 根据数据库目前可用存储空间情况、FLASH_RECOVERY_AREA空间为2GB的实际情况,把FLASH_RECOVERY_AREA的空间修改为20GB()。 SQL> alter system set DB_RECOVERY_FI 阅读全文
posted @ 2013-04-20 00:20 ArcerZhang 阅读(282) 评论(0) 推荐(0) 编辑