|
롤백 세그먼트가 오프라인 되어있더라구요,,,,
디폴트로 롤백 세그먼트 오프라인으로 되어있는건가여?
너무나 감사합니다,,,
>>소몰이 님께서 쓰시길<<
:: q가 아니라 g입니다.
:: dba_rollback_seqs -> dba_rollback_segs
:: >>javahead 님께서 쓰시길<<
::
:: :: sql> select segment_name, status from dba_rollback_seqs;
:: :: 실행시
:: ::
:: :: ERROR at line 1:
:: :: ORA-00942: table or view does not exist
:: ::
:: :: 가 나옵니다,,, ㅠㅠ
:: :: ----------------------------------------
:: :: 이를 어쩌죠? 다시 깔아야 하나여? ㅠㅠ
:: ::
:: ::
:: :: >>소몰이 님께서 쓰시길<<
:: ::
:: :: :: rollback segment가 없거나 offline된 것 같습니다.
:: :: :: sqlplus system/manager
:: :: :: SQL> select segment_name, status from dba_rollback_segs
:: :: ::
:: :: :: status column란에 offline되어 있다면
:: :: :: alter rollback segment r01 online;
:: :: :: alter rollback segment r02 online;
:: :: :: ...
:: :: :: 차례대로 online 시켜주면 됩니다.
:: :: :: 근데... rollback segment가 없다면 ...
:: :: :: --__________--
:: :: ::
:: :: :: 오라클 설치될때 rollback segment가 만들어 지거든요...
:: :: ::
:: :: :: >>javahead 님께서 쓰시길<<
:: :: ::
:: :: :: :: 또 질문을 올립니다,,, 오라클에 문외한입니다, 죄송합니다,,,
:: :: :: ::
:: :: :: :: OS : ALZZA REDHAT 6.1
:: :: :: :: DB : ORACLE8i
:: :: :: :: -------------------------
:: :: :: ::
:: :: :: :: 디비는 오라클을 쓰고 jsp로 게시판을 구현했습니다,,,
:: :: :: :: 그런데, 글쓰기를 하고 등록버튼을 누르면,,,
:: :: :: :: ------------------------------------------------------------------------------
:: :: :: :: java.sql.SQLException: ORA-01552: cannot use system rollback segment for non-system tab
:: les
:: :: pac
:: :: :: e '
:: :: :: :: hive_data'
:: :: :: :: 라는 에러 메시지가 납니다,,,,
:: :: :: :: -----------------------------------------
:: :: :: :: 제가 한 작업은
:: :: :: :: sql> create tablespace hive_data
:: :: :: :: datafile '/home/oracle/dbs/oradata/ORCL/hive_data.dbf'
:: :: :: :: size 100M;
:: :: :: ::
:: :: :: :: sql> create user scott identified by tiger
:: :: :: :: default tablespace hive_data
:: :: :: :: quota unlimited on hive_data;
:: :: :: ::
:: :: :: :: sql> grant connect to scott
:: :: :: :: sql> grant dba to scott
:: :: :: ::
:: :: :: :: 이게 전부입니다,,, jsp코딩에러가 아닌건 확실한데,,
:: :: :: :: 제가 어떤 부분에서 잘못한 건지여,,,
:: :: :: :: 알려주세요,, ㅠㅠ,, 다시한번 염치불구하고 여쭙니다,,,
:: :: :: ::
:: :: :: ::
:: :: :: ::
|
