Oracleѧϰ±Ê¼Çժ¼10
<1>Âß¼±¸·Ý
²»ÓÃÈ¥¿½±´Êý¾Ý¿âµÄÎïÀíÎļþ
±¸·ÝÂß¼ÉϵĽṹ
ÍⲿµÄ¹¤¾ß:µ¼³öºÍµ¼ÈëµÄ¹¤¾ß
DOSϵÄÃüÁî cmdÏÂÖ´ÐÐ
µ¼³öexp exportËõдÐÎʽ
²é¿´°ïÖú exp help=y
ʹÓòÎÊýÎļþµ¼³ö
exp parfile=c:\abc.par
>>>abc.parµÄÄÚÈÝ
a)scottÓû§Á¬½Óµ¼³ö×Ô¼ºµÄËùÓжÔÏó
userid=scott/tiger --Á¬½ÓµÄÓû§scott
file=c:\a1.dmp --µ¼³öµÄÎļþµÄÃû×Öa1.dmp
--µ¼³öÁËscottÓû§µÄËùÓжÔÏó
b)ÓÃsystemÁ¬½ÓÀ´µ¼³öscottϵÄËùÓжÔÏó
exp parfile=c:\sys.par
>>>>sys.parµÄÄÚÈÝ
userid=system/manager
file=c:\b1.dmp
owner=(scott) --µ¼³öscottÓû§µÄËùÓжÔÏó
µ¼³ö¶à¸öÓû§µÄÊý¾Ý
½¨Á¢Ò»¸ö²âÊÔÓû§ test
grant connect,resource
to test identified by t123;
alter user test
default tablespace users
temporary tablespace temp;
create table student(
stu_id number(4) primary key,
stu_name varchar2(20),
stu_score number(2)
);
insert into student values (1000,
'Mike',95);
insert into student values (1001,
'John',90);
µ¼³öscottºÍtestϵÄËùÓжÔÏó????
>>>userid=system/manager
file=c:\st.dmp
owner=(scott,test)
µ¼³öscottϵÄemp,dept±í????
>>>userid=system/manager
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ΪÁËÈ·¶¨±í¿Õ¼äÖаüº¬ÄÇЩÄÚÈÝ£¬ÔËÐУº
select owner,segment_name,segment_type
from dba_segments
where tablespace_name='<name of tablespace>'
²éѯ±í¿Õ¼ä°üº¬¶àÉÙÊý¾ÝÎļþ¡£
select file_name, tablespace_name
from dba_data_files
where tablespace_name ='<name of t ......
×î½ü×öÁËÒ»¸öϵͳ×Ô¶¯³é¼ìµÄ¶«¶«£¬OracleÖд´½¨µÄJob,»áÔÚ×Ô¼ºÉ趨µÄʱ¼ä×Ô¶¯ÔËÐд洢¹ý³Ì¡£ÏÂÃæÎª×î½ü×ܽáµÄ¶«¶«
¼ÙÉèÄãµÄ´æ´¢¹ý³ÌÃûΪPROC_RAIN_JM
ÔÙдһ¸ö´æ´¢¹ý³ÌÃûΪPROC_JOB_RAIN_JM
ÄÚÈÝÊÇ£º
///////////////////////////////////////////////////////////////////
Create Or Replace Procedure ......
1¡¢¶à¹¤Áª»úÖØ×÷ÈÕÖ¾Îļþ
¡¡¡¡Ã¿¸öÊý¾Ý¿âʵÀý¶¼ÓÐÆä×Ô¼ºµÄÁª»úÖØ×÷ÈÕÖ¾×飬ÔÚ²Ù×÷Êý¾Ý¿âʱ£¬OracleÊ×ÏȽ«Êý¾Ý¿âµÄÈ«²¿¸Ä±ä±£´æÔÚÖØ×÷ÈÕÖ¾»º³åÇøÖУ¬ËæºóÈÕÖ¾¼Ç¼Æ÷½ø³Ì£¨LGWR£©½«Êý¾Ý´Óϵͳ¹²ÓÃÇøSGA£¨System Global Area£©µÄÖØ×÷ÈÕÖ¾»º³åÇøÐ´ÈëÁª»úÖØ×÷ÈÕÖ¾Îļþ£¬ÔÚ´ÅÅ̱ÀÀ£»òʵÀýʧ°Üʱ£¬¿ÉÒÔͨ¹ýÓëÖ®Ïà¹ØµÄÁª»úÖØ×÷ÈÕÖ¾ ......
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂÎª×ªÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......