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Êý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝǨÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂǨÒÆʧ°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ ......
Ò»¸öÔµĵÚÒ»Ìì
´úÂë (Ë«»÷´úÂ븴ÖƵ½Õ³Ìù°å)
SELECT to_date(to_char(SYSDATE,'yyyy-mm')||'-01','yyyy-mm-dd')
from dual
sysdate ΪÊý¾Ý¿â·þÎñÆ÷µÄµ±Ç°ÏµÍ³Ê±¼ä¡£
to_char Êǽ«ÈÕÆÚÐÍתΪ×Ö·ûÐ͵ĺ¯Êý¡£
to_date Êǽ«×Ö·ûÐÍתΪÈÕÆÚÐ͵ĺ¯Êý£¬Ò»°ãʹÓà yyyy-mm-dd hh24:mi:ss¸ñʽ£¬µ±Ã»ÓÐÖ¸¶¨Ê±¼ä²¿·Öʱ£¬ÔòÄ ......
OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇOracleÆóÒµ°æÖжÀÁ¢ÊշѵÄÒ»¸ö×é¼þ¡£ÒÔÏÂÊǶÔÓÚ·ÖÇø¼°±¾µØË÷ÒýµÄÒ»¸öʾÀý¡£
¡¡¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´ó
¡¡OracleµÄ·ÖÇø¼¼ÊõÔÚijЩÌõ¼þÏ¿ÉÒÔ¼«´óµÄÌá¸ß²éѯµÄÐÔÄÜ£¬ËùÒÔ±»¹ã·º²ÉÓᣴӲúÆ·ÉÏ˵£¬·ÖÇø¼¼ÊõÊÇ ......
---------------oracle ÈëÃÅ
´ò¿ª·þÎñÆ÷
net start oracleserviceORCL
´ò¿ª¼àÌýÆ÷
lsnrctl start
¹Ø±Õ·þÎñÆ÷
net stop oracleserviceORCL
¹Ø±Õ¼àÌýÆ÷
lsnrctl stop
-----------------------------
1.´´½¨±í
Create table ±íÃû
(×Ö¶ÎÃû Êý¾Ý ......
Ë÷Òý
Ë÷ÒýµÄÄ¿µÄÊÇÌá¸ß´æ´¢Êý¾ÝÒ³ÃæµÄËÙ¶È
·þÎñÆ÷ɨÃèË÷ÒýÒÔ»ñµÃÊý¾Ý´æ´¢µ¥ÔªµÄµØÖ·
Ë÷ÒýµÄÓŵãΪ£ºÌá¸ß²éѯµÄÖ´ÐÐËٶȡ¢ÊµÊ©Êý¾ÝµÄΨһÐÔ¡¢¼ÓËÙÁ˱íÖ®¼äµÄÁ¬½Ó
Ë÷ÒýµÄȱµãΪ£º´´½¨Ë÷ÒýÐèÒª»¨·Ñ½Ï¶àµÄʱ¼ä¡¢Ã¿¸ö´´½¨µÄË÷ÒýÁ¬Í¬ÔÏȵÄÊý¾ÝÔ´¶¼ÐèÒª¿Õ¼äÀ´´æ´¢Êý¾Ý¡¢Ã¿´ÎÐÞ¸ÄÊý¾ÝʱË÷Òý¶¼Òª¸üÐÂ
......