role error SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ONexecute DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true); 2024. 5. 30. tnsnames.ora 위치 \oracle\product\version\db_1\network\admin $ORACLE_HOME/network/admin 2024. 5. 30. SYS 계정 선별 sql select username, to_char(created , 'yyyy-mm-dd hh24:mi:ss') from dba_users order by 2; 날짜별로 확인해서 제일 먼저 만들어진 날짜가 SYS 계정일 확률이 높음. 2024. 5. 30. ORA-01652 temp tablespace alert ORA-01652: unable to extend temp segment by 128 in tablespace TEMP DetailThis error is fairly self explanatory - we cannot get enough space for a temporary segment. The size reported in the error message is the number of contiguous free Oracle blocks that cannot be found in the listed tablespace. NOTE:A "temp segment" is not necessarily a SORT segment in a temporary tablespace. It is also used.. 2024. 5. 30. 이전 1 2 3 4 ··· 19 다음