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

OracleÓÃimpºÍexpʵÏÖÊý¾ÝµÄµ¼ÈëºÍµ¼³ö

 ImpºÍExp
ÃüÁîÏê½â:
Exp
µ¼³ö
ģʽ:
Fullģʽ---µ¼³ö
Õû¸öÊý¾Ý¿â
Userģʽ---µ¼³ö
Ö¸¶¨µÄÓû§
Tableģʽ—µ¼³ö
Ö¸¶¨µÄ±í
Tablespaceģʽ—µ¼³ö
±í
¿Õ¼ä
Exp
µ¼³ö
²ÎÊý:
OWNERÖ¸¶¨Òªµ¼³ö
µÄÓû§Áбí
FULL=y±íʾҪµ¼³ö
Õû¸öÊý¾Ý¿â
TablesÖ¸¶¨Òªµ¼³ö
µÄ±í
TablepacesÖ¸¶¨Òªµ¼³ö
µÄ±í
¿Õ¼ä
ROWS=y±íʾµ¼³ö
±í
Êý¾Ý
,·ñÔòÖ»µ¼³ö
±í
µÄ½á¹¹.
HELP=Y±íʾҪ»ñÈ¡°ïÖú
IndexsÖ¸¶¨ÊÇ·ñµ¼³ö
Ë÷Òý
Grants±íʾÊÇ·ñµ¼³ö
ÊÚȨ
QUERYÖ¸¶¨²éѯÌõ¼þ,ÔÊÐíÓû§µ¼³ö
±í
µÄÒ»²¿·ÖÊý¾Ý
TriggersÖ¸¶¨ÊÇ·ñµ¼³ö
´¥·¢Æ÷
1.Full
ģʽ:
°ÑÊý¾Ý¿âorclÍêÈ«µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
system/pafirc@orcl file=e:\ pafirc.dmp full=y
2.User
ģʽ:
°Ñsystem,pafircÓû§µÄ±í
µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp owner=(system, pafirc)
3.Table
ģʽ:
°Ñ±í
tab_projµ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp tables=(tab_proj)
4.
±¸·Ý±í
ÖеIJ¿·ÖÊý¾Ý
°Ñ±í
tab_projÖеÄ×Ö¶ÎbudgetСÓÚ500000Êý¾Ý
µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp tables=(tab_proj) query=\" where budget<500000\"
ÈçÏÂͼ:
clip_image014
Imp
ÃüÁîÊý¾Ý
µÄµ¼Èë
ÀàËÆexp
,Ö»Òª°Ñexp
»»³Éimp¾Í¿ÉÒÔ,Èç¹ûµ¼Èë³É¹¦,»áÓÐÏÂÃæµÄÌáʾ:
clip_image016
clip_image018
Èý.´´½¨Óû§¼°ÊÚȨ
1.´´½¨Óû§:
CREATE USER PAFIRC
IDENTIFIED BY PAFIRC
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
2.ÊÚÓèÓû§È¨ÏÞ
GRANT DBA TO PAFIRC WITH ADMIN OPTION;
GRANT CONNECT TO PAFIRC WITH ADMIN OPTION;
GRANT RESOURCE TO PAFIRC WITH ADMIN OPTION;
GRANT DBA TO PAFIRC WITH ADMIN OPTION;
ALTER USER PAFIRC DEFAULT ROLE DBA,CONNECT,RESOURCE;


Ïà¹ØÎĵµ£º

ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â

ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
   
  1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
    ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
   
  2¡¢ÔÚWIN2000»òÕßwin200 ......

OracleµÄ³õʼ»¯²ÎÊýÎļþ

     oracleʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£ 
     pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀ ......

Oracleϵͳ±í²éѯ

 Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£  
¡¡¡¡1¡¢Óû§£º  
¡¡¡¡¡¡select username from dba_users;  
¡¡¡¡¸Ä¿ÚÁî  
¡¡¡¡¡¡alter user spgroup identified by spgtest;   
¡¡¡¡2¡¢±í¿Õ¼ä£º  
¡¡¡¡¡¡select * from dba_data_files;&nbs ......

oracle £º´æ´¢¹ý³ÌºÍº¯ÊýµÄ¼¸ÖÖд·¨

¹ØÓÚ´æ´¢¹ý³ÌºÍº¯ÊýµÄ¶¨ÒåÍøÉÏÒ»ËÑÒ»´ó°Ñ£¬ÕâÀï¾Í²»ÌØÊâ½éÉÜÁË£¬ÕâÀï¾ÍÖ»¶ÔÎÒ×Ô¼ºÐ´µÄ¼¸ÖÖ¸ñʽµÄ´æ´¢¹ý³ÌºÍº¯Êý×öһЩ×ܽᣬϣÍû¶Ô´ó¼ÒÓеã°ïÖú¡£
 Ò»£º´æ´¢¹ý³Ì
  
1£º×îÆÕͨµÄÒ»ÖÖ¡££¨´«²Î£¬²éѯÓαִ꣬ÐУ¬Ñ­»·Óαê×ö²åÈ붯×÷£©¡£
create or replace procedure zy2040_sirole(rolekey in varchar2) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ