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

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


Ïà¹ØÎĵµ£º

oracle ¹éµµÓë·Ç¹éµµÄ£Ê½

ÔÚ
Oracle
Êý
¾Ý¿â
ÖУ¬
Ö÷ÒªÓÐÁ½ÖÖ
ÈÕÖ¾
²Ù×÷ģʽ£¬·Ö±ðΪ·Ç¹é
µµÄ£Ê½Óë¹éµµÄ£Ê½¡£Ä¬ÈÏÇé¿öÏ£¬Êý¾Ý¿â
²É
ÓõÄÊǷǹ鵵ģʽ
¡£×÷Ϊһ¸öºÏ¸ñµÄÊý¾Ý¿â¹Ü
Àí
Ô±£¬Ó¦µ±ÉîÈëÁ˽âÕâÁ½ÖÖÈÕÖ¾²Ù×÷ģʽµÄÌØµã£¬²¢ÇÒÔÚÊý¾Ý¿â½¨Á¢Ê±£¬Ñ¡
ÔñºÏÊʵIJÙ×÷ģʽ¡£
¡¡¡¡±ÊÕß
½ñÌì¾Í̸̸×Ô¼º¶ÔÕâÁ½ÖÖ²Ù×÷ģʽµÄÀí½â£¬²¢ÇÒ¸ø³ö ......

oracle´¦Àíʱ¼äµÄ³£Óú¯Êý

36.ADD_MONTHS
¡¡¡¡Ôö¼Ó»ò¼õÈ¥Ô·Ý
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡200002
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),-2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡199910
¡¡¡¡37.LAST_DAY
¡¡¡¡·µ» ......

C#ÔÚ64λ²Ù×÷ϵͳÉÏÁ¬½ÓOracleµÄÎÊÌâºÍ½â¾ö·½°¸


C#ʹÓÃSystem.Data.OracleClientÁ¬½ÓOracleÊý¾Ý¿â¡£Ö®Ç°ÔÚWinXPÉÏÕý³£ÔËÐеijÌÐòÒÆÖ²µ½ Windows 2008 x64ÉÏÖ®ºó¾ÍÁ¬²»ÉÏÊý¾Ý¿âÁË£¬´íÎóÐÅÏ¢ÈçÏ£º
³¢ÊÔ¼ÓÔØ Oracle¿Í»§¶Ë¿âʱÒý·¢BadImageFomatException¡£Èç¹ûÔÚ°²×°32λOracle¿Í»§¶Ë×é¼þµÄÇé¿öÏÂÒÔ64λģʽÔËÐУ¬½«³öÏÖ´ËÎÊÌâ¡£
´íÎóÔ­ÒòÊÇÔ­À´WinXP»ú×ÓÉÏËù°²×°µÄOrac ......

oracle³£Óú¯Êý,sybase³£Óú¯Êý

oracle³£Óú¯Êý-----------------------------------------------
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- - ......

Oracle³£ÓòÎÊýÉèÖÃ

²éѯµ±Ç°Ê¹ÓõÄÓαêÊý¾Ý£ºselect count(*) from v$open_cursor
²éѯµ±Ç°×î´óÓαêÊý£ºshow parameter open_cursors;
ÐÞ¸Ä×î´óÓαêÊý£ºalter system set open_cursors=1000 scope=spfile;
=========================================================
²éѯµ±Ç°×î´ó»á»°Êý£ºshow parameter sessions;
ÐÞ¸Ä×î´ó»á»°Êý£ºalt ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ