-
编辑 删除
ORA-03117: two-task save area overflow
在用到package dbms_metadata的时候发现问题SQL> desc dbms_metadata ERROR: ORA-03117: two-task save area overflow From metalink :Subject: Describe of DBMS_METADATA Raises 'ORA-3117: two-task save area overflow' Doc ID: 362447.1 Type: PROBLEM Modified Date : 22-MAY-2007 Status: PUBLISHEDApplies to:Oracle Server - Enterprise Edition - Version: 10.2This problem can occur on any platform.SymptomsFrom 10.2 SQL*Plus, an attempt is made to describe a large PL/SQL ob
-
编辑 删除
MYSQL简单操作
1. 登录mysqlmysql -u root -p2. 查询哪些用户可以登录mysqlmysql> select host,user from user;3. change column name(oracle好像不能change column name)alter table [test] change [old_column_name] [new_column_name] tinytext;4. 修改权限mysql> flush privileges;[@more@]
-
编辑 删除
Linux远程桌面到Windows
1.到http://www.rpmfind.net 下载个rdesktop for linux[root]# rpm -ivh rdesktop-1.5.0-5.fc9.i386.rpm Preparing... ########################################### [100%] 1:rdesktop ########################################### [100%]2.rdesktop -g 90% -a 24 192.168.1.45-g 90%表示屏幕显示90%， -a 24表示使用24位显示(可用8 16 24)[@more@]
-
编辑 删除
ORA-00257: archiver error. Connect internal only, until freed
SQL> select * from v$flash_recovery_area_usage;FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------CONTROL FILE 0 0 0REDO LOG 0 0 0ARCHIVED LOG 92.64 0 229FILE_TYPE
