Oracle³£ÓòÙ×÷±Ê¼Ç
select name from v$datafile;
create dataspace tablespace datafile '/oracle/oradata/orcl/data01.dbf' size 1024m,'/oracle/oradata/orcl/data02.dbf' size 1024m autoextend on next 100m maxsize unlimited;
alter tablespace dataspace add datafile '/oracle/oradata/orcl/data03.dbf' size 1024m autoextend on next 100m maxsize unlimited;
alter database datafile '/oracle/oradata/orcl/data01.dbf' size 2048m autoextend on next 200m maxsize unlimited;
===========================================================
create user username identified by password default tablespace dataspace;
grant connect,resource to username;
drop user username cascade;
===========================================================
select a.tablespace_name "±í¿Õ¼äÃû",
total "±í¿Õ¼ä´óС",
free "±í¿Õ¼äÊ£Óà´óС",
(total - free) "±í¿Õ¼äʹÓôóС",
round((total - free) / total, 4) * 100 "ʹÓÃÂÊ %"
from (select tablespace_name, sum(bytes) free
from dba_free_space
group by tablespace_name) a,
(select tablespace_name, sum(bytes) total
from dba_data_files
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name;
===========================================================
exp username/password file=expdata.dmp log=expdata.log buffer=409600
imp username/password file=impdata.dmp log=impdata.log buffer=409600 full=y
===========================================================
create directory dump_dir as 'd:\bakdata';
select * from dba_directories;
grant read, write on directory dump_dir to username;
expdp username/password directory=dump_dir dumpfile=expdata.dmp logfi
Ïà¹ØÎĵµ£º
ÎÄÕÂÒ»£ºSCNÊÇʲô£¿The System Change Number
system change number (SCN)ÊÇÒ»¸ö·Ç³£ÖØÒªµÄ±ê¼Ç£¬OracleʹÓÃËüÀ´±ê¼ÇÊý¾Ý¿âÔÚ¹ýȥʱ¼äÄÚµÄ״̬ºÍ¹ì¼£¡£
OracleʹÓÃSCNÀ´±£´æËùÓб仯µÄ¹ì¼£¡£SCNÊÇÒ»¸öÂ߼ʱÖÓÀ´¼Ç¼Êý¾Ý¿âʼþ¡£Ëü·Ç³£µÄÖØÒª£¬²¢²»ÊÇÖ»ÊÇΪÁ˻ָ´¡£
SCNÓеãÀàËÆÓÚsequence£¬OracleÔÚSGAÖÐÔ ......
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚ ......
C#ʹÓÃSystem.Data.OracleClientÁ¬½ÓOracleÊý¾Ý¿â¡£Ö®Ç°ÔÚWinXPÉÏÕý³£ÔËÐеijÌÐòÒÆÖ²µ½ Windows 2008 x64ÉÏÖ®ºó¾ÍÁ¬²»ÉÏÊý¾Ý¿âÁË£¬´íÎóÐÅÏ¢ÈçÏ£º
³¢ÊÔ¼ÓÔØ Oracle¿Í»§¶Ë¿âʱÒý·¢BadImageFomatException¡£Èç¹ûÔÚ°²×°32λOracle¿Í»§¶Ë×é¼þµÄÇé¿öÏÂÒÔ64λģʽÔËÐУ¬½«³öÏÖ´ËÎÊÌâ¡£
´íÎóÔÒòÊÇÔÀ´WinXP»ú×ÓÉÏËù°²×°µÄOrac ......
дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾÁ¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓ ......