¿À¶óŬ 8i ÀÌÇÏ ¹öÁ¯¿¡¼ Ä÷³¸í º¯°æÇÒ °æ¿ì
¡Ø ¿À¶óŬ¿¡¼ Table Column¸íÀ» º¯°æÇÏ´Â ¸í·É¾î´Â ¾øÀ½.
¹æ¹ýÀº ¨çÀÓ½ÃÅ×ÀÌºí »ý¼ºÈÄ ¨èµ¥ÀÌŸ ÀÌ°üÇÏ°í ¨éRenameÇÏ´Â ¹æ¹ýÀÌ ÀÖÀ½.
¡Ø Rename½Ã ÁÖÀÇ»çÇ×
(±âÁ¸TableÀÇ °ü°è »çÀü Á¶»çÇÏ¿© RenameÈÄ Àç»ý¼ºÇØÁà¾ß ÇÔ)
¨ç Synonymn -> Àç»ý¼º
CREATE PUBLIC SYNONYM ½Ã³ë´Ô¸í FOR ¼ÒÀ¯ÀÚ.Å×À̺í¸í;
¨è Grant -> Àç»ý¼º
GRANT SELECT[DELETE, UPDATE, ALL] ON Å×À̺í¸í TO »ç¿ëÀÚ;
¨é Object(ÇÔ¼ö,Procedure...µîµî) -> ÀçÄÄÆÄÀÏ
¨ê Index hint»ç¿ëºÎºÐ -> Index¸í º¯°æ½Ã ¼öÁ¤ÇØÁà¾ß ÇÔ
¨ë Analyze -> Table ¹× Index Analyze ½ÇÇàÇÏ¿© Åë°èÁ¤º¸ È®º¸ÇØ¾ß ÇÔ
-.ÀϹÝÀûÀÎ ¹æ¹ý
analyze table Å×À̺í¸í compute statistics;
analyze index À妽º¸í compute statistics;
-.´ë¿ë·® Å×À̺íÀÇ °æ¿ì
analyze table Å×À̺í¸í estimate statistics sample 30 percent;
analyze index À妽º¸í estimate statistics sample 30 percent;