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

linux oracleËõС»Ø¹ö±í¿Õ¼ä´óСundotbs01.dbf


http://hi.baidu.com/lu_xinzhong/blog/item/4ff92b1725dec505c83d6d09.html
»Ø¹ö±í¿Õ¼ä´óС
-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄUNDO TABLESPACE
Create UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/orcl/UNDOTBS02.DBF' SIZE 100M REUSE AUTOEXTEND ON;
-- ÉèÖÃеıí¿Õ¼äΪϵͳUNDO_TABLESPACE
Alter SYSTEM SET UNDO_TABLESPACE=UNDOTBS2;
-- Drop ¾ÉµÄ±í¿Õ¼ä
Drop TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES; (Íê³Éºóɾ³ý±í¿Õ¼äºÍÊý¾Ý/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF)
Select * from DBA_TABLESPACES;
È»ºó½øÐгöϲÙ×÷£º
-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄUNDO TABLESPACE
Create UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF' SIZE 100M REUSE AUTOEXTEND ON;
-- ÉèÖÃеıí¿Õ¼äΪϵͳUNDO_TABLESPACE
Alter SYSTEM SET UNDO_TABLESPACE=UNDOTBS1;
-- Drop ¾ÉµÄ±í¿Õ¼ä
Drop TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;
--²é¿´ËùÓбí¿Õ¼äµÄÇé¿ö
Select * from DBA_TABLESPACES;
Íê³Éºóɾ³ý/u01/app/oracle/oradata/orcl/UNDOTBS02.DBF¡£
Èç¹ûÁÙʱ±í¿Õ¼äºÜ´ó´¦ÀíµÄ·½·¨ÀàËÆ¡£


Ïà¹ØÎĵµ£º

Èý¿î Linux ϵÄÃâ·Ñ×ÀÃæ¼¶É±¶¾Èí¼þ(ͼ)


ÓÉÓÚ Linux Á¼ºÃµÄÓû§È¨ÏÞ¹ÜÀíÌåϵ£¬²¡¶¾ÍùÍùÊÇ Linux ϵͳ¹ÜÀíÔ±×îºó²ÅÐèÒª¿¼ÂǵÄÎÊÌâ¡£ÒÔÍù£¬Linux ÉϵÄɱ¶¾Èí¼þÖ÷ÒªÊÇΪÆóÒµµÄÓʼþºÍÎļþ·þÎñÆ÷ËùÉè¼ÆµÄ¡£Èç½ñ£¬Ëæ×Å Linux ×ÀÃæÓû§ÊýÁ¿µÄÔö³¤£¬×ÀÃæÓû§ÔÚÊÜÒæÓÚ Linux ϵͳ¶Ô²¡¶¾½ÏÇ¿µÄÌìÈ»ÃâÒßÁ¦µÄͬʱ£¬Ò²ÐèҪɱ¶¾Èí¼þÇåÀí´ÓÍøÂç»òUÅÌ´øÀ´µÄWIndows²¡¶¾¡£¾¡¹ÜÄÇЩ ......

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

Linux GCC°²×° (ת)

Ŀǰ£¬GCC¿ÉÒÔÓÃÀ´±àÒëC/C++¡¢FORTRAN¡¢JAVA¡¢OBJC¡¢ADAµÈÓïÑԵijÌÐò£¬¿É¸ù¾ÝÐèҪѡÔñ°²×°Ö§³ÖµÄÓïÑÔ¡£±¾ÎÄÒÔÔÚRedhat LinuxÉϰ²×°GCC4.1.2ΪÀý(ÒòÔÚÏîÄ¿¿ª·¢¹ý³ÌÖÐÒªÇóʹÓã¬Ã»ÓÐÓÃ×îеÄGCC°æ±¾)£¬½éÉÜGCCµÄ°²×°¹ý³Ì¡£
°²×°Ö®Ç°£¬ÏµÍ³ÖбØÐëÒªÓÐcc»òÕßgccµÈ±àÒëÆ÷£¬²¢ÇÒÊÇ¿ÉÓõ쬻òÕßÓû·¾³±äÁ¿CCÖ¸¶¨ÏµÍ³ÉϵıàÒëÆ÷¡£È ......

linux¿ÚÁîÏà¹Ø£¨passwd/shadow£©

      ÔÚlinuxÖУ¬¿ÚÁîÎļþÔÚ/etc/passwdÖУ¬ÔçÆÚµÄÕâ¸öÎļþÖ±½Ó´æ·Å¼ÓÃܺóµÄÃÜÂ룬ǰÁ½Î»ÊÇ"ÑÎ"Öµ£¬ÊÇÒ»¸öËæ»úÊý£¬ºóÃæ¸úµÄÊǼÓÃܵÄÃÜÂ롣ΪÁ˰²È«£¬ÏÖÔÚµÄlinux¶¼ÌṩÁË /etc/shadowÕâ¸öÓ°×ÓÎļþ£¬ÃÜÂë·ÅÔÚÕâ¸öÎļþÀïÃæ£¬²¢ÇÒÊÇÖ»ÓÐroot¿É¶ÁµÄ¡£
ÏÂÃæÀ´·ÖÎöÒ»ÏÂ/etc/passwdÎļþ£¬ËûµÄÿ¸öÌõÄ¿Ó ......

LinuxÈí¼þ°²×°

               LinuxÈí¼þ°²×°
            ÔÚLinuxϵͳÖУ¬Èí¼þ°²×°³ÌÐò±È½Ï·×·±¸´ÔÓ£¬²»¹ý×î³£¼ûµÄÓÐÁ½ÖÖ£º
            1£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ