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

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
   


Ïà¹ØÎĵµ£º

MySQLºÍOracleµÄһЩ²Ù×÷Çø±ð

 ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ ......

ÓÉdzÈëÉî½²½âOracleÊý¾Ý¿â½ø³ÌµÄÏà¹Ø¸ÅÄî

 
OracleÊý¾Ý¿â½ø³Ì¸ÅÊö£º
Database buffer cacheÖ÷ÒªÓÃÓÚ´æ´¢Êý¾ÝÎļþÖеÄÊý¾Ý¿é
Êý¾Ý¿â¸ßËÙ»º´æµÄÊý¾Ý¿éÊǸßËÙ»º´æÓëÊý¾ÝÎļþ½øÐÐÐÅÏ¢½»»»µÄ»ù±¾µ¥Î»¡£ÔÚOracleÊý¾Ý¿â8iÒÔǰ,Êý¾Ý¿é´óСֻÓÐÒ»ÖÖ,¶øOracleÊý¾Ý¿â9iÒÔºóÖ§³Ö2K,4K,8KB,16KB¼°32KBÎåÖÖ¡£
ÓÃÃüÁîSQL>SHOW PARAMETER DB¿ÉÒÔÏÔʾµ±Ç°Êý¾Ý¿âµÄBUFF ......

oracle ¹éµµÈÕÖ¾

 C:\Documents and Settings\Administrator>sqlplus/nolog
SQL> CONNECT/AS SYSDBA
SQL> SHUTDOWN NORMAL/IMMEDIATE
SQL> STARTUP MOUNT
SQL> ARCHIVE  LOG  LIST                    
SQL> ALTER DATA ......

Oracleѧϰ±Ê¼Çժ¼4

 ½¨Á¢±íÈçÏÂ:
ѧÉú»ù±¾ÐÅÏ¢±í
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
)
³ ......

Oracleѧϰ±Ê¼Çժ¼8

   <1> ORACLEµÄʹÓÃ
       Æô¶¯ºÍ¹Ø±Õ
       ¹¤¾ß²Ù×÷ORACLE -- sql*plus
                        plsql deve ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ