Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ê·ÉÏ×îÇ¿µÄFQA for ORACLE(±¸·ÝÓë»Ö¸´²¿·Ö)

Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
[A]Èç¹û¿ªÆô¹éµµ£¬Çë±£Ö¤log_archive_start=true¿ªÆô×Ô¶¯¹éµµ£¬·ñÔòÖ»ÄÜÊÖ¹¤¹éµµ£¬Èç¹ûÊǹرÕÁ˹鵵£¬ÔòÉèÖøòÎÊýΪfalse
×¢Ò⣺Èç¹ûÊÇOPS/RAC»·¾³£¬ÐèÒªÏȰÑparallel_server = true×¢Ê͵ô£¬È»ºóÖ´ÐÐÈçϲ½Ö裬×îºóÓÃÕâ¸ö²ÎÊýÖØÐÂÆô¶¯
1¡¢¿ªÆô¹éµµ
a. ¹Ø±ÕÊý¾Ý¿âshutdown immediate
b. startup mount
c. alter database archivelog
d. alter database opne
2¡¢½ûÖ¹¹éµµ
a. ¹Ø±ÕÊý¾Ý¿âshutdown immediate
b. startup mount
c. alter database noarchivelog
d. alter database open
¹éµµÐÅÏ¢¿ÉÒÔͨ¹ýÈçÏÂÓï¾ä²é¿´
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:oracleora92databasearchive
Oldest online log sequence 131
Next log sequence to archive 133
Current log sequence 133
[Q]ÔõÑùÉèÖö¨Ê±¹éµµ
[A]9iÒÔÉϰ汾£¬±£Ö¤¹éµµµÄ×îС¼ä¸ô²»³¬¹ýnÃë
ÉèÖÃArchive_lag_target = n
µ¥Î»£ºÃë ·¶Î§£º0~7200
[Q]²»Í¬°æ±¾Ôõôµ¼³ö/µ¼Èë
[A]µ¼³öÓõͰ汾£¬µ¼ÈëÓõ±Ç°°æ±¾
Èç¹û°æ±¾¿çԽ̫´ó£¬ÐèÒªÓõ½ÖÐ¼ä°æ±¾¹ý¶É
[Q]²»Í¬µÄ×Ö·û¼¯Ö®Ç°Ôõôµ¼Êý¾Ý
[A]a.ǰÌõ¼þÊDZ£Ö¤µ¼³ö/µ¼Èë·ûºÏÆäËû×Ö·û¼¯±ê×¼£¬Èç¿Í»§»·¾³ÓëÊý¾Ý¿â×Ö·û¼¯Ò»Ö¡£
b.ÐÞ¸ÄdmpÎļþµÄ2¡¢3×Ö½ÚΪĿ±êÊý¾Ý¿âµÄ×Ö·û¼¯£¬×¢ÒâÒª»»³ÉÊ®Áù½øÖÆ¡£
²Î¿¼º¯Êý£¨ÒÔϺ¯ÊýÖеÄIDÊÇÊ®½øÖƵģ©£º
nls_charset_name ¸ù¾Ý×Ö·û¼¯ID»ñµÃ×Ö·û¼¯Ãû³Æ
nls_charset_id ¸ù¾Ý×Ö·û¼¯Ãû³Æ»ñµÃ×Ö·û¼¯ID
[Q]ÔõôÑù±¸·Ý¿ØÖÆÎļþ
[A]ÔÙÏß±¸·ÝΪһ¸ö¶þ½øÖƵÄÎļþ
alter database backup controlfile to '$BACKUP_DEPT/controlfile.000' [reuse];
±¸·ÝΪÎı¾Îļþ·½Ê½
alter database backup controlfile to trace [resetlogs|noresetlogs];
[Q]¿ØÖÆÎļþËð»µÈçºÎ»Ö¸´
[A]1¡¢Èç¹ûÊÇË𻵵¥¸ö¿ØÖÆÎļþ
Ö»ÐèÒª¹Ø±ÕÊý¾Ý¿â£¬¿½±´Ò»¸öºÃµÄÊý¾ÝÎļþ¸²¸Çµô»µµÄÊý¾ÝÎļþ¼´¿É
»òÕßÊÇÐÞ¸Äinit.oraÎļþµÄÏà¹Ø²¿·Ö
2¡¢Èç¹ûÊÇËðʧȫ²¿¿ØÖÆÎļþ£¬ÔòÐèÒª´´½¨¿ØÖÆÎļþ»ò´Ó±¸·Ý»Ö¸´
´´½¨¿ØÖÆÎļþµÄ½Å±¾¿ÉÒÔͨ¹ýalter database backup controlfile to trace»ñÈ¡¡£
[Q]ÔõôÑùÈȱ¸·ÝÒ»¸ö±í¿Õ¼ä
[A]Alter tablespace Ãû³Æ begin backup;
host cp Õâ¸ö±í¿Õ¼äµÄÊý¾ÝÎļþ Ä¿µÄµØ;
Alter tablespace Ãû³Æ end backup;
Èç¹ûÊDZ¸·Ý¶à¸ö±í¿Õ¼ä»òÕû¸öÊý¾Ý¿â£¬Ö»ÐèÒªÒ»¸öÒ»¸ö±í¿Õ¼äµÄ²Ù×÷ÏÂÀ´¾Í¿ÉÒÔÁË¡


Ïà¹ØÎĵµ£º

ÈçºÎÀûÓÃSQLSERVER2000µÄDTS µ¼ÈëÊý¾Ýµ½Oracle£¿

¾ßÌå²½Öè¾Í²»¶à˵ÁË £¬Òªµ¼³öµÄSQLSERVER±í½Ð LDJCUS£¬Ö÷¼ü Uid (int   ×Ô¶¯Ôö³¤ÁÐ)£¬µ¼Èëµ½Oracle×ܱ¨´í£º¶ÔÏóÃûÎÞЧ £¬È¥µôÖ÷¼üÁоͿÉÒÔ£¬²»ÖªµÀΪʲô£¿ÄѵÀ×Ô¶¯Ôö³¤µÄÖ÷¼üÁоͲ»Äܵ¼Èëµ½OracleÖУ¿£¿£¿Òɻ󡣡£¡£¡£ ......

Oracle ·þÎñ½ø³Ì ¼òµ¥½éÉÜ

Oracle ·þÎñ½ø³Ì-¼òµ¥½éÉÜ
ÒÔOrcale10gµÄ°æ±¾ÎªÀý£¬¼òµ¥½éÉÜÏÂOracleµÄ·þÎñ½ø³Ì£¨Windows°æ±¾£© -ganlan¡£
 
1¡¢OracleCSService
  ½ø³Ì£ºocssd.exe
½éÉÜ£ºCluster Synchronization Services (CSS)—Manages the cluster configuration by controlling which nodes are members of the cluster an ......

oracle distinctÓ÷¨

distinctÕâ¸ö¹Ø¼ü×ÖÀ´¹ýÂ˵ô¶àÓàµÄÖØ¸´¼Ç¼ֻ±£ÁôÒ»Ìõ£¬µ«ÍùÍùÖ»Óà ËüÀ´·µ»Ø²»Öظ´¼Ç¼µÄÌõÊý£¬¶ø²»ÊÇÓÃËüÀ´·µ»Ø²»ÖؼǼµÄËùÓÐÖµ¡£ÆäÔ­ÒòÊÇdistinctÖ»ÓÐÓöþÖØÑ­»·²éѯÀ´½â¾ö£¬¶øÕâÑù¶ÔÓÚÒ»¸öÊý¾ÝÁ¿·Ç³£´óµÄÕ¾À´Ëµ£¬ÎÞÒÉÊÇ»áÖ±½ÓÓ°Ï쵽ЧÂʵġ£
ÏÂÃæÏÈÀ´¿´¿´Àý×Ó£º
table±í
×Ö¶Î1     ×Ö¶Î2
&nbs ......

java jdbc µ÷Óà oracle´æ´¢¹ý³Ì ·µ»ØÓαê

1.´´½¨²âÊÔ±í
create table users(
userid int primary key,
username varchar2(20),
userpwd  varchar2(20)
);
insert into users values(1,'test','test');
insert into users values(2,'test','test');
insert into users values(3,'test','test');
insert into users values(4,'test','test');
insert i ......

OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶Î:
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ