깨비네 마을 ~ 'ㅁ'/

D:\oracle\oradata\GLSDB\archive -> D:\arch' 로 변경하기 sqlplus "/as sysdba" create pfile from spfile; shutdown immeidate D:\oracle\ora92\database\INITglsdb.ORA #*.log_archive_dest_1='LOCATION=D:\oracle\oradata\GLSDB\archive' -> *.log_archive_dest_1='LOCATION=D:\arch' (10g: *.db_recovery_file_dest='D:\arch' 로 변경) D:\oracle\ora92\database\SPFILEGLSDB.ORA --> D:\oracle\ora92\database\SPFILEGLSDB.ORA_ol..

ORA-29250: Invalid index specifed in call to dbms_sql.bind_array Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value. Action: Correct the index value by modifying your PL/SQL program and try the bind_array call again. ORA-29251: Index1 is greater than Index2 in call to dbms_sql.bind_array Cause: The value of index1 was g..

[에러] ERROR at line 1: ORA-32313: REFRESH FAST of "SWSIS"."TA_E012_MV" unsupported after PMOPs ORA-06512: at "SYS.DBMS_SNAPSHOT", line 820 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858 ORA-06512: at "SWSIS.JU_TMP", line 851 ORA-06512: at line 1 ORA-32313: REFRESH FAST of "string"."string" unsupported after PMOPs Cause: A Partition Maintenance Operation (P..

1) create session 권한을 주지 않아서 에러날 경우 이거나 비밀번호, 유저명을 잘못 쓴 경우~ system/password 로 접속후 SQL> grant connect, resource to sw ; Grant succeeded. 2) 재접속 [웬만하면 이걸로 다 해결!!!]

select count(case when to_char(hiredate,'MM') ='01' then count(*) end) as jan, count(case when to_char(hiredate,'MM') ='02' then count(*) end) as feb from emp

[ORACLE VERSION 9i] SELECT A.TABLE_NAME, C.COMMENTS, A.COLUMN_NAME, B.DATA_TYPE, B.DATA_LENGTH, A.COMMENTS FROM USER_COL_COMMENTS A, USER_TAB_COLS B, USER_TAB_COMMENTS C WHERE A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND A.TABLE_NAME = C.TABLE_NAME AND A.TABLE_NAME LIKE 'T_%'; [ORACLE VERSION 8I] SELECT A.TABLE_NAME, C.COMMENTS, A.COLUMN_NAME, B.DATA_TYPE, B.DATA_LENGTH, A.C..

windows에서 oracle 삭제 방법입니다. NETCA를 돌려서 리스너 삭제DBCA로 실행 후 DATABASE 를 삭제후 regedit 수정남아있는 oracle폴더 삭제(서비스가 남아있는 경우 : oradim -DELETE -SID sid | -SRVC srvc ) > 1. Administrator 권한으로 NT를 log on 한다 . 2. 시작-> 실행-> regedit을 기동하여 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE 폴더 전체를 삭제한다. 3. HKEY_LOCAL_MACHINE\SOFTWARE\odbc 를 삭제한다. 4. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ 에서 oracle로 시작되는 폴더들을 삭제한다. 5. H..

SELECT CASE WHEN GROUPING(ProductUnit) = 1 THEN N'합계' ELSE ProductUnit END AS ProductUnit ,CASE WHEN GROUPING(ProductID) = 0 THEN CONVERT(VARCHAR(5),ProductID) ELSE '' END AS ProductID ,CASE WHEN GROUPING(ProductID) = 0 THEN MAX(Name) ELSE '' END AS Name ,CASE WHEN GROUPING(ProductID) = 0 THEN MAX(ProductNumber) ELSE '' END AS ProductNumber ,SUM(SafetyStockLevel) AS SafetyStockLevel ,SUM(Reorder..

SELECT CASE WHEN GROUPING(ProductUnit) = 1 THEN N'합계' WHEN GROUPING(ProductUnit)+GROUPING(ProductID) = 1 THEN N'소계' ELSE ProductUnit END AS ProductUnit ,CASE WHEN GROUPING(ProductID) = 0 THEN CONVERT(VARCHAR(5),ProductID) ELSE '' END AS ProductID ,CASE WHEN GROUPING(ProductID) = 0 THEN MAX(Name) ELSE '' END AS Name ,CASE WHEN GROUPING(ProductID) = 0 THEN MAX(ProductNumber) ELSE '' END AS Product..