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

Legato±¸·ÝoracleµÄÎĵµÕûÀí

http://inthirties.com:90/viewthread.jsp?tid=1394
1 ÎÒÃÇÒѾ­ÔÚ±¸·Ý·þÎñÆ÷ÉϽ¨Á¢ÁËÒ»¸öcatalog¿â£¬¾ßÌåµÄ²Ù×÷¹ý³ÌÈçÏ£º
1£©²éѯÏÖÔÚµÄÊý¾Ý¿â
# sqlplus /nolog.
SQL>connect / as sysdba;
Connected.
SQL>select * from v$tablespace;
TS# NAME INC
———- ——————- —
0 SYSTEM YES
1 UNDOTBS1 YES
2 TEMP YES
3 CWMLITE YES
4 INDX YES
5 TOOLS YES
6 USERS YES
7 XDB YES
8 rows selected.
SQL>; sellect name,bytes,status from v$datafile;
NAME————-BYTES STATUS———-
/oracle/product/10g/oradata/legato/system01.dbf 5242880 SYSTEM
/oracle/oradata/legato/system01.dbf 262144000 SYSTEM
/oracle/product/10g/oradata/legato/undotbs01.dbf 5242880 ONLINE
NAME———— BYTES STATUS———-
/oracle/oradata/legato/undotbs01.dbf 209715200 ONLINE
/oracle/product/10g/oradata/legato/cwmlite01.dbf 5242880 ONLINE
/oracle/oradata/legato/cwmlite01.dbf 20971520 ONLINE
NAME————–BYTES STATUS- ——-
/oracle/product/10g/oradata/legato/indx01.dbf 5242880 ONLINE
/oracle/oradata/legato/indx01.dbf 26214400 ONLINE
/oracle/product/10g/oradata/legato/tools01.dbf 5242880 ONLINE
NAME————- BYTES STATUS——-
/oracle/oradata/legato/tools01.dbf 10485760 ONLINE
/oracle/product/10g/oradata/legato/users01.dbf 5242880 ONLINE
/oracle/oradata/legato/users01.dbf 26214400 ONLINE
NAME—————BYTES STATUS———-
/oracle/product/10g/oradata/legato/xdb01.dbf 5242880 ONLINE
/oracle/oradata/legato/xdb01.dbf 20971520 ONLINE
14 rows selected.
SQL>select INSTANCE_NAME,HOST_NAME,VERSION from v$instance;
INSTANCE_NAME———HOST_NAME——–VERSION——-
legato
linthdb
10.2.0.1.0
SQL>select username from dba_users;
USERNAME————–
SYS
SYSTEM
DBSNMP
OUTLN
OLAPSYS
WMSYS
6 rows select


Ïà¹ØÎĵµ£º

Oracle×Ö·û¼¯ÎÊÌâ×ܽá

ÊÕ²Ø×ÔijЩ¸ßÊÖµÄ×ܽᣬ²»¸Ò¶ÀÏí£¬ÓëÓÐÔµÀ´´ËÕß¹²Ïí¡£
-----------------------------------------------------------------------------------
Oracle×Ö·û¼¯ÎÊÌâ×ܽá
¾­³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝǨÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂǨÒÆʧ°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ ......

oracleÆô¶¯·ÖÎö

oracleÆô¶¯·½Ê½ÓëÃüÁî²ÎÊý»ã×Ü
±¾ÎÄÖ÷ÒªÊǶÔoracleµÄÆô¶¯·½Ê½ºÍÏà¹ØµÄÃüÁî²ÎÊý½øÐÐÒ»¸ö»ã×Ü£¬ÓÃÒÔ¼ÓÉîÓ¡Ïó¡£
OracleµÄÆô¶¯·½Ê½£º
startup nomount
startup mount
startup open (startupµÄĬÈÏÑ¡Ïî)
ÆäËû³£ÓõIJÎÊý£ºread only ,read write ,force,restrict
ÕâЩ²ÎÊý¿ÉÒÔÒ»ÆðʹÓÃ,±ÈÈç startup Óë startup open read ......

Oracle ÊÓͼ

Oracle ÊÓͼ
    ÊÓͼ: Äã¿ÉÒÔͨ¹ý´´½¨±íµÄÊÓͼÀ´±íÏÖÊý¾ÝµÄÂß¼­×Ó¼¯»òÊý¾ÝµÄ×éºÏ.ÊÓͼÊÇ»ùÓÚ±í»òÕßÁíÒ»¸ö
          ÊÓͼµÄÂß¼­±í,Ò»¸öÊÓͼ²¢²»°üº¬Ëü×Ô¼ºµÄÊý¾Ý,ËüÏóÒ»¸ö´°¿Ú,ͨ¹ý¸Ã´°¿Ú¿ÉÒԲ鿴»ò¸Ä±ä
         ......

oracleÖؽ¨Ë÷Òý

Ö£ÖØ˵Ã÷£º´ËÎÄÀ´×ÔÓÚÍøÂ磬ÈçÓÐÇÖȨÇë¸æÖ®£¡
µ¼¶Á£º
¡¡¡¡Öؽ¨Ë÷ÒýÓжàÖÖ·½Ê½£¬Èçdrop and re-create¡¢rebuild¡¢rebuild onlineµÈ¡£ÏÂÃæ¼òµ¥±È½ÏÕ⼸ÖÖ·½Ê½ÒìͬÒÔ¼°ÓÅȱµã£º
¡¡¡¡Ê×ÏȽ¨Á¢²âÊÔ±í¼°Êý¾Ý£º
¡¡¡¡SQL> CREATE TABLE TEST AS SELECT CITYCODE C1 from CITIZENINFO2;
¡¡¡¡Table created
¡¡¡¡SQL> ALTE ......

Oracle Approvals Management Actions

Actions
Every action belongs to an action type. An action type is a collection of actions having similar functionality. For example, actions in the absolute-job-level action type all require approvals up to a certain job level in the HR supervisory hierarchy.
ÿ¸öÐÐΪ¶¼ÊôÓÚÒ»ÖÖÐÐΪÀàÐÍ¡£Ã¿ÖÖÐÐΪÀà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ