1ãæ¬æ以plsqlå¾å½¢å管çå·¥å ·ä¸ºä¾ï¼ä½¿ç¨å®è¿æ¥oracleæ°æ®åºãå½ç¹å¼plsqlçæ¶åï¼å°±éè¦è¾å ¥ç¨æ·åãå¯ç ãæ°æ®åºç¶åè¿æ¥ãå¦æè¿æ¥æåï¼å°±è½æ¥çéé¢ç表ççæä½ï¼å¦æè¿æ¥ä¸æåï¼å°±è¾å ¥æ£ç¡®çä¿¡æ¯å次å°è¯ã
2ãè¿æ¥ä¸æ°æ®åºä¹åï¼é»è®¤ä¼çå°è¿ä¸ªä¸»çé¢ã顶é¨æ¯åç§æä½èåï¼å·¦ä¾§ç¬¬ä¸ä¸ªæ¡æ¯æè¿æå¼çä¸äºä¿¡æ¯ï¼ç¬¬äºä¸ªæ¡éé¢çææ¯æ°æ®åºçææä¿¡æ¯ã
3ãå¦æä¸æ³çå°è¿ä¹å¤çæ¡ï¼åªæ³ä¸æ³¨äºæ°æ®åºçç¸å ³ä¿¡æ¯ï¼å°±å¯ä»¥å°å ¶ä»æ¡å ³éæè éèï¼è¿ä¸¤ç§æ¹å¼åªæ¯ç¹å»ä¸åçæé®èå·²ï¼å ·ä½åè§æªå¾ã
4ãå¨oracleæ°æ®åºä¸ï¼ç¨æ·æ¯å±äºè¡¨ç©ºé´çï¼å æ¤ï¼å½ä½¿ç¨æä¸ä¸ªç¨æ·ç»å½ä¹åï¼çå°çå ¶å®å°±æ¯è¿ä¸ªç¨æ·é»è®¤ç表空é´ä¸çä¿¡æ¯ãè¿ä¸ªæ¶åï¼å¯ä»¥å±å¼ãTablesãèåï¼å°±è½çå°å½å表空é´ä¸çææ表ï¼å¦æ表çæ°éä¸å¤ï¼å°±å¯ä»¥ç´æ¥ä¸ä¸ªä¸ä¸ªçæ°åºæ°éã
5ãå¦æå½åç¨æ·å ·æ管çåæéï¼è¿å¯ä»¥å¨ãTablespacesãèåä¸é¢ï¼æ¾å°ææç表空é´å称ï¼å¨æ¯ä¸ªè¡¨ç©ºé´å称ä¸é¢è¿æãTablesãèåï¼è¿éé¢ä¼æ¾ç¤ºè¿ä¸ªè¡¨ç©ºé´ä¸é¢çææç¨æ·å表ã
注æï¼å¯¹äºåä¸ä¸ªè¡¨ç©ºé´ä¸çç¸åæ°æ®åºï¼å¨è¿éä¼æ¾ç¤ºæ¯ä¸ªç¨æ·é½æ¥æä¸å¥è¡¨ç»æ
6ãå¦ææ³ç´æ¥è·å¾è¡¨ç©ºé´ä¸ç表æ°éï¼å¯ä»¥ç¹å»å·¦ä¸è§çæ°å»ºå¾æ ï¼éæ©ãSQLWindowãï¼å³ä¾§å°±ä¼åºç°ä¸ä¸ªç©ºç½çSQLè¯å¥ä¹¦åçªå£
7ãè·åæå®è¡¨ç©ºé´ä¸è¡¨æ°éï¼è¿æ¯å å«äºæ¤è¡¨ç©ºé´ä¸çææç¨æ·ç表ï¼
selectcount(1)fromall_tableswheretablespace_name='表空é´å称';è·åæå®è¡¨ç©ºé´ä¸ï¼æå®ç¨æ·ç表æ°éã
selectcount(1)fromall_tableswheretablespace_name='表空é´å称'andowner='ç¨æ·å称';å¦æå°count(1)æ¢ææå·ï¼å°±å¯ä»¥æ¥è¯¢è¡¨ç©ºé´ä¸çææ表åä¿¡æ¯çã