1ãç¨sqlæ¥è¡¨
æ¥è¡¨çæ¶åéè¦ç¨å°user_tablesãall_tablesï¼user_tablesæ¥åºæ¥çæ¯è¯¥ç¨æ·æ¥æç表ï¼all_tablesæ¥åºæ¥çæ¯ææç¨æ·ç表ã
2ãç¨sqlæ¥è¡¨çå段
æ¥è¡¨çå段éè¦ç¨å°user_tab_columnsãall_tab_columnsï¼ä¸æ ·çåè
åªè½æ¥å°è¯¥ç¨æ·æ¥æç表ï¼åè
å¯ä»¥æ¥è¯¢ææç¨æ·ç表ã
3ãå
¶ä»
ä¸ä¸é¢ç±»ä¼¼çè¿ææ¥è¯¢å¯¹è±¡ï¼user_objectsãall_objectsï¼ãç´¢å¼ï¼user_indexesãall_indexesï¼ã约æï¼user_constraintsãall_constraintsï¼çã
è³äºå°åºæä¹æ¥ï¼å
ç¨select * from XXXæ¥ç表çä¿¡æ¯ï¼ç¶åçä¸å°±ç¥éäºãæ¯å¦æ¥ä¸ä¸ªsystem表dba_data_filesçå段ï¼å¯ä»¥ç¨select * from all_tab_columns where table_name = 'DBA_DATA_FILES'ï¼æ³¨æ表å大åã
2014-11-04è¡¥å
ï¼
ä¸åååºä¸äºæ¯è¾éè¦çæ°æ®åå
¸ï¼
DBA_TABLESï¼æè¿°æ°æ®åºä¸ææç¸å
³ç表ã
DBA_ALL_TABLESï¼æè¿°æ°æ®åºä¸ææç对象以åç¸å
³ç表ã
USER_TABLESï¼æè¿°æ°æ®åºä¸å½åç¨æ·æ¥æçç¸å
³ç表ã
USER_ALL_TABLESï¼æè¿°æ°æ®åºä¸å½åç¨æ·æ¥æç对象以åç¸å
³ç表ã
ALL_TABLESï¼æè¿°æ°æ®åºä¸ææçç¨æ·å¯ä»¥è®¿é®çç¸å
³ç表ã
ALL_ALL_TABLESï¼æè¿°æ°æ®åºä¸ææçç¨æ·å¯ä»¥è®¿é®ç对象以åç¸å
³ç表ã
DBA_TAB_COLUMNSï¼æè¿°æ°æ®åºä¸ææ表çåå±æ§ã
USER_TAB_COLUMNSï¼æè¿°æ°æ®åºä¸å½åç¨æ·æ¥æç表çåå±æ§ã
ALL_TAB_COLUMNSï¼æè¿°æ°æ®åºä¸ææç¨æ·å¯ä»¥è®¿é®ç表çåå±æ§ã
DBA_CONSTRAINTSï¼æè¿°æ°æ®åºä¸ææ表ç约æåå±æ§ã
DBA_CONS_COLUMNSï¼å
å«å¨DBA_CONSTRAINTS约æå®ä¹ä¸çå¯è®¿é®çåçä¿¡æ¯ã
ALL_CONSTRAINTSï¼æè¿°æ°æ®åºä¸ææç¨æ·å¯ä»¥è®¿é®ç表ç约æåå±æ§ã
ALL_CONS_COLUMNSï¼å
å«å¨ALL_CONSTRAINTS约æå®ä¹çå¯è®¿é®çåçä¿¡æ¯ã
USER_CONSTRAINTSï¼æè¿°æ°æ®åºä¸ææå½åç¨æ·æ¥æç表ç约æçå±æ§ã
USER_CONS_COLUMNSï¼å
å«å¨USER_CONSTRAINTS约æå®ä¹çå¯è®¿é®çåçä¿¡æ¯ã
DBA_SEQUENCESï¼æ°æ®åºä¸ææåºåçæè¿°ã
ALL_SEQUENCESï¼æè¿°æ°æ®åºä¸ææç¨æ·å¯ä»¥è®¿é®çåºåçæè¿°ã
USER_SEQUENCESï¼æè¿°æ°æ®åºä¸ææå½åç¨æ·æ¥æçåºåçæè¿°ã
DBA_INDEXESï¼æè¿°æ°æ®åºä¸ææçç´¢å¼çå±æ§ã
ALL_INDEXESï¼æè¿°æ°æ®åºä¸ææç¨æ·å¯ä»¥è®¿é®çç´¢å¼çå±æ§ã
USER_INDEXESï¼æè¿°æ°æ®åºä¸ææå½åç¨æ·æ¥æçç´¢å¼çå±æ§ã
温馨提示:答案为网友推荐,仅供参考