ä»æå¡å¨å°ORACLEæ°æ®åºå¯¼åºå导å
¥æ¬å°oracleæ°æ®åºä¸çæ¹æ³
ä¸ï¼å°æå¡å¨ä¸çORACLEæ°æ®åºå¯¼å
¥å°æ¬å°æºåä¸ï¼
å
·ä½æ¹æ³ï¼
å¨CMD模å¼ä¸æ§è¡ä»¥ä¸å½ä»¤
exp username/password@æå¡å¨ç«¯æ°æ®åºID file=c:/æ件å.dmp
ä¾å¦ä¸é¢:
exp djyy/djyy@zhwx file=c:/djyy20090921.dmp
exp wxzd/wxzd@zhwx file=c:/wxzd20090921.dmp
äºï¼å»ºç«æ¬å°oracleæ°æ®åº
å
·ä½æ¹æ³ï¼
ç¹å»å¼å§->ç¨åº->Oracle - OraDb10g_home1->é
ç½®å移æ¤å·¥å
·->Database Configuration Assistant.
è¿è¡åç¹å»ä¸ä¸æ¥ï¼éæ©å建æ°æ®åº->next->éæ©ä¸è¬ç¨é->å¡«åèªå·±çæ°æ®åºå->next-->å¡«åå£ä»¤ï¼éæ©åä¸å£ä»¤å§ï¼å½ç¶ä½ ä¹å¯ä»¥ä¸ºæ¯ä¸ªç¨æ·å¡«åä¸åçå£ä»¤ï¼ä»¥ååºæ¬ä¸é»è®¤å®è£
å§ãå®è£
å®æåéåºå³å¯ã
ä¸ï¼å»ºç«ç¨æ·ï¼å¹¶èµäºDBAæé
å
·ä½æ¹æ³ï¼
å¨å建ç«çæ¬å°æ°æ®åºä¸ï¼ç¨DBAçæéè´¦æ·è¿å
¥ï¼ç¶å建ç«èªå·±çç¨æ·ï¼å¹¶èµäºDBAçæéï¼
å
·ä½å®ä¾ä»£ç ï¼
1. SQL> conn sys/change_on_install as sysdba;
2. å·²è¿æ¥ã
3. SQL> create user username identified by password;
4. users;
5.
6. ç¨æ·å·²å建ã
7. SQL> grant create session,create table,create view to username
8. æææåã
9. SQL>grant DBA to uername;
10. æææåã
åï¼å¯¼å
¥oracleæ°æ®åº
å
·ä½æ¹æ³ï¼
å¨CMD模å¼ä¸æ§è¡ä»¥ä¸å½ä»¤
imp ç¨æ·/å¯ç file=*.dmp commit=y full=y
温馨提示:答案为网友推荐,仅供参考