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

Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©


Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> desc dba_users
 Name                                   Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME                         NOT NULL VARCHAR2(30)
 USER_ID                             NOT NULL NUMBER
 PASSWORD                                 VARCHAR2(30)
 ACCOUNT_STATUS                   NOT NULL VARCHAR2(32)
 LOCK_DATE                                       DATE
 EXPIRY_DATE                                    DATE
 DEFAULT_TABLESPACE                    NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE&n


Ïà¹ØÎĵµ£º

ORACLE Êý¾Ý¿âÃû¡¢ÊµÀýÃû¡¢ORACLE_SIDµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇ ......

Oracle Êý¾ÝÉú³É Ë÷Òý

1.½¨±í
CREATE TABLE qq(
       qq_num integer
);
2.²åÈëÊý¾Ý
²åÈëÊý¾ÝµÄ·½·¨ÓкܶàÖÖ£¬µ«ÊÇÒª²åÈë3ÒÚÊý¾Ý£¬±ØÐëÒªÓиßЧµÄËã·¨¡£ÔÚ²åÈëÊý¾ÝʱÎÒÓÃÁË×µÄ°ì·¨£¬²ÉÓÃPL/SQLÀûÓÃÁ÷³Ì¿ØÖƵÄLOOPÓï¾ä²åÈ롣ͬʱÎÒÒ²¿´ÁËÍøÉϵIJåÈëЧÂʵÄÓÅ»¯£¬ÔõÑùÀûÓýÏÉÙµÄʱ¼äÉú³É½Ï¶àµÄ²âÊÔÊý¾Ý¡£¸ø ......

Oracle¶¯Ì¬ÐÔÄÜÊÓͼѧϰ֮ V$ROLLSTAT

À´Ô´ÓÚhttp://hi.baidu.com/edeed/blog/item/33576327d1b73d00918f9dd4.html
±¾ÊÓͼ×ÔÆô¶¯¼´±£³Ö²¢¼Ç¼¸÷»Ø¹ö¶Îͳ¼ÆÏî¡£ÔÚѧϰ±¾ÊÓͼ֮ǰ£¬ÎÒÃÇÏÈÀ´Á˽âһϻعö¶Î(rollback segment)µÄÏà¹Ø¸ÅÄ
»Ø¹ö¶Î¸ÅÊö
»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐ ......

OracleÓÃimpµ¼ÈëÓû§±íʱѡÔñ±í¿Õ¼äµÄÎÊÌâ

×Ô¼º¾õµÃ¶ÔOracle»¹ÕÆÎյò»´í£¬²»¹ý×òÌì¸ô±ÚʵÑéÊÒµÄͬѧÎÊÁËÎÒÒ»¸öÎÊÌâÈÃÎÒÓôÃÆÁËÒ»°Ñ¡£ËýÔÚÒ»¸öÊý¾Ý¿âÀï°ÑÒ»¸öÓû§AµÄÔÚ±í¿Õ¼äAAÉϵıí
ÓÃexpµ¼³öµ½exp.dmpÎļþÖУ¬ÔÙ°ÑËüµ¼Èëµ½Áíһ̨»úÆ÷ÉϵÄÊý¾Ý¿âÀÕâʱËýÓõÄÊÇÓû§B£¬Ä¬Èϱí¿Õ¼äÊÇBB£¬µ«ÊÇÓÃimpµ¼ÈëʱÎÒÃÇ·¢ÏÖ±íÊǵ¼Èë
µ½ÁËBÓû§Ï£¬µ«ÊÇ»¹ÊÇ´æÔÚÁËAA±í¿Õ¼äÀïÃæ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ