[Áú¹®]oracle¿¡¼­ insert°¡


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :ÇØ¿î 1999³â 11¿ù 29ÀÏ 18:00:36

JDBC¹®Á¦´Â ¾Æ´Ï±¸¿ä...
Table¿¡ insert°¡ ¾ÈµÇ¼­¿ä...


¾ËÂ¥ Linux 6.0 ¿¡ ¸®´ª½º¿ë ¿À¶óŬ8i¸¦ ¼³Ä¡Çߴµ¥¿ä...
DB¸¦ CreationÇÏ°í...
SQL*PLUS¿¡ sys °èÁ¤À¸·Î ·Î±×ÀÎÇؼ­


create user lee identified lee
default tablespace users
temporary tablespace temp;


Çؼ­ lee ¶ó´Â ¿À¶óŬ°èÁ¤À» ¸¸µé¾ú°Åµç¿ä...
±×·¡¼­ create table±îÁö Çߴµ¥...
insertÇϸéÀº
ORA-01552 cannot use system rollback segment for non-system tablespace users
¶ó°í ³ª¿À´Â±º¿ä.


¿¡·¯ ¸®½ºÆ®¿¡ ¼³¸íµÇ¾îÀÖ±â·Î´Â


Cause: An attempt was made to use the SYSTEM rollback segment for operations involving a non-system tablespace.


Action: Create one or more rollback segments and then use ALTER ROLLBACK SEGMENT 'name' online. It may be necessary to modify the initialization parameter ROLLBACK_SEGMENTS to acquire one of the new private rollback segments. Before creating a rollback segment outside the SYSTEM tablespace, it is necessary to first create and activate a non-system rollback segment in the SYSTEM tablespace.


¶ó°í Çϴµ¥...Àß ÀÌÇØ°¡ ¾ÈµÇ´Â±º¿ä...
Àß ¾Æ½Ã´Â ºÐ °è½Ã¸é ¾Ë·ÁÁÖ¼¼¿ä....ÈæÈæ...
°¨»çÇÕ´Ï´Ù..





´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
HTML ÅÂ±× Æ÷ÇÔ ¿©ºÎ: HTML ¹®¼­ÀÏ °æ¿ì üũ
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]