|
|
Ŭ¶ó¿ìµåű×
Javascript PHP ASP CSS HTML MYSQL jquery image Mobile API slide °Ô½ÃÆÇ ¸Þ´º
|
|
|
ÇöÀçÁ¢¼ÓÀÚ ¸í |
|
|
|
|
|
|
|
Dba Master/2000 V0.91 |
|
|
|
|
¼Ò½ººÐ·ù |
Oracle |
|
|
´Ù¿î·Îµå Ƚ¼ö |
1393 ȸ |
|
|
|
°£´Ü¼³¸í |
¿À¶óŬ¸¦ Ž»ö±âó·³ °ü¸®ÇÏ´Â °³¹ßÀÚ¿Í DBAÀÇ ÅøÀÔ´Ï´Ù. |
|
|
|
|
|
==»ç¿ëȯ°æ
¿î¿µÃ¼Á¦ : À©95, À©98, À©µµ¿ìÁî NT, ¿øµµ¿ì2000
RDBMS : ORACLE RDBMS Version 7.x, 8.X, 8i
¹Ìµé¿þ¾î : Oracle SQL*Net, BDE ¿£Áø 4.5ÀÌ»ó
====ÁÖ¿ä±â´É V0.91 <»ó¼¼ ±â´É ¼³¸í>
Table Manager
- µ¥ÀÌÅÍÁ¶È¸,¼öÁ¤,»èÁ¦,¿¢¼¿·ÎÀúÀå,¿¢¼¿ÈÀÏ Àбâ,Ãâ·Â
- Å×À̺í Çʵå¼Ó¼º Á¶È¸ -> Ä®·³¸í,ŸÀÔ,±æÀÌ,¼³¸íÀÔ·Â/Á¶È¸µî
- À妽ºÁ¤º¸, Á¦¾àÁ¶°Ç Á¤º¸, Æ®¸®°ÅÁ¤º¸, Å×ÀÌºí »ý¼ºÁ¤º¸
- Å×ÀÌºí »ý¼º ¹× Æ®¸®°Å ½ºÆ®¸³Æ® Á¶È¸
- Å×ÀÌºí ¼Ó¼ºÁ¤ÀǼ Ãâ·Â(°¡·Î/¼¼·Î)
- Å×ÀÌºí »èÁ¦, Å×ÀÌºí µ¥ÀÌÅÍ ÀÏ°ý »èÁ¦
SQL Script ÀÛ¼º±â
- Query¹®º° ½ÇÇà°á°ú º°µµ °ü¸®(Multi TabSheet °ü¸®)
- PLAN Table ÀÚµ¿»ý¼º ±â´É,PLAN °á°ú Ãâ·Â ±â´É
- Query¹® ¹®¹ý °Á¶(¿¹¾à¾î syntax highlighting) ±â´É
- ¸¶¿ì½º¸¸À¸·Î Query¹® ÀÚµ¿ »ý¼º ±â´É
- µ¥ÀÌÅÍ Query°á°ú¸¦ ¼öÁ¤,»èÁ¦,ÀúÀå,ÇÁ¸°Æ® Ãâ·Â,¿¢¼¿
Down, ¿¢¼¿ Upload ÀúÀå ±â´É
ALL Objects °ü¸® (¿À¶óŬ Àüü Object°ü¸®)
- Cluster, Function, Index, IndexObject, NextObject,
Package, PackageBody, Procedure, Sequence,
Synonym, Table, Trigger, ViewÁ¤º¸ Á¦°ø
- °¢ Objects»ý¼º ½ºÅ©¸³Æ® º¸±â, ÈÀÏÀúÀå, ÇÁ¸°Æ®Ãâ·Â
Oracle SQL*Plus ³»Àå
SQL Help (DB °ü¸® µµ¿ò¸»)
Session Manager
- ÇöÀçÀÇ Session »ç¿ëÀÚ Á¤º¸ º¸±â
- Lock ã±â ±â´É ¹× Transaction ã±â ±â´É
- ÇØ´ç Session KILL±â´É
Storage Manager (ÀúÀå¼Ò °ü¸®)
- Tablespace »ç¿ëÁ¤º¸(Total,Used,Free Size)
- DataFile Á¤º¸(Data File, Log File, Control File)
Sequrity Manager(DBA User¸¸ °¡´É)
Database Information (¿À¶óŬ µñ¼Å³Ê¸® Á¤º¸)
Æí¸®ÇÑ »ç¿ëÀÚ È¯°æ ¼³Á¤
- ȸéÆùÆ®,µ¥ÀÌÅͺ£À̽º ÀÚµ¿¿¬°á, Å×À̺íÁ¶È¸ ¿¬µ¿
- SQL¹® ÀÔ·Â⠿ɼÇ,¿¹¾à¾î Ãß°¡,Æ®·£Á§¼Ç ¸ð´ÏÅ͸µ ¿É¼Ç
Ư¼ö ¹®ÀÚ ÀÔ·Â ±â´É ³»Àå
===¼³Ä¡ ¹æ¹ý
ÇÁ·Î±×·¥ ¸ðµâÀº BDE 5.1°ú DBCLIENT, DbaMaster/2000À¸·Î ³ª´©¾î ÀÖ´Ù.
±âÁ¸ Delphi4.x»ç¿ëÀÚ´Â Custom¼³Ä¡·Î ÇÏ¿© DbaMaster/2000¸¸ ¼³Ä¡ ÇÑ´Ù. (½ÇÇà½Ã "µî·ÏµÇÁö ¾ÊÀº ¶óÀ̺귯¸® ÀÔ´Ï´Ù"¶ó´Â ¸Þ¼¼Áö³ª ³ª¿À¸é DBCLIENT¸¦ Ãß°¡·Î ¼³Ä¡ ÇÑ´Ù)
ÀÌ¿Ü »ç¿ëÀÚ´Â Typical(BDE 5.1°ú DBCLIENT, DbaMaster/2000)·Î ¼³Ä¡ ÇÑ´Ù.
====º» ÇÁ·Î±×·¥À» ¼³Ä¡ÈÄ ¼³Á¤ ¹æ¹ý
SQL*NET 7.xÀÌ»óÀÌ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÑ´Ù.
SQL*NET ¼³Ä¡µÈ µð·ºÅ丮 PATH°¡ ÀâÇô¾ß ÇÑ´Ù.
¿¹) DOSâ¿¡¼ "PATH=C:ORWIN98BIN"ÀÌ ÀÖ´ÂÁö È®ÀÎ ÇÑ´Ù.
ORACLEÀÇ SQL PlusâÀ» ¿¾î »ç¿ëÀÚ À̸§, ¾ÏÈ£,È£½ºÆ®½º¸µÀ» Á¤È®È÷ ÀÔ·ÂÇÏ°í ¿¬°á Å×½ºÆ®¸¦ ÇÑÈÄ ´ÙÀ½À» ¼³Á¤ ÇÑ´Ù.
BDE ¼³Á¤
DbaMaster200 > BDE Administrator ½ÇÇà
Configuration TabPage¿¡¼ Drivers -> Native -> ORACLE ÀÇ DefinitionâÀ» ¼öÁ¤ ÇÑ´Ù.
SQL*NET 7.x ÀÎ °æ¿ì
DLL32 -> SQLORA32.DLL
VENDOR INIT -> ORA73.DLL
SQL*NET 8.x ÀÎ °æ¿ì
DLL32 -> SQLORA8.DLL
VENDOR INIT -> OCI.DLL
¼öÁ¤ÀÌ µÇ¾úÀ¸¸é Object¸Þ´ºÀÇ Apply·Î ÀúÀå ÇÑ´Ù.
BDE¸¦ Á¾·á ÇÑ´Ù.
Connect ½Å±Ô Profile(User ID) µî·Ï
DbaMaster200 ½ÇÇàÇÏ°í Database Connect â¿¡¼
½Å±Ô ¹öÆ° ´©¸¥´Ù.
Oracle User¿¡ ´ëÇÑ Profile NameÀ» Á¤ÇÏ°í Server Name¿¡¼ Lookup DropDownÇϸé Oracle Easy Config¿¡¼ ¼³Á¤ÇÑ Alias¸íÀÌ º¸ÀÌ¸é ¼±ÅÃÇÑ´Ù.
. Alias¸íÀ» Ãß°¡,¼öÁ¤ÇÏ·Á¸é ¿À¸¥ÂÊ Oracle Easy Config¹öÆ°À» ´©¸¥´Ù.
. ¼±ÅÃµÈ Alias¸íÀÇ ¼³Á¤Á¤º¸´Â ¿À¸¥ÂÊ ? ¹öÆ°À» ´©¸¥´Ù.
Oracle user ID ÀÔ·ÂÇÏ°í Password ÀÔ·Â ÇÑ´Ù.
ÀúÀå ¹öÆ°À» ´©¸£°í Database¸¦ ¿¬°á ÇÑ´Ù.
¿¬°áÀ̵Ǹé ÃÖÈÄ¿¡ ¿¬°áÇÑ ProfileÀÌ ±â¾ïµÈ´Ù.
ÀúÀåµÈ Password´Â ´Ù¸¥ PC¿¡ º¹»çÇÏ¿© »ç¿ë ÇÒ ¼ö ¾ø´Ù.
±âŸ ȯ°æ¼³Á¤ ȸ鿡¼ »ç¿ëÀÚÀÇ ÃëÇâ¿¡ ¸Â°Ô »ç¿ëÀÚ È¯°æÀ» ¼³Á¤ ÇÒ ¼ö ÀÖ´Ù.
|
|
³×ƼÁð ÀÇ°ß ÀÌ¿ëÇϽŠÀÚ·áÀÇ Èı⸦ ÀÚÀ¯·Ó°Ô ÀÛ¼ºÇϼ¼¿ä. (»ó¾÷ÀûÀÎ ±¤°í ¹× µµ¹è¼º ±Û µîÀº »çÀüÅ뺸¾øÀÌ »èÁ¦µÉ ¼ö ÀÖ½À´Ï´Ù.) |
|