Oracle 数据字典 - 共6页.pdf

《Oracle 数据字典 - 共6页.pdf》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle᭄᥂ᑧᄫ݌ҟ㒡Oracle᭄᥂ᄫ݌ᰃ᳝㸼੠㾚೒㒘៤ⱘˈᄬټ᭄᳝݇᥂ᑧ㒧ᵘᙃⱘϔѯ᭄᥂ᑧᇍ䈵DŽ᭄᥂ᑧᄫ݌ᦣ䗄њᅲ䰙᭄᥂ᰃབԩ㒘㒛ⱘDŽᇍᅗӀৃҹ䈵໘⧚݊Ҫ᭄᥂ᑧ㸼៪㾚೒ϔḋ䖯㸠ᶹ䆶ˈԚϡ㛑䖯㸠ӏԩᬍDŽOracle᭄᥂ᑧᄫ݌䗮ᐌᰃ೼߯ᓎ੠ᅝ㺙᭄᥂ᑧᯊ㹿߯ᓎⱘˈOracle᭄᥂ᄫ݌ᰃOracle᭄᥂ᑧ㋏㒳Ꮉ԰ⱘ෎⸔ˈ≵᭄᳝᥂ᄫ݌ⱘᬃᣕˈOracle᭄᥂ᑧ㋏㒳ህϡ㛑䖯㸠ӏԩᎹ԰DŽ೼Oracle᭄᥂ᑧᄫ݌Ёˈ䆌໮㾚೒䛑᳝ϝϾϡৠⱘᅲ՟ˈᅗӀⱘࠡ㓔ߚ߿Ў"USER_"ǃ"ALL_"ঞ"DBA_"DŽ"USER_"Ўࠡ㓔ⱘ᭄᥂ᑧᄫ݌㾚೒䗮ᐌ䆄ᔩᠻ㸠ᶹ䆶ⱘᏤ᠋᠔ᢹ᳝ⱘᇍ䈵ⱘᙃˈ"ALL_"Ўࠡ㓔ⱘ᭄᥂

2、ᑧᄫ݌㾚೒䗮ᐌ䆄ᔩࣙᣀᠻ㸠ᶹ䆶ⱘᏤ᠋᠔ᢹ᳝ⱘᇍ䈵ⱘᙃঞᥜᴗ㟇PUBLICⱘᏤ᠋⫼᠋᠔ᢹ᳝ⱘᇍ䈵ⱘᙃˈ"DBA_"Ўࠡ㓔ⱘ᭄᥂ᑧᄫ݌㾚೒߭ࣙ৿᠔᭄᳝᥂ᑧᇍ䈵ⱘᙃˈ㗠ϡㅵ݊᠔᳝㗙DŽ݊Ҫⱘᄫ݌㾚೒ЁЏ㽕ⱘᰃV$㾚೒ˈП᠔ҹ䖭ḋিᰃ಴ЎҪӀ䛑ᰃҹV$៪GV$ᓔ༈ⱘDŽV$㾚೒ᰃ෎ѢX$㰮ᢳ㾚೒ⱘDŽV$㾚೒ᰃSYS⫼᠋᠔ᢹ᳝ⱘˈ೼㔎ⳕ⢊މϟˈা᳝SYS⫼᠋੠ᢹ᳝DBA㋏㒳ᴗ䰤ⱘ⫼᠋ৃҹⳟࠄ᠔᳝ⱘ㾚೒ˈ≵᳝DBAᴗ䰤ⱘ⫼᠋ৃҹⳟࠄUSER_੠ALL_㾚೒ˈԚϡ㛑ⳟࠄDBA_㾚೒DŽϢDBA_,ALL,੠USER_㾚೒Ё䴶৥᭄᥂ᑧᙃⳌডˈ䖭ѯ㾚೒ৃ㾚ⱘ㒭ߎњ䴶৥ᅲ՟ⱘᙃDŽ೼Oracleⱘ㒱໻໮᭄᭄᥂ᄫ݌㾚೒Ё䛑

3、᳝䈵DBA_TABLES,ALL_TABLES੠USER_TABLES䖭ḋⱘ㾚೒ᆊᮣDŽOracleЁ᳝䍙䖛100Ͼ㾚೒ᆊᮣˈϟ㸼߫ߎњ᳔䞡㽕੠᳔ᐌ⫼ⱘ㾚೒ᆊᮣˈ䳔㽕⊼ᛣⱘᰃ↣Ͼ㾚೒ᆊᮣ䛑᳝ϔϾDBA_,ϔϾALL_ϔϾUSER_㾚೒DŽ㾚೒ᆊᮣᦣ䗄COL_PRIVSࣙ৿њ㸼ⱘ߫ᴗ䰤ˈࣙᣀᥜќ㗙ǃ㹿ᥜќ㗙੠ᴗ䰤EXTENTS᭄᥂㣗ೈᙃˈ↨བ᭄᥂᭛ӊˈ᭄᥂↉ৡ(segment_name)੠໻ᇣINDEXES㋶ᓩᙃˈ↨བ㉏ൟǃଃϔᗻ੠㹿⍝ঞⱘ㸼IND_COLUMNS㋶ᓩ߫ᙃˈ↨བ㋶ᓩϞⱘ߫ⱘᥦᑣᮍᓣOBJECTSᇍ䈵ᙃˈ↨བ⢊ᗕ੠DDLtimeROLE_PRIVS㾦㡆ᴗ䰤ˈ↨བGRANT੠ADMIN䗝

4、乍SEGMENTS㸼੠㋶ᓩⱘ᭄᥂↉ᙃˈ↨བtablespace੠storageSEQUECNCESᑣ߫ᙃˈ↨བᑣ߫ⱘcacheǃcycle੠ast_numberSOURCE䰸㾺থ఼П໪ⱘ᠔᳝ݙ㕂䖛⿟ǃߑ᭄ǃࣙⱘ⑤ҷⷕSYNONYMS߿ৡᙃˈ↨བᓩ⫼ⱘᇍ䈵੠᭄᥂ᑧ䫒᥹db_linkSYS_PRIVS㋏㒳ᴗ䰤ˈ↨བgranteeǃprivilegeǃadmin䗝乍TAB_COLUMNS㸼੠㾚೒ⱘ߫ᙃˈࣙᣀ߫ⱘ᭄᥂㉏ൟTAB_PRIVS㸼ᴗ䰤ˈ↨བᥜќ㗙ǃ㹿ᥜќ㗙੠ᴗ䰤TABLES㸼ᙃˈ↨བ㸼ぎ䯈(tablespace),ᄬټখ᭄(storageparms)੠᭄᥂㸠ⱘ᭄䞣TRIGGERS㾺থ఼ᙃˈ↨

5、བ㉏ൟǃџӊǃ㾺থԧ(triggerbody)USERS⫼᠋ᙃˈ↨བЈᯊⱘ੠㔎ⳕⱘ㸼ぎ䯈VIEWS㾚೒ᙃˈࣙᣀ㾚೒ᅮН೼OracleЁ䖬᳝ϔѯϡᐌ⫼ⱘ᭄᥂ᄫ݌㸼ˈԚ䖭ѯ㸼ϡᰃⳳℷⱘᄫ݌ᆊᮣˈҪӀ䛑ᰃϔѯ䞡㽕ⱘऩϔⱘ㾚೒DŽ䖭ѯ㾚೒㾕ϟ㸼:㾚೒ৡ⿄ᦣ䗄USER_COL_PRIVS_MADE⫼᠋ᥜќҪҎⱘ߫ᴗ䰤USER_COL_PRIVS_RECD⫼᠋㦋ᕫⱘ߫ᴗ䰤USER_TAB_PRIVS_MADE⫼᠋ᥜќҪҎⱘ㸼ᴗ䰤USER_TAB_PRIVS_RECD⫼᠋㦋ᕫⱘ㸼ᴗ䰤Oracle᭄᥂ᑧᄫ݌ⱘᑨ⫼׳ࡽOracle᭄᥂ᄫ݌ˈ߽⫼OracleⱘDDL䇁হˈ៥Ӏৃҹخᕜ໮џᚙˈ޴Т᠔᳝ⱘOracleᓔ

6、থ䕙ࡽᎹ݋䛑ᰃ߽⫼䖭ϔ⚍䖯㸠䆒䅵ⱘDŽ԰㗙ᇚ䗮䖛བԩপᕫ᭄᥂ᑧ㸼ᄫ↉ᙃᴹ䇈ᯢDŽ佪ܜ៥ӀᅮНϔϾ᭄᥂ᑧ㸼ˈ᭄᥂ᑧ㸼㒧ᵘབϟ˖᭄᥂ᑧ㸼ৡ[TABLE_TEST]ᄫ↉ৡ᭄᥂㉏ൟ䭓ᑺ㔎ⳕؐܕ䆌ぎЏ䬂⊼䞞NAMEVARCHAR240NYྦྷৡSEXVARCHAR21'Y'Nᗻ߿BIRTHDAYDATE0Y⫳᮹HEIGHTNUMBER3ˈ1Y䑿催WEIGHTNUMBER3ˈ1Yԧ䞡MEMOBLOB0Y໛⊼߯ᓎ㸼ⱘSQL䇁হབϟ--߯ᓎ᭄᥂㸼createtableTABLE_TEST(NAMEvarchar2(40)notnull,SEXvarchar2(1)default'Y'notnull,BIRTHDAY

7、datenotnull,HEIGHTnumber(3,2),WEIGHTnumber(3,2),MEMOblob);--㒭߫⏏ࡴ໛⊼commentoncolumnTABLE_TEST.NAMEis'ྦྷৡ';commentoncolumnTABLE_TEST.SEXis'ᗻ߿';commentoncolumnTABLE_TEST.BIRTHDAYis'⫳᮹';commentoncolumnTABLE