oracle Ö¸µ¼ÖÐÐÄ ¶ÎÖ¸µ¼ÎÊÌâ
trcÎļþ
Dump file d:\oracle\admin\www\bdump\gjhohj_j000_496.trc
Mon Feb 08 14:44:11 2010
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:694M/1535M, PG:2570M/3434M, VA:1725M/2047M
Instance name: gjhohj
Redo thread mounted by this instance: 1
Oracle process number: 16
Windows thread id: 496, image: ORACLE.EXE (J000)
*** ACTION NAME:() 2010-02-08 14:44:11.375
*** MODULE NAME:() 2010-02-08 14:44:11.375
*** SERVICE NAME:(SYS$USERS) 2010-02-08 14:44:11.375
*** CLIENT ID:() 2010-02-08 14:44:11.375
*** SESSION ID:(162.445) 2010-02-08 14:44:11.375
*** 2010-02-08 14:44:11.375
ORA-12012: error on auto execute of job 49206
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1283
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at line 6
oracle 10g
ÎÒÊÇÔÚem -->Ö¸µ¼ÖÐÐÄ-->¶ÎÖ¸µ¼ÖÐÌí¼ÓÒ»¸ö±í¿Õ¼ä¡£±¨
È·ÈÏ <
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......