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
Ïà¹ØÎĵµ£º
ÊÕ²Ø×ÔijЩ¸ßÊÖµÄ×ܽᣬ²»¸Ò¶ÀÏí£¬ÓëÓÐÔµÀ´´ËÕß¹²Ïí¡£
-----------------------------------------------------------------------------------
Oracle×Ö·û¼¯ÎÊÌâ×ܽá
¾³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝǨÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂǨÒÆʧ°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ ......
oracleÆô¶¯·½Ê½ÓëÃüÁî²ÎÊý»ã×Ü
±¾ÎÄÖ÷ÒªÊǶÔoracleµÄÆô¶¯·½Ê½ºÍÏà¹ØµÄÃüÁî²ÎÊý½øÐÐÒ»¸ö»ã×Ü£¬ÓÃÒÔ¼ÓÉîÓ¡Ïó¡£
OracleµÄÆô¶¯·½Ê½£º
startup nomount
startup mount
startup open (startupµÄĬÈÏÑ¡Ïî)
ÆäËû³£ÓõIJÎÊý£ºread only ,read write ,force,restrict
ÕâЩ²ÎÊý¿ÉÒÔÒ»ÆðʹÓÃ,±ÈÈç startup Óë startup open read ......
Oracle ÊÓͼ
ÊÓͼ: Äã¿ÉÒÔͨ¹ý´´½¨±íµÄÊÓͼÀ´±íÏÖÊý¾ÝµÄÂß¼×Ó¼¯»òÊý¾ÝµÄ×éºÏ.ÊÓͼÊÇ»ùÓÚ±í»òÕßÁíÒ»¸ö
ÊÓͼµÄÂß¼±í,Ò»¸öÊÓͼ²¢²»°üº¬Ëü×Ô¼ºµÄÊý¾Ý,ËüÏóÒ»¸ö´°¿Ú,ͨ¹ý¸Ã´°¿Ú¿ÉÒԲ鿴»ò¸Ä±ä
  ......
Ö£ÖØ˵Ã÷£º´ËÎÄÀ´×ÔÓÚÍøÂ磬ÈçÓÐÇÖȨÇë¸æÖ®£¡
µ¼¶Á£º
¡¡¡¡Öؽ¨Ë÷ÒýÓжàÖÖ·½Ê½£¬Èçdrop and re-create¡¢rebuild¡¢rebuild onlineµÈ¡£ÏÂÃæ¼òµ¥±È½ÏÕ⼸ÖÖ·½Ê½ÒìͬÒÔ¼°ÓÅȱµã£º
¡¡¡¡Ê×ÏȽ¨Á¢²âÊÔ±í¼°Êý¾Ý£º
¡¡¡¡SQL> CREATE TABLE TEST AS SELECT CITYCODE C1 from CITIZENINFO2;
¡¡¡¡Table created
¡¡¡¡SQL> ALTE ......
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.
ÿ¸öÐÐΪ¶¼ÊôÓÚÒ»ÖÖÐÐΪÀàÐÍ¡£Ã¿ÖÖÐÐΪÀà ......