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Êý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðÊǵ¼³ö£¯µ¼È루EXP/IMP£©¡¢Èȱ¸·ÝºÍÀ䱸·Ý¡£µ¼³ö±¸¼þÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
Ò»¡¢ µ¼³ö£¯µ¼È루Export£¯Import£©
ÀûÓÃExport¿É½«Êý¾Ý´ÓÊý¾Ý¿âÖÐÌáÈ¡³öÀ´£¬ÀûÓÃImportÔò¿É½«ÌáÈ¡³öÀ´µÄÊý¾ÝËͻص½OracleÊý¾Ý¿âÖÐÈ¥¡£
£±¡¢ ¼òµ¥µ¼³öÊý¾Ý£¨Export£©ºÍµ¼ ......
ÎÒÏÖÔÚÔÚ×öÒ»¸öOracleÊý¾Ýµ¼È룬Ҫ½«EXCELÊý¾Ýµ¼Èëµ½OracleÊý¾Ý¿âÖУ¬ÏȶÁÈ¡Êý¾Ý£¬½«Êý¾Ý±£´æÔÚÒ»ÕÅÁÙʱ±íÖУ¬È»ºóµ¼Èë֮ǰ¶ÔÁÙʱ±íÖÐÊý¾ÝµÄÿ¸ö×Ö¶Î×öУÑ飬±ÈÈçÊý¾ÝÊÇ·ñΪÕûÊý£¬ÕûÊýµÄ×î´óλÊý£¬¼°µ¼ÈëµÄÊý¾ÝÔÚÔÊý¾Ý¿âÖÐÊÇ·ñÒѾ´æÔڵȣ¬ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬¶ÔÒì³£µÄÊý¾Ý£¬½«×ֶΓis_checked”ÉèΪÒì³ ......
½¨Á¢±íÈçÏÂ:
ѧÉú»ù±¾ÐÅÏ¢±í
CREATE Student(
[Studentid][Int]IDENTITY(1,1)NOT NULL primary key,--Ö÷¼ü
[StudentName][char]NOT NULL
)
¿Î³ÌÐÅÏ¢±í
CREATE Subject(
[SubjectID][char]NOT NULL primary key, --Ö÷¼ü
[SubjectName][char]NOT NULL
)
³ ......
a)Êý¾Ý¿â±¾ÉíµÄÓÅ»¯
³õʼ»¯Îļþ init.ora
open_cursors = 150 ´ò¿ªµÄÓαêµÄ¸öÊý
ºÜ¶àµÄ´æ´¢¹ý³ÌµÄʱºò ¿ÉÒÔ°ÑËüµ÷´óЩ
......