oracle 10gÊý¾Ý¿â±¸·ÝÓ뻹Ô×ܽá(תÔØ£©
1.Êý¾Ý¿â¹éµµÄ£Ê½:
* ·Ç¹éµµÄ£Ê½:µ±Êý¾Ý¿âÊý¾ÝÖ»¶Á²»»á¸Ä±äʱ,Êý¾Ý²»»á¸Ä±ä,Êý¾Ý¿âÊʺÏÓ÷ǹ鵵ģʽ, ÕâÑùÌá¸ßÐÔÄÜ
* ¹éµµÄ£Ê½:¶ÔÓÚÊý¾Ý¿âÊý¾Ý¾³£±ä¶¯,Êý¾Ý¿â×îºÃÓù鵵ģʽ,ÕâÑù¿ÉÒÔ¾¡Á¿±ÜÃâÊý¾Ý¿â Êý¾Ý¶ªÊ§,ʹ³öÏÖÎÊÌâʱÔÖº¦½µµ½×îµÍ
2.·Ç¹éµµÄ£Ê½Óë¹éµµÄ£Ê½¼äµÄÇл»(ÔÚÃüÁî´°¿ÚÏÂ):
@¼ì²éµ±Ç°ÈÕÖ¾²Ù×÷ģʽ
f:\>sqlplus sys/dba as sysdba
Á¬½ÓÊý¾Ý¿â
sql>select log_mode from v$database;
@¹Ø±ÕÊý¾Ý¿â,ºó×°ÔØÊý¾Ý¿â,Ö»ÄÜÔÚmount״̬ϸıäÈÕÖ¾²Ù×÷ģʽ
sql>startup mount
@¸Ä±äÈÕ־ģʽ
sql>alter database achivelog;(±äΪ¹éµµ·½Ê½,·ñÔòΪnochivelog)
sql>alter database open;
3.²é¿´¹éµµÄ£Ê½Ïà¹ØÐÅÏ¢:
@Èô²ÉÓÃĬÈÏÉèÖÃ,¹éµµÈÕ־λÖÃÔÚ¿ìËÙ»Ö¸´Çø
@ÅäÖù鵵ÈÕ־λÖà log_archive_dest_n (n=[1:10])
sql>alter system set
log_archive_dest_1 = 'location =c:\demo\archive [optional]';
&nb
Ïà¹ØÎĵµ£º
¡¡¡¡OracleÊý¾Ý¿âÖУ¬±íÊÇ×î»ù±¾µÄÄÚÈÝ¡£¿ÉÒÔ˵£¬±íÉè¼ÆµÄºÃ»µÖ±½Ó¸úÊý¾Ý¿âµÄÐÔÄÜÏà¹Ø¡£ËùÒÔ£¬ÔÚÉè¼Æ±íµÄʱºò£¬³ýÁËÒª×ñÑÆä¹ÌÓеÄÊý¾Ý¿â×¼ÔòÖ®Í⣬»¹ÐèÒª¿´¸öÈ˵ÄÊý¾Ý¿â¹ÜÀí¾Ñé¡£ÏÂÃæÎҾͰÑÕâЩ¾Ñé·ÖÏíһϣ¬»òÐí¶Ô´ó¼ÒÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢ ±í¸Ã´æ·ÅÔÚÄÄÀï?
¡¡¡¡ÎÒÃǶ¼ÖªµÀ£¬ÔÚOracleÊý¾Ý¿âÖУ¬Ê¹ÀûÓÿռäÕâ¸ö¸ÅÄîÀ´¹Ü ......
¸ü¸Ä±íµÄ½á¹¹
1.±à¼±íµÄ×Ö¶Î
ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
Óï·¨:
ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
eg1:
alter table skate_test modify (author number(10,0) )
ÔÚÐÞ¸ÄÁеij¤¶Èʱºò,Ö»Äܱ ......
ʵÀý£º
1¡¢Í¨¹ýDBLINKµÄ·½Ê½£º±í¿Õ¼ä²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG network_link=to_crm_7 schemas=MCMDB REMAP_TABLESPACE=table_space11:table_space12,table_space21:table_space22
2¡¢Í¨¹ýDBLINKµÄ·½Ê½£º·½°¸£¨schemas£©²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG net ......
Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄÓû§£¬ ......
package com.svse.dao;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class UserDAO {
/*
* javaµ÷Óô洢¹ý³Ì
*/
public int addUser(String username,int userage)
{
Connection conn = null;
int useri ......