! 80 Y  0 %`u !.8DPYj7CQ0DQ]ht & 0 t #;ao޷ʼҪָOCI ڴ治ڲ﷨δҵʵδҵάʧ/ͳϢЧʵ廯ͼȱʧͳϢʵָʵЧбָĸҪЧʧһ뱣ĸҪСָĿռûȡ⵽еķǷ״̬ҪָҪ COMPATIBLE ֵΪ 8.1.0.0 Java δáִ INITJVM.SQL INITQSMA.SQL Pw,VtҪָδװִ INITQSMA.SQLģ %s дݷʴֵָ %s (ڲ %s) ЧЧ޷ļ %s дʲ %s ѡ %s Чֵָ %s %s %s ɽܵķΧ (ڲ %s ) %s ûЧĹ, ޷ִй %s Ĺ伯Ѵָ %s һָʹָ %s ûб %s ָ %s Թ %s Чָû %s Pj)Fiǰĵģʽ %s Чǰȼ %s ЧָĸҪָ %s δҵ %s, ʱ֤ûĹ %s.%s %s ûĹ %s.%s ڱ %s.%s Ч޷֤ûĹǰĹҪ SQL ûпɹû %s ʹõ SQL ٻЧδҵ SQL %s, ڹ %sָ %s ѱ %s ָ SQL ûЧıö޷洢ڹ J{  ) O m ޷ָ SQL 洢в %s Ч %s %sû %s д SQL ڱЧ޷ָ SQL 洢ûĹ %s ȱʧ: %sʱָָ֧ %sָļ %s Ч޷зָָеָ %s ͻ޷ִ %s, Ϊ޸Ĺ %sֵָ %s Բ %s ЧЧĹؼ %sֵָ %s Dz %s Чڸʽ Jn!Pֵָ %s Բ %s Ч%s %s (б %s õ) Բ %s Чʱָ %s %s ֧ %s ָ %s Чռ %s ָ %s ЧĽ鰸ֱ֧ʵʩĽ鰸Ҫû༭, ޷ʵʩ޷޸ĻĹ %s, Ϊ %s ʹָ SQL ֵ֧Ͷ޷洢ڹһͳϢȱʧ޷ָ SQL 洢ڹָ SQL Tuning Set %s Pp !!9"K#g$%Υ %s ޷洢SQL Tuning Set ϵδʵʩڱ %s ûЧͳϢ޷ָ SQL 洢ڹеǰûָ %s ָ %s Ѵ޷ҵûĹ %sָĹ %s Чָû %s Чִв %s (%s) %s ʱڲֹ, STORAGE_CHANGE ֵ %s ΪǿƷʽṹû㹻Ŀռָ鰸 %s ֵ %s Ч&z'()R2S6T<UAVEWGXzY~Z[\]^_` STORAGE_MODE Ϊ TOTAL, ָ %s ֵANALYSIS_SCOPE ֵЧѡϡ %s ֻʹһؼ֡ѡ֮һ: %sѡĽ鰸ֵ %sEMPTYNULL%sɵĹ: ɨ %s ѽ %s Ѷ %sûĹ %s.%s 빤 SQL ٻ浼빤ӷ빤ӸҪָ %s 빤ģû˵abcdefghijklmno8pTq`rrstuĹûͨݿģOLTP ݿģݲֿݿģSQL ָ: 汾 %s - ʽû::ִ:ͳϢȱʧ: : %sЧ: û: %s : %sSQL Ч: û: %s : %sѯ: %sѯ: %s׼ڷĹ SQL Tuning Set %s 빤Υ: %s: : %sûЧ: û: %s : %s vVwxxyz{|}#~Vrrѹʱ: : %s : %sժҪ: %s: δʹùժҪ: %s: Ѷ: %sժҪ: ѽûָйĬϵ Enterprise Manager ģժҪ: %s: ʧЧ: %sùɵĹ: ɨ %s ͨ %s ʧЧ %sSQL Ч: û: %s : %s BRIEF ģʽ¿תδҵ %s ѡ %s ѯŻܾ Jv,Rxδҵ %s õʵ廯ͼѡѯ %s ʵ廯ͼѯŻܾе %s ûͳϢ %s %s ̫ȶ %s %s ̫ȶڲѯ %s ڼڲΪ %s ʱѶ, ʹԱʧϢѱûȡ (ڵ %s ׶, %s )ѱûж (ڵ %s ׶, %s )ʱ (ڵ %s ׶, %s )  3Tsδҵеʵ廯ͼδҵϲѯ %s ʵ廯ͼʵ廯ͼѡ (%s%%)Ϊÿѯɳʼ (%s%%)ִбŻ (%s%%)ִȫŻ (%s%%)ѡ (%s%%)ÿѯijʼִгɱ (%s%%)׼ڷĹѯ (%s%%)ִָSQL ﷨ЧЧûЧûЧЧЧģЧģЧSQL ַЧSQL ַЧЧnz2B^ʼʱЧʱЧͳϢȱʧͳϢȱʧ: : %sעЧִʺȫֵĺ (%s%%)%sSQL Access Advisor ڷ (%s)SQL Access Advisor жϻȡע %s : %sԱ %s ·ضֹԶԱ·ִʵʩűǰ, ɾ¶: %sµķ %s Ƶµķɾԭʼϵʵ廯ͼ־µķϴʵ廯ͼ־"0>HJ\j֤ %s µķʹԭʼеµķ, Ϊ·ָԭʼıעԼԼȨϸȷʿƲԷϸƲʵ廯ͼάǰδʵʩָδòѯд OPTIMIZER_MODE ǻڹʱ޲ѯд DDL ѯ޲ѯдͼϲ֮ǰ޲ѯдѯд SQL ʱ޲ѯдԴ˲ѯòѯд VmCiѯ NOREWRITE ʾûвѯдڸ²ѯͨʵ廯ͼ %s, ıƥ㷨˲ѯдʵ廯ͼ %s δҵѯеıδ̽дʱ, Ҫдʾ FROM д SAMPLE ӾǶ׵ľۼ CONNECT BY/START WITH Ӿ˲ѯ WHERE ӾеĶ ORGROUP BY ӾûЧвѯд֧־ۼ %sۼ޷תΪ淶ʽдʵ廯ͼδҵʵʵ廯ͼд˲ѯ\n(Am ʵ廯ͼ %s Чʾбδҵʵ廯ͼ %s ѽ %s ʵʵ廯ͼдʵ廯ͼ %s GRANT ʵ廯ͼ %s δ֪ıδҵʵ廯ͼ %s %s òѯдʵ廯ͼ %s õǰˢʵ廯ͼ %sʵ廯ͼ %s ENFORCED ģʽѹʱʵ廯ͼ %s ENFORCED ģʽо PL/SQL ʵ廯ͼ %s TRUSTED ģʽѹʱδҵʵ廯ͼ %sʵ廯ͼ %s дѯ P w   Blʵ廯ͼ %s Ҫһάӱ %s˱ϴмȫͼϲ, ڲѯзֲƥ %sѯд޷IJѯͼܴ߼ⲿӵҲѡʵ廯ͼ (%s) Ͳѯͼƥʧʵ廯ͼ %s ѯеĶƥ %s ĶλƥӽṹеļʧڱϳΪ %s ָӵӻӵ RHSͼϳΪ %s ָӲصϽиӵĻָ (%s) Jvg !ڷ MAV дϽиӵĻָ (%s)ָӼ𲻴 (%s)ʵ廯ͼ %s İӼʧܶʵ廯ͼ %s ۼƼʧܵϴڴںʱ֧ۼƱԼ %s ENFORCED ģʽЧ NORELY Լ %s TRUSTED/STALE TOLERATED ģʽвѯ͸Ҫ %s ֮ƥѯд޷ʵ廯ͼͼԴ DDL ʽ޲ѯдԴ DML ʽ޲ѯд "V#z$%&'() *0+Q,p-x.ʵ廯ͼ %s û %s ڻָӲѯе HAVING ӾʽȷHAVING ӾеӲѯǷѯʽǷѯһֶѯһֵͼѯһ̶ͼʵ廯ͼ %s ޷ѯеĶ %sʵ廯ͼ %s ȱԲѯ %sʵ廯ͼ %s ֲ֧ѯ %sά %s ĸҪͼб %sδҵͬ /D0123J4i5}678ʵ廯ͼ % % ֮Ѿɾ˲ѯҵijЩ, ޷ִвѯдʵ廯ͼ %s Ͳѯڱ %s ֮вͬڲѯҲʵ廯ͼ %s еij, ޷ִвѯдʵ廯ͼ %s Ͳѯڱ %s ֮вͬ, ޷ִвѯдʵ廯ͼ %s ֧־ۼ %sδҵʵ廯ͼʵ廯ͼ %s ڱȲѯߵļϷʵ廯ͼ %s ΪЧʵ廯ͼ %s õıϷ DML ά %s Ч 9J:};<=>?:AhBCDδҵ %s ID, ñλʵ廯ͼ %s ޷ʵ廯ͼ %s %s Ӳѯı - ڲͼڲѯҲʵ廯ͼ %s еĶλ %sʵ廯ͼ %s ڱ %s ֮һENFORCED ģʽвڻδʹά޷ʵ廯ͼ %s õ϶Բѯзѯеڲͼʵ廯ͼͼϲ֮޲ѯдڳɱŻֲѯдĴ۸ʵ廯ͼд, rowid ȱʧ EPFrGHIJK>LjMNOPʵ廯ͼδҵӱʵ廯ͼδҵⲿӹھз鼯ʵ廯ͼδҵʵ grouping_idз鼯ʵ廯ͼظھз鼯ʵ廯ͼ, ؼֹʵ廯ͼ %s ӾȲѯ %s Ӿи޷ʹöԱ %s ʵ廯ͼĹʱֵöʵ廯ͼ %s ޶Լʧʵ廯ͼ %s Ϸۼʵ廯ͼ %s Ҫָӵ %s, ˱λ %s ڴ˲ѯԶ̱ %sѯʹ Q>RmSTUVWqXYʵ廯ͼ %s Ҳڱ %s IDʵ廯ͼ %s ڻеijЩǹʱIJ޶Ը (PCT) д˲ѯ %s ķʹʵ廯ͼ %s дʱ, ѯֲ %sʵ廯ͼ %s ѯвڵı (%s) ֮, ܻѯ, ޷Ըͼִвѯдʵ廯ͼ %s δҵؼֻʵ廯ͼ %s WHERE ӾȲѯиʵ廯ͼ %s HAVING ӾȲѯи [P\l`acdef4g\h|ijھдںϷۼƴںɼԼʧܴ˴ݹдʵ廯ͼ %s ENFORCED ģʽΪ TRUSTED㷨޷ʵʵ廯ͼ %s ûбʹ˱ %s Żʵ廯ͼдʵ廯ͼ %s дѯʵ廯ͼ %s ˲ѯдʵ廯ͼдѽòѯ NO_MULTIMV_REWRITE ʾһѯûʵ廯ͼ, ʵ廯ͼд kVlxmnopq~#[ѯ ONLY_MULTIMV_REWRITE ʾѯһвѯһ ADT вѯһػǶ׵ıвѯһ LOB вѯһǶ׵ıбΪ SKIP WHEN NULL ά %sδдѯдѯ CONNECT BY Ӿ, ޷ִжʵ廯ͼѯдڲѯ, ޷ִжʵ廯ͼѯд START WITH Ӿ, ޷ִжʵ廯ͼѯдڴں, ޷ִжʵ廯ͼѯд8f4bڷ鼯, ޷ִжʵ廯ͼѯд, ޷ִжʵ廯ͼѯдڵӱ, ޷ִжʵ廯ͼѯдǶ׵ľۼ, ޷ִжʵ廯ͼѯдѯеķ 256, ޷ִжʵ廯ͼѯд, ޷ִжʵ廯ͼѯд RLS ͼ, ޷ִжʵ廯ͼѯдڲֵ֧ľۼ, ޷ִжʵ廯ͼѯд8l;gû󶨱, ޷ִжʵ廯ͼѯд SELECT бҲ ORDER BY , ޷ִжʵ廯ͼѯд SELECT бҲ ORDER BY ʽ, ޷ִжʵ廯ͼѯд WHERE Ӿڲѯ, ޷ִжʵ廯ͼѯддϸ, ޷ִвѯд޷ CREATE ALTER VIEW ִвѯд OPTIMIZER_MODE Ϊڹ, ޷ִвѯд޷ DDL ѯִвѯд >^BtȺϲͼ, ִвѯдѯд SQL, ޷ִвѯдѯ NOREWRITE ʾ, ޷ִвѯд޷ִڸ²ѯIJѯдͨʵ廯ͼ %s, ıƥ㷨˲ѯдʵ廯ͼ %s Ͳѯ֮δҵñ, ޷ִвѯд洢Ĵвдʾ, ޷ִвѯд FROM а SAMPLE Ӿ, ޷ִвѯдǶ׵ľۼ, CONNECT BY Ӿ, START WITH Ӿݹ WITH Ӿ, ޷ִвѯд JB\|ѯ WHERE ӾĶ OR, ޷ִвѯдѯ GROUP BY ӾûЧ, ޷ִвѯдʵ廯ͼͲѯ֮ĵƥܻܿᵼ²ѯдĴ۸δҵʵʵ廯ͼд˲ѯʵ廯ͼ %s ѽ, ʱ޷ʹʵ廯ͼ %s %s ޷ʵ廯ͼ %s ѯ޷ͼΪ %s ָӲϻָ (%s)޷ڲоۼ (%s) ʵ廯ͼϻָʵ廯ͼûлָӼ (%s)8^{Zڴڴں, ѯд޷ִۼ޷Դ DDL ִвѯд޷Դ DML ִвѯдѯֵͼ, ޷ִвѯдʵ廯ͼ %s %s ֮Ѿɾ˲ѯҵijЩ, ޷ִвѯдڲѯҲʵ廯ͼ %s еij, ޷ִвѯдʵ廯ͼ %s Ͳѯڱ %s ֮вͬ, ޷ִвѯдʵ廯ͼ %s õıϷ DML , ޷ִвѯд8} 4}ڱ %s ʵ廯ͼ %s ֮Ҫ ID, ޷ִвѯдڲѯҲʵ廯ͼ %s еĶλ %sھӵʵ廯ͼδҵӱھз鼯ʵ廯ͼδҵʵ grouping_idʵ廯ͼظķ鼯, ޷ִвѯдھз鼯ʵ廯ͼ˳ 176 ͬĹؼ, ޷ִвѯдʵ廯ͼ %s ӾȲѯ %s Ӿиʵ廯ͼ %s еijЩѹʱ, ޷ִвѯд Dm$)4D5x67ڲѯԶ̱ %s, ޷ִвѯдڲѯʹ, ޷ִвѯд޶Ը (PCT) дѯ 'OR' ĸֵ %s޷ͨʵ廯ͼ %s 㴰ںʵ廯ͼ %s ENFORCED ģʽо TRUSTED Լ, ޷ִвѯдڲѯһ, ޷ִвѯдڲѯһ ADT , ޷ִвѯдڲѯһػǶ׵ı, ޷ִвѯдڲѯһ LOB , ޷ִвѯд 8D;j<=>?@*AYBCδʹָʵ廯ͼ (%s) дѯ֧ڲͼۼдڲѯʵ廯ͼ֮Ҳڲͼƥʵ廯ͼ %s Ͳѯڲͼ֮Dzͬڲѯȫⲿ, ޷ִвѯдܶԶ̶ִгڲͼдܶԴ WHERE ӾṹִгڲͼдڲͼӲѯʱִгڲͼдܶǶڲͼִгڲͼдѯڲͼ޷κʵ廯ͼڲͼƥ DJEdFGHIJ>KZڲͼзЧνʴڲͼϲֳ֧ڲͼѯдִ֧ڲͼѯڲͼûκʵ廯ͼڲͼƥĶѯ SELECT бʵ廯ͼڲͼƥģʽΪ stale_tolerated, ܶԶ̶ִвѯдѯдԶ̶ǽõԶ̶, ִ multi-mv дͬʵ廯ͼ %s ѯıƥʹ˱ %s Żĵͬʵ廯ͼдԵͬʵ廯ͼ %s òѯд Dd$.0ABBbJQʹõͬʵ廯ͼ %s дѯͬʵ廯ͼ %s ޷ڲѯм %sͬʵ廯ͼ %s ֲ֧ѯ %sͬʵ廯ͼ %s Ͳѯڱ %s ֮вͬ޷ͬʵ廯ͼ %s %s ӵͬʵ廯ͼ %s еĶλ %s δڲѯҵڵͬʵ廯ͼ %s ϷۼƵͬʵ廯ͼ %s Ҫ %s (λڵ %s ) ָڲѯδҵͬʵ廯ͼ %s ڱ %s ֮ӵͬʵ廯ͼѽ RVSU-&.F`tõͬʵ廯ͼ %s ıƥд ENFORCED ģʽʹõͬʵ廯ͼָͬʵ廯ͼͬͨͬ %s, ıƥ㷨˲ѯдڲѯҲͬ %s еĶλ %sԵͬ %s еݹѯдֶ֧Եͬаת۴ʵ廯ͼSELECT бе DISTINCT ۼʽоۼǶ SELECT бк˷ FROM бͼFROM беӲѯ\t3Qd~ͬıͼĶʵWHERE HAVING Ӿеķӹڲʹ˳Ⱥ (=) νʴһ HAVING Ӿһ CONNECT BY ӾSELECT бһ RAW ͱʽֹһе GROUP BY ʽ FROM бд (IOT)FROM беľ۴ر HAVING ӾдӲѯ WHERE ӾдӲѯʵ廯ͼ FROM Ӿеһʵ廯ͼвھ NOT NULL Լ SELECT бn D]zʵ廯ͼۼѡǶ׵α GROUP BY Ӿ޾ۼWHERE Ӿеķ AND Ӵʰ ROLLUP 鰴 CUBE PL/SQL ΪԤʵ廯ͼָ˼򻯵ľʵ廯ͼ޷֧κ͵IJѯд WHERE Ӿв WHERE Ӿвڹ HAVING Ӿв HAVING Ӿвڹʵ廯ͼд in-listڱʱԳʽֵ\x"8Nqˡĸ (PCT)ʵ廯ͼѯʹ˷鼯ѯ Gset, дĹؼ̫Ƕ׵ľۼFROM беͼӲѯʵ廯ͼе ORDER BY Ӿʵ廯ͼе START WITH Ӿʵ廯ͼеĴںʵ廯ͼеⲿʵ廯ͼʹ ANY ӾӲѯʵ廯ͼʹ ALL ӾӲѯʵ廯ͼʹ NOT EXISTS ӾӲѯʵ廯ͼʹѡбӲѯʵ廯ͼеռӲѯ Jp    ,Lh~ʵ廯ͼѡбе DISTINCT Ӿʵ廯ͼѹĶͼʵ廯ͼеرⲿʵ廯ͼ ROWNUMʵ廯ͼа set , ģʽΪС 9.0ӿܵʵ廯ͼظʵ廯ͼдһʵ廯ͼе GROUP BY Ӿʵ廯ͼеľۼʵ廯ͼеӲѯOracle : йϸϢ, RELATED_NUM RELATED_TEXT VC_sѡбûзؼֻ PMARKER رʽϵһѷıPCT ؼһʹPCT һʹڲ: PCT ϴδ岻Ƕʵ廯ͼˢµҪ RepAPI ʵ廯ͼܽпˢͨ칹ӵʵ廯ͼͬϵʵ廯ͼʵ廯ͼ־екűϴˢµкҪʵ廯ͼ־һȫˢµʵ廯ͼ־ֵʵ廯ͼ־ ROWID P!j"#$&(*@+_,-0ʵ廯ͼ־ʵ廯ͼ־ijЩʵ廯ͼ־ʵ廯ͼά״̬ PL/SQL ظľۼϵ DISTINCT Ӿʵ廯ͼʹ MIN MAX ۼʵ廯ͼٺѡбеһؼSELECT һֹһеıʽʵ廯ͼһظֻỰıʽʵ廯ͼһкʵ廯ͼʹһ REF Ӿʵ廯ͼһͼ 3D5n68:@AJBnCDʵ廯ͼ FROM беԶ̱ͼʵ廯ͼ FROM беһͬʵ廯ͼ FROM б SYS еĶHAVING Ӿйµľۼʵ廯ͼʹ WHERE HAVING ӾеĹѯ LEFT OUTER, RIGHT OUTER FULL OUTER ѡбеıʽ˶ͼ GROUP BY Ӿ, ޾ۼҼģʽС 9.0ʵ廯ͼһԶ̶, ON COMMIT ʱˢ¶վ EVFGHIJKLLMbNOPQ GROUP BY ȱ GROUPING_ID GROUPING 鼯ظڷ֧־ۼʱ, ڲģʽ 9.0 ߶ڿˢ, ֧ģʽ 8.1 Ӳѯ UNION ʵ廯ͼӲѯʵ廯ͼӲѯWHERE ӾеĶӲѯ㹦ܵҪվ rowid վϵ Oracle 汾ִ֧ʵ廯ͼʵ廯ͼҪӻ̫ RPSjTUVWXYCZi[\]ڿˢ, ֱ֧ʽagg(expr) ҪӦ SUM(expr) agg(expr) ҪӦ COUNT(expr) agg(expr) ҪӦ MIN(expr) agg(expr) ҪӦ MAX(expr) agg(expr) ҪӦ AVG(expr) agg(expr) ҪӦ VARIANCE(expr) agg(expr) ҪӦ STDDEV(expr) agg(expr) ҪӦ agg(expr*expr) agg(expr) ҪӦ agg(expr+expr) agg(expr) ҪӦ SUM(expr*expr) Ƿܽõԭ ^J_e`abcde=foghѡбв COUNT(*)ʹ SUM(expr) ʱ, δṩ COUNT(expr)ʹþۼʱ, δṩ GROUP BY ӾGROUP BY Ӿ, δʹþۼ鿴 REFRESH_FAST_AFTER_INSERT ԭĬϵڸʽֻỰõĶԶӲѯҪ 9.0 Իڴʵ廯ͼ ON COMMIT Ҫ 9.0 Ի UNION , ѡбͬӲѯͼ FROM б, С 9.0ͼϲ, Ӳѯͼ FROM б iPjklmno@pZqzrstڴ MV, FROM бв֧ڲͼӲѯʹʹͼϲ, MV Ҳɿˢ¾ GSETS Ķѯδȷ grouping_id GSETS ĶѯظPCT ʵ廯ͼеκδӱ޷һд, PCT κδӱʵ廯ͼϽòѯдʵ廯ͼָΪ NEVER REFRESH鿴 REFRESH_FAST_AFTER_ONETAB_DML ԭϸϢûʵ廯ͼ־޷ʵ廯ͼ־ʹö ID ʵ廯ͼΪ BUILD DEFERRED uPvawuxyz{|.}M~qmv ־ûкżس־ʵ廯ͼǴӲ֧ PCT ľɰ汾ĸʵ廯ͼڶѯо WITH Ӿʵ廯ͼзչ UNION , һµⲿ UNION , ʵ廯ͼӲSELECT бûдӱ rowidڲûΨһԼʵ廯ͼû UNION ALL UNION ALL MV еijЩѯ鲻ܿˢͼд UNION ALL MV ̫ P  `yͼд UNION ALL MV ͼ SELECT бƥMV д UNION ALL ͼ, DzܿˢµĴ UNION ALL MV ҪΪ >= 9.2ûκԼ SPREADSHEET Ӿͨ PCT PARTITION BY SPREADSHEET в PCT ıʽ޷ۼ PCT ıʽѡбȱٷؼֻ PMARKER PARTITIONED OUTER JOINʵ廯ͼλⲿ϶ڴ MV, FROM бв֧ͼ\n   x   ʵ廯ͼSQL PIVOT UNPIVOT MV ־Ͳݻύ SCN MV ־ڲһ״̬ύ SCN MV ־ֵ֧ MVʵ廯ͼд CASE ʽָϢ¼ָ־δʹ SQL ָ, ݲѯƵԼѯִʱDZ, ƴʽṹijɱǰ SQL ָʧЧµ鰸Ĭµ鰸Ĭϱռµʵ廯ͼ鰸Ĭ D d  + O  µʵ廯ͼ鰸Ĭϱռµʵ廯ͼ־鰸Ĭϱռ SQL ָ, ȷ鰸ʱ, άʵ廯ͼˢµӰѡݵĽʱѹʱʹ ANALYSIS_SCOPEѹʱʹ ANALYSIS_SCOPESQL ָڹƵĸʽִָ޵ķִȫķ, ִ޵ķʱ϶, Խϵָ SQL ָɵĽ鰸ڹµʵ廯ͼĸʽ P p * J j   ѹʱʹ RANKING_MEASUREָӦ ON_DEMAND ǰ ON_COMMIT ˢʵ廯ͼűͱʾںʱĬϸʽҪ SQL ĿѡݵĿʼʱ SQL ָ鰸ĵĿռʹý鰸ݿ汾ŻҪıȫ޶бŻҪıȫ޶б˵ʾӦóΧļŻҪӦóбŻҪӦóб J n E     ŻҪӦóģбŻҪӦóģбִʺϽŻ SQL ûбִвʺϽŻ SQL ûбԳ SQL еıбвκָ, ôͲŻҪԳ SQL еıĿбаһָ, ôͲŻҪδʹѹʱʹ VALID_ACTION_LISTִзʱµķ鰸Ĭϱռ䲻֧ > w  q  , IMPLEMENT_TASK һֹͣEnterprise Manager SQL ָ򵼵ʼEnterprise Manager SQL ָ򵼵ĬϹԴѹʱʹ VALID_MODULE_LIST, ûָй, ڽű Enterprise Manager SQL ָʾ RETAIN ָν STORAGE_CHANGE , ʹϸƥıʵ廯ͼָɽܵ幤ֵܵ V ~   4 N    ָ幤ܵDZڴֵָɽܵ幤ܵļȨֵָ幤ܵDZڴļȨֵҪоκضĿڹ·Ƶĸʽڽʱʹõķڽ鰸ķ͡Ȼ˳, ڷڼ, SQL ָմ˳Ԫؽڷ鰸ѱռлμṹϢڹ·ڵıռ V v    ! " L# h$ % & ʹòɨdzĹʹѹСĿ깤ʼɼ빤ѳɹɼ빤ɡɼ빤, дѼά %s.%sѶ %s.%s ά %s.%s ֮ʵؼ֡Ѽر %s.%s ά %s.%s ֮ʵؼ֡ά %s.%s ڱ %s.%s ϡûָķΧвκЧάûָķΧвκЧʵ빤ڴ治㡣빤 OCI : %s ' D( i) * + , - . 7/ W0 ά %s.%s ûΨһؼּЧ CREATE MATERIALIZED VIEW %s޷Ż MATERIALIZED VIEW %s޷Ż FOR UPDATE ʵ廯ͼ޷Żʵ廯ͼ ON PREBUILT ʵ廯ͼŵ, ޷һŻ޷Żʵ廯ͼԽпˢ޷Żʵ廯ͼԽһдWHERE/HAVING Ӿ̫, ޷ִһѯдڼܵϴʵ廯ͼ־