ãã1ã åå¤æ°æ®åºå建èæ¬
create tablespace whc_tbs datafile 'E:\oracle\oradata\whcdb\whc.dbf' size 100M;
--DROP TABLESPACE whc_tbs INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
create user whc identified by whc default tablespace whc_tbs;
grant connect,resource to whc;
grant dba to whc;
--Revoke dba from whc;
ããå ¶ä¸--ç注éè¯å¥æ¯å é¤å½å空é´å移é¤DBAç¨æ·çæéçã
ãã以ä¸è¿äºèæ¬æ¯ä¸ºäºæ们å¨æ°å»ºä¸ä¸ªè¡¨ç©ºé´åOracleæ°æ®åºçæ¶å使ç¨çã
ããå ¶ä¸E:\oracle\oradata\whcdb\whc.dbfè·¯å¾æ¯æ们è¦åæ¾æ°æ®åºæ°æ®çä½ç½®ï¼å æ¤è¦ä¿è¯è¯¥è·¯å¾æ足å¤ç空é´å足å¤ç访é®æéï¼å¦åä¼å¤±è´¥çã
ãã2ã 导åºæ°æ®åºå¯¹è±¡
ããå¨PL/SQL DeveloperçèåTools=>Export User Objectsä¸åºæ¥ä¸ä¸ªå¯¹è¯æ¡çé¢ï¼ç¶åæ¡éè¦å°å¤çOracle æ°æ®åºå¯¹è±¡ï¼å æ¬è¡¨ï¼åºåï¼åå¨è¿ç¨ï¼è§å¾ï¼å½æ°ççï¼å¹¶æå®å¯¼åºçæ件å称ï¼å¦ä¸æä½ã
ãã3ï¼å¯¼åºè¡¨æ°æ®
ãã导åºè¡¨ç»æåå ¶ä»å¯¹è±¡åï¼æ们ä¸ä¸æ¥å°±æ¯ææ°æ®åºç表æ°æ®è¿è¡å¯¼åºï¼PL/SQL Developerå·¥å ·æ¯æ导åºæ°æ®å°PL/SQLæ°æ®åºèæ¬ä¸ï¼å¦ä¸æ示ãè¿æ ·å¯¼åºçèæ¬ï¼æ们å¯ä»¥å¨PL/SQL Developerå·¥å ·å¯¼å ¥æè èªå·±éè¿Sql plus å·¥å ·è¿è¡å¯¼å ¥ã
ããè³æ¤ï¼æ们就已ç»å®æäºä¸ç§èæ¬äºï¼å æ¬å建æ°æ®åºç©ºé´åæ°æ®åºèæ¬ãå建Oracleæ°æ®åºå¯¹è±¡ï¼è¡¨ãåå¨è¿ç¨ãè§å¾ãåºåçï¼ãåå»ºå¯¼å ¥æ°æ®çèæ¬ï¼è¿æ ·ä¸ç§åä¸ï¼å°±æ¯ä¸ä¸ªå®æ´çæ°æ®åºäºãæåä¸æ¥å°±æ¯æ们å¦ä½å¯¼å ¥æ°æ®åºå¯¹è±¡åæ°æ®çé®é¢äºã
ãã
ãã4ï¼å¯¼å ¥æ°æ®åºå¯¹è±¡åæ°æ®
ããå¯¼å ¥æ°æ®åºå¯¹è±¡åæ°æ®çæä½ä¸æ ·ï¼é½å¯ä»¥éè¿Import Tablesæä½å®ç°ï¼æ们æå®åæä¸é¢ä¸¤æ¥å建çæ°æ®åºèæ¬ï¼æ§è¡å³å¯åæ°çç¯å¢ä¸å建æ°æ®åºå¯¹è±¡åæ°æ®åºæ°æ®äºãå¦ä¸æ示ã
ããå®æä¸é¢å 个æ¥éª¤ï¼æ们å¨æ°çæ°æ®åºç¯å¢ä¸ï¼å°±å ·å¤äºææçä¸è¥¿äºï¼é¡ºå©å®ææ´ä¸ªOracleæ°æ®åºå¯¹è±¡åæ°æ®çè¿ç§»å·¥ä½ã
ãã以ä¸å¼å¾æ³¨æçæ¯ï¼æ们导åºOracle对象åæ°æ®çæ¶åï¼é»è®¤è¿æ¯åæ¥Oracleæ°æ®åºç表空é´åæ°æ®åºç¨æ·å称çï¼å¦ææ们æ³è¦å¨æ°çæ°æ®åºæå¡å¨ä¸æå®ä¸åç表空é´åæ°æ®åºç¨æ·å¯¹è±¡ï¼é£ä¹æ们就éè¦æ¿æ¢çæçsqlèæ¬ï¼å¹¶å¨ç¬¬ä¸æ¥æå®åçç表空é´åæ°æ®åºç¨æ·ã
ããå¦ææ¯Linuxå¹³å°ä¸çæ°æ®åºæå¡å¨ï¼ç¬¬ä¸æ¥æä½ä¹æ¯å·®ä¸å¤çï¼å°±æ¯æå®è¡¨ç©ºé´çè·¯å¾åç¨å¾®ä¸åï¼å ¶ä»æä½å¹¶æ å·®å¼ã