oracle¸ü¸Ä×Ö·û¼¯
ÐÞ¸Äoracle 10gµÄ×Ö·û¼¯
ÐÞ¸ÄÊý¾Ý¿â×Ö·û¼¯Îª£ºZHS16GBK
Ê×ÏÈÓÃscott&tiger&orclµÇ¼µ½sql/plus
²é¿´·þÎñÆ÷¶Ë×Ö·û¼¯
SQL > select * from
V$NLS_PARAMETERS;
Ð޸ģº
$sqlplus /nolog
SQL>conn / as sysdba
Èô
´ËʱÊý¾Ý¿â·þÎñÆ÷ÒÑÆô¶¯£¬ÔòÏÈÖ´ÐÐ SHUTDOWN IMMEDIATE Ãü
Áî¹Ø±ÕÊý¾Ý¿â·þÎñÆ÷£¬È»ºóÖ´ÐÐÒÔÏÂÃüÁî:
SQL>shutdown
immediate
SQL>STARTUP MOUNT
SQL>ALTER SYSTEM ENABLE
RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER
SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER
DATABASE CHARACTER SET ZHS16GBK
*
ERROR at line 1:
ORA-12721:
operation cannot execute when other sessions are active
Èô³öÏÖÉÏÃæµÄ´íÎó£¬Ê¹ÓÃÏÂÃæ
µÄ°ì·¨½øÐÐÐ޸ģ¬Ê¹ÓÃINTERNAL_USE¿ÉÒÔÌø¹ý³¬¼¯µÄ¼ì²é£º
SQL>ALTER DATABASE CHARACTER SET
INTERNAL_USE ZHS16GBK;
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP
Ïà¹ØÎĵµ£º
ºÜ¾ÃûÓÐÓõ½OracleÁË£¬Ç°Ð©ÈÕ×Óµ¥Î»½ÓÁËÒ»¸öOracleÊý¾Ý¿âµÄÏîÄ¿£¬×ÔÈ»ÐèÒª¸´Ï°Ò»Ï£¬ÏÖ½«¸´Ï°¹ý³ÌÖеÄһЩҪµã¼Ç¼ÏÂÀ´£¬ÒÔ±¸²éÔÄ¡£
Ò»¡¢ ±íÁÐÊý¾ÝÀàÐÍ
1¡¢×Ö·û
1) VARCHAR2(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢×Ϊ4000¸ö×Ö·ûµÄ×Ö·û´®¡£µ«ËüÊǿɱäµÄ£¬Ö»Ê¹Ó ......
ORACLEÖеÄÊý¾Ý×ÖµäÊÇʲô£¿ÓÐÊ²Ã´ÌØµãºÍ¹æÂÉ£¿
Êý¾Ý×Öµä¼Ç¼ÁËÊý¾Ý¿âµÄϵͳÐÅÏ¢£¬ËüÊÇÖ»¶Á±íºÍϵͳÊÓͼµÄ¼¯ºÏ¡£
Êý¾Ý×ÖµäµÄËùÓÐÕßÊÇSYSÓû§£¬Êý¾Ý×ֵ䶼±»´æ·ÅÔÚSYSTEM±í¿Õ¼ä£¬SYSÓû§µÄ·½°¸Ï¡£
Êý¾Ý×ÖµäÖ»ÔÊÐíSELECT²Ù×÷£¬Æäά»¤ºÍÐÞ¸ÄÈÎÎñÓÉÊý¾Ý¿â×Ô¶¯Íê³É¡£
µ±Óû§Ö´ÐÐCREATE¡¢ALTER¡¢DROP ......
¡¡¡¡ ÎÒÃÇ¿ÉÒÔͨ¹ýÏÂÃæµÄÓï¾äÀ´²éѯÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ä£º
¡¡¡¡
¡¡¡¡SQL> select * from database_properties where property_name = 'DEFAULT_TEMP_TABLESPACE'£»
¡¡¡¡¡¡
¡¡¡¡ ĬÈÏÁÙʱ±í¿Õ¼äµÄÏÞÖÆ£º
¡¡¡¡
¡¡¡¡1. ĬÈÏÁÙʱ±í¿Õ¼ä±ØÐëÊÇTEMPORARYµÄ:
¡¡¡¡
¡¡¡¡SQL> alter database default temporary t ......
Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ
ÔÚOracleµ÷ÕûÖÐÎÒÃÇ»¹»áÉæ¼°µ½SQL Óï¾äµÄµ÷ÓÅ£¬ÎÒÃǽÓÏÂÀ´¾ÍÀ´¿´ÒÔÏ嵀 SQL Óï¾äµÄµ÷ÓÅ¡£ÎÒÃǶ¼ÖªµÀ Oracle ÖÐµÄ SQL µ÷ÓÅÊÇÒ»¸öÏ൱¸´ÔÓµÄÖ÷Ì⣬ÉõÖÁÊÇÐèÒªÕû±¾ÊéÀ´½éÉÜ Oracle SQL µ÷ÓŵÄϸ΢²î±ð¡£
²»¹ýÓÐһЩ»ù±¾µÄ¹æÔòÊÇÿ¸ö Oracle DBA ¶¼ÐèÒª¸ú´ÓµÄ£¬ÕâЩ¹æÔò¿ÉÒÔ¸ÄÉÆËûÃÇϵͳµÄ ......
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
1¡¢½¨Á¢´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO T_TEST (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
2¡¢ÏàÓ¦µÄJAVA³ÌÐò
import java.sql.*;
import java.io.OutputStream;
import java.io.Writer;
import java.sq ......