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

±±´óÇàÄñoracleѧϰ±Ê¼Ç8 9


±í·ÖÇøά»¤£º
Ìí¼Ó·ÖÇø£º
Alter table student add partition ·ÖÇøÃû values less than(100);
ɾ³ý·ÖÇø£º
Alter table student drop partition ·ÖÇøÃû;
½Ø¶Ì·ÖÇø£º
Alter table student truncate partition ·ÖÇøÃû;
ºÏ²¢·ÖÇø£º
Alter table student merge partitions ·ÖÇøÃû,...,·ÖÇøÃû into partition зÖÇøÃû;
Éæ¼°±í·ÖÇøµÄÊý¾Ý×Öµä
User_tab_partitions
User_ind_partitions
oracleÊý¾Ý¿â¶ÔÏó
ͬÒå´Ê£º£¨Ï൱ÓÚ±ðÃû£©
Êý¾Ý¿â¶ÔÏóµÄÌæ»»Ãû³Æ
˽ÓÐ Óû§×Ô¼º´´½¨
¹«Óà DBA´´½¨¸øËùÓÐÓû§Ê¹ÓÃ
´´½¨Í¬Òå´Ê
create synonym 
ɾ³ýͬÒå´Ê
drop synonym 
°üº¬ÓйØͬÒå´ÊµÄÐÅÏ¢
user synonyms 
ÐòÁУº
ÐòÁÐÊÇÄܹ»×Ô¶¯²úÉúÁ¬ÐøΪÒÖÖƵÄÊý¾Ý¿â¹²Ïí¶ÔÏó
Óësql server²»Í¬µÄÊÇ£¬oracleÖеÄÐòÁб»³Ö¾ÃµÄ±£´æÔÚÊý¾Ý¿âµ±ÖУ¬¶ø²»ÊÇ°ó¶¨ÔÚijһÁÐÉϵÄÔ¼Êø
create sequence sequence
[increment by n]
[start with n]
[{maxvalue n | nomaxvalue}]
[{minvalue n | nominvalue}]
[{cycle | nocycle}]  --µ½×î´óֵʱºòÊÇ·ñÑ­»·
[{cache n | nocache}]; --»º´æĬÈÏΪ20
Á½¸öÖØÒªÊôÐÔ£º
nextval ·µ»ØÏÂÒ»¸ö¿ÉÓõÄÖµ
currval »ñÈ¡µ±Ç°µÄÐòÁÐÖеÄÖµ
¶ÔÓÚÒ»¸öж¨ÒåµÄÐòÁбØÐëÏÈÓÃnextval²úÉúÖµ³õʼ»¯ÐòÁУ¬²Å¿ÉÒÔÓÃcurrval·µ»Øµ±Ç°Öµ¡£
Alter Sequence ÐÞ¸ÄÐòÁж¨Òå
Drop Sequence ɾ³ýÐòÁÐ
ÐòÁеÄÊý¾Ý×Öµä
USER_SEQUENCES
ʹÓÃÐòÁÐ
²åÈëʱ£ºinsert into ±íÃû values(ÐòÁÐÃû.nextval);
²éѯÐòÁе±Ç°Öµ£ºselect ÐòÁÐÃû.currval from dual(ÃûÒå±í);
ÐòÁÐÊǹ«ÓõĶÔÏó£¬ÔÚÆäËû±íÖвåÈëÐòÁÐֵʱ»á¼ÌÐøÐòÁÐÖеÄÖµ¶ø²¢ÖØпªÊ¼£¬ÐòÁв¢²»ÊôÓÚijһÕÅ±í¡£
ÊÓͼ£º
ÐéÄâ±í£¬Ò»ÖÖ²éѯ¡£
Óï·¨£ºcreate or replace [force] view ÊÓͼÃû as
select ...
  --Èç¹ûÊÓͼ²»´æÔÚÔò´´½¨ÐÂÊÓͼ£¬·ñÔòÌæ»»Ô­ÓÐÊÓͼ
order by ×Ó¾ä¿ÉÒÔÓÃÀ´ÅÅÐò
force Ñ¡ÏîÓÃÓÚ´´½¨´øÓдíÎóµÄÊÓͼ
²éѯÒýÓò»´æÔÚµÄ±í£¬²éѯÒýÓÃÎÞЧÁУ¬´´½¨ÊÓͼʱûÓÐÏàӦȨÏÞ
oracle±íÖÐÓÐÁ½¸öÒþ²ØÁÐ rowid rownumber£¬·Ö±ð±íʾÐбêʶ·ûºÍÊä³ö½á¹û¼¯ÖеÄÐбàºÅ
Èç¹ûҪʵÏÖsql serverÖеÄtop¹Ø¼ü×Ö¹¦ÄÜ£¬¿ÉÒÔͨ¹ý×Ó²éѯ£¬È磺
select xx,xxx from
(select * from ±íÃû order by xx desc)
where rownum <=5
ÕâÑù×ӾͲé³öÁ˵¹ÐòÅÅÁÐÇ°5Ìõ¼Ç¼


Ïà¹ØÎĵµ£º

Àí½âOracle×Ö·û¼¯ÎÊÌâ

Ò»£®ÒýÑÔ
    ORACLEÊý¾Ý¿â×Ö·û¼¯£¬¼´OracleÈ«Çò»¯Ö§³Ö(Globalization Support)£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLEΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle¿ÉÒÔÖ§³Ö¶àÖÖÓïÑÔ¼°×Ö·û¼¯£¬ÆäÖÐoracle8 ......

oracle´´½¨Ë÷Òý

Êʵ±µÄʹÓÃË÷Òý¿ÉÒÔÌá¸ßÊý¾Ý¼ìË÷Ëٶȣ¬¿ÉÒÔ¸ø¾­³£ÐèÒª½øÐвéѯµÄ×ֶδ´½¨Ë÷Òý
oracleµÄË÷Òý·ÖΪ5ÖÖ:ΨһË÷Òý£¬×éºÏË÷Òý£¬·´Ïò¼üË÷Òý£¬Î»Í¼Ë÷Òý£¬»ùÓÚº¯ÊýµÄË÷Òý
´´½¨Ë÷ÒýµÄ±ê×¼Óï·¨:
CREATE INDEX Ë÷ÒýÃû ON ±íÃû (ÁÐÃû)
     TABLESPACE ±í¿Õ¼äÃû;
´´½¨Î¨Ò»Ë÷Òý:
CREATE unique INDEX Ë÷ÒýÃû ......

"ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾"½â¾ö°ì·¨

1.Ñ¡ÔñÄúËù°²×°OrcaleµÄĿ¼£¬ÀýÈ磺C:\Oracle
2.ÓÒ¼üµã»÷£¬µ¯³ö“ÊôÐÔ”¶Ô»°¿ò£¬Ñ¡Ôñ“°²È«”Ñ¡Ï
3.Ìí¼Ó“IUser_»ú×ÓÃû³Æ”Óû§µÄȨÏÞ£¬²ÉÓÃÍêÈ«¿ØÖƵķ½Ê½
4.È·¶¨Ó¦Óúó£¬ÔÚÑ¡Ôñ“°²È«”Ñ¡ÏÖÐÑ¡Ôñ“IUser_»ú×ÓÃû³Æ”Óû§£¬µã»÷¸ß¼¶
5.Ñ¡ÔñÑ¡Ôñ¿ò“ÓÃÔÚ ......

oracleµ÷ÓÃjavaÀà±éÀú´ÅÅÌÎļþ

ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´Òâ˼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......

oracleÖ´Ðмƻ®

±¾ÎĽéÉÜÁËORACLEÖ´Ðмƻ®µÄһЩ»ù±¾¸ÅÄ¹©Ñ§Ï°Ó¦Óá£
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ