³£ÓõÄORACLE PLSQL¹ÜÀíÃüÁî
³£ÓõÄORACLE PL/SQL¹ÜÀíÃüÁî
ÊìϤORACLE¹ÜÀíµÄÒ»¶¨¶ÔÕâЩÃüÁî²»»áÄ°Éú£¬²»¹ý¶ÔÓÚÎÒÕâ¸ö¸Õ½Ó´¥ORACLE¹ÜÀíµÄÀ´Ëµ£¬»¹ÊÇÓбØÒª×öϼǼ£¬ÒÔ±ãËæʱ²é¿´¡£
Ò» µÇ¼SQLPLUS
sqlplusÓû§Ãû/ÃÜÂë@Êý¾Ý¿âʵÀýasµÇ¼½ÇÉ«;
Èç:Óû§sys(ÃÜÂëΪ123)ÒÔsysdbaµÄ½ÇÉ«µÇ¼Êý¾Ý¿âORACL£¬ÎÒÃÇ¿ÉÒÔÊäÈ룺sqlplus sys/123@oracl as sysdba;
ÕâÖֵǼ·½Ê½»áÖ±½Ó±©Â¶ÃÜÂ룬Èç¹ûÏëÒþ²ØÃÜÂ룬¿ÉÒÔÔÚ´ËÊ¡ÂÔÃÜÂëµÄÊäÈ룬È磺sqlplus sys@oracl as sysdba;»Ø³µÒÔºóORACLE»á¸ø³öÊäÈëÃÜÂëµÄÌáʾ·û¡£
µÇ¼ÒÔºóÈç¹ûÏëÇл»ÆäËûµÄÓû§£¬¿ÉÒÔÖ±½ÓʹÓÃconnect ÃüÁî,È磺connect user2/password@oracl as sysdba,ͬÉÏÒ»Ñù£¬¿ÉÒÔ½«ÃÜÂë·Ö¿ªÊäÈë¡£
¶þ Í˳öSQLPLUS
quit£»
Èý ´´½¨Óû§
create userÓû§Ãûidentified byÃÜÂë;
È磺´´½¨Óû§CKSP£¬ÃÜÂëΪ123: create user cksp identified by 123;
ËÄ ¸øÓû§·ÖÅä½ÇÉ«»òȨÏÞ
grant *** to ***;
È磺¸ø¸Õ²ÅµÄÓû§·ÖÅä½ÇÉ«DBA:grant dba to cksp;
·ÖÅäcreate tableȨÏÞ£ºgrant
Îå ɾ³ýÓû§
drop userÓû§[cascade];
ÆäÖÐcascadeÊÇ¿ÉÑ¡µÄ£¬Èç¹ûÊäÈëÁË£¬Ôò±íʾɾ³ý¸ÃÓû§¼°ËùÓÐÊý¾Ý¡£
È磺ɾ³ýÉÏÃæ´´½¨µÄÓû§CKSP¼°ËûµÄËùÓÐÊý¾Ý£ºdrop user cksp cascade;
Ïà¹ØÎĵµ£º
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......
ʲôÊÇË÷Òý
¡¡¡¡
¡¡¡¡Ë÷ÒýÊǽ¨Á¢ÔÚ±íµÄÒ»Áлò¶à¸öÁÐÉϵĸ¨Öú¶ÔÏó£¬Ä¿µÄÊǼӿì·ÃÎʱíÖеÄÊý¾Ý£»
¡¡¡¡
¡¡¡¡Oracle´æ´¢Ë÷ÒýµÄÊý¾Ý½á¹¹ÊÇB*Ê÷£¬Î»Í¼Ë÷ÒýÒ²ÊÇÈç´Ë£¬Ö»²»¹ýÊÇÒ¶×ӽڵ㲻ͬB*ÊýË÷Òý£»
¡¡¡¡
¡¡¡¡Ë÷ÒýÓɸù½Úµã¡¢·ÖÖ§½ÚµãºÍÒ¶×Ó½Úµã×é³É£¬Éϼ¶Ë÷Òý¿é°üº¬Ï¼¶Ë÷Òý¿éµÄË÷ÒýÊý¾Ý£¬Ò¶½Úµã°üº¬Ë÷ÒýÊý¾ÝºÍÈ·¶¨ÐÐ ......
Ò». ¼ì²é¹²ÏíÉ豸
Ò»°ãÇé¿öÏ£¬ ´æ·ÅOCR ºÍ Voting Disk µÄOCFS2 »òÕßraw ¶¼ÊÇ×Ô¶¯Æô¶¯µÄ¡£ Èç¹ûËûÃÇûÓÐÆô¶¯£¬RAC ¿Ï¶¨ÊÇÆô¶¯²»Á˵ġ£
1.1 Èç¹ûʹÓÃocfs2µÄ£¬¼ì²éocfs2 ״̬
/etc/init.d/o2cb status
ÔÚ¹ÒÔØ֮ǰ£¬/etc/init.d/o2cb st ......
Oracleѧϰ±Ê¼ÇһʵÀý
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
Oracleѧϰ±Ê¼ÇһʵÀý
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
Oracleѧϰ±Ê¼ÇÈý·½°¸
ʵÀý
ÔÚOracleºÍSqlServerÖж¼ÓÐʵÀýһ˵£¬µ«ÕâÁ½¸öʵÀýÊDz»Í¬µÄ¡£
ÔÚSql ......
Oracleѧϰ±Ê¼ÇÈý·½°¸
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
·½°¸£¨schema£©
ÔÚOracleÖУ¬ÎÒÃÇ¿ÉÒÔ¶ÔÊý¾Ý¿â¶ÔÏó·Ö×飬Õâ¾ÍÊÇ·½°¸£¨schema£©£¬ÊÇÊý¾Ý¿â¶ÔÏóµÄ¼¯ºÏ¡£Ò»¸öÓû§Ò»°ã¶ÔÓ¦Ò»¸öschem ......