BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: °³¶óŬ [ÀÀ´ä]drop ÀÎ ¾ÈµÇ´Â ÀÌÀ¯°¡ ¹«¾ùÀΰ¡¿ä.. Á¶È¸¼ö: 9166


SQL> drop table test;
drop table test
*
ERROR at line 1:
ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed re-validation

SQL> quit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
(3)[darak]/home/oracle > svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> ALTER TRIGGER SYS.JIS$ROLE_TRIGGER$ COMPILE ;
Statement processed.
SVRMGR>
SVRMGR> quit
Server Manager complete.
(4)[darak]/home/oracle > sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Jun 7 23:15:14 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: scott
Enter password:
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> drop table test;

Table dropped.

SQL> quit


°¡Á¦Æ®´ÔÀÇ ±Û
------------------------------------
¿À¶óŬÀ» óÀ½ °øºÎÇÏ´Â »ç¶÷Àε¥..
TABLE »ý¼ºµµ Çغ¸°í ³ª¸£µ¥·Î ¿­½ÉÈ÷ ÇÑ´Ù°í Çϴµ¥..
DROP¿¡¼­ ¸·Çô¼­ ¸îÀÏ° ²þ²þ ¾Ë°í ÀÖ½À´Ï´Ù.
DROP TABLE emp;
ÀÌ·±½ÄÀ¸·Î »èÁ¦¸¦ ÇÒ·Á°í Çϴµ¥.
Âü°í·Î Á¦ °èÁ¤Àº SYS °èÁ¤ÀÌ ¾Æ´Ñ USER°èÁ¤ÀÔ´Ï´Ù.
±ÇÇѶ§¹®¿¡ ±×·±°ÇÁö..¾Æ´Ï¸é Á¦°¡ ¸ð¸£´Â ¹«¾ùÀΰ¡ ÀÖ´ÂÁö..
¿©·¯ °í¼ö´Ôµé¿¡°Ô Á¶¾ðÁ» ¹Þ°í ½Í¾î¼­¿ä.
Á¶¾ðÇØÁֽô ºÐµé ¾Æ¸¶µµ ºÎÀڵǽDz¨¿¡¿ä.
------------------------------------

°ü·Ã±Û : 1 °Ç ±Û¾´½Ã°£ : 2004/06/07 23:16 from 61.82.164.84

 

Á¦ ¸ñ

Á¶È¸

³¯Â¥

±Û¾´ÀÌ

[ÀÀ´ä]drop ÀÎ ¾ÈµÇ´Â ÀÌÀ¯°¡ ¹«¾ùÀΰ¡¿ä..

9166

2004.06.02

°³¶óŬ


  drop ÀÎ ¾ÈµÇ´Â ÀÌÀ¯°¡ ¹«¾ùÀΰ¡¿ä.. ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ óÀ½ Á¢¼ÓÇÒ¶§ ÀÌ·± ¸Þ¼¼Áö ¶ß´Âµ¥ ¿Ö ±×·¡¿ä...¾Ë·ÁÁÖ¼¼¿ä..  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡