Technical Development - Tiveloper.

자,,, 앞서 오라클 11g R2를 윈도우에 설치하셨죠? 관련해서 아래 링크를 참고해주세요.. 2012/11/22 - [Study/Oracle] - 윈도우7 64bit 버전에 오라클 11g R2를 설치했습니다. 그런데, 사실 저도 궁금했던건데,오라클을 설치하면 총4개의 계정에 대한 비밀번호를 설정합니다. SYS, SYSTEM, SYSDBA, SYSOPER 바로 요 네개의 계정이죠..그런데, 요넘들을 생각해보면 참 비슷해보이고, 헥갈립니다.~~그쵸? 자 그럼 함 알아봅시다..저넘들이 뭔지를... 일단 위 4개의 계정은 실제적인 스키마인가 아니면 Privilege에 해당되는가로 구분됩니다. SYS와 SYSTEM은 실제적인 DB스키마에 해당되며, SYSDBA와 SYSOPER는 일종의 role/privilege..

이거 해결할려고 구글일 무지막지하게 했다. 기존에 프로시져에 스트림 방식으로 저장을 하게 되면 장문 입력이 안되는 문제가 있기 때문이다. private static CLOB getCLOB( String clobData, Connection conn ) throws Exception { CLOB tempClob = null; try { // create a new temporary CLOB System.out.println("Get Temporary LOB data1"); tempClob = CLOB.createTemporary( conn, true, CLOB.DURATION_SESSION ); System.out.println("Get Temporary LOB data2"); // Open the tem..

The Oracle server uses the index only when that particular function is used in a query. If the function is not used in a query and there is no specific index, the Oracle server will full scan. QUERY_REWRITE_ENABLE initialization parameter must be set to TRUE for a function-based index to be used. CREATE INDEX upper_dept_name_idx ON dept2(UPPER(department_name));

Guidelines : You can increase the width or precision of a numeric column. You can increase the width of numeric of character columns. You can decrease the width of a column if : - The column contains only null values - The table has no rows - The decrease in column width is not less than the existing values in that column You can change the data type if the column contains only null values. exce..

Guidelines : You can increase the width or precision of a numeric column. You can increase the width of numeric of character columns. You can decrease the width of a column if : - The column contains only null values - The table has no rows - The decrease in column width is not less than the existing values in that column You can change the data type if the column contains only null values. exce..

Data Dictionary View Description ROLE_SYS_PRIVS System privileges granted to roles ROLE_TAB_PRIVS Table privileges granted to roles USER_ROLE_PRIVS Roles accessible by the user USER_TAB_PRIVS_MADE Object privileges granted on the user's object USER_TAB_PRIVS_RECD Object privileges granted on the user's object USER_COL_PRIVS_MADE Object privileges granted to the user on specific columns USER_COL_..

Data Dictionary View Description ROLE_SYS_PRIVS System privileges granted to roles ROLE_TAB_PRIVS Table privileges granted to roles USER_ROLE_PRIVS Roles accessible by the user USER_TAB_PRIVS_MADE Object privileges granted on the user's object USER_TAB_PRIVS_RECD Object privileges granted on the user's object USER_COL_PRIVS_MADE Object privileges granted to the user on specific columns USER_COL_..

PRIVILEGE ALTER SYSTEM AUDIT SYSTEM CREATE SESSION ALTER SESSION RESTRICTED SESSION CREATE TABLESPACE ALTER TABLESPACE MANAGE TABLESPACE DROP TABLESPACE UNLIMITED TABLESPACE CREATE USER BECOME USER ALTER USER DROP USER CREATE ROLLBACK SEGMENT ALTER ROLLBACK SEGMENT DROP ROLLBACK SEGMENT CREATE TABLE CREATE ANY TABLE ALTER ANY TABLE BACKUP ANY TABLE DROP ANY TABLE LOCK ANY TABLE COMMENT ANY TABLE..

PRIVILEGE ALTER SYSTEM AUDIT SYSTEM CREATE SESSION ALTER SESSION RESTRICTED SESSION CREATE TABLESPACE ALTER TABLESPACE MANAGE TABLESPACE DROP TABLESPACE UNLIMITED TABLESPACE CREATE USER BECOME USER ALTER USER DROP USER CREATE ROLLBACK SEGMENT ALTER ROLLBACK SEGMENT DROP ROLLBACK SEGMENT CREATE TABLE CREATE ANY TABLE ALTER ANY TABLE BACKUP ANY TABLE DROP ANY TABLE LOCK ANY TABLE COMMENT ANY TABLE..

The SQL*Plus FLASHBACK DATABASE command performs the same function as the RMAN FLASHBACK DATABASE command: it returns the database to a prior state. Note that using Flashback Database requires that you create a flash recovery area for your database and enable the collection of flashback logs. See Oracle Database Backup and Recovery Basics for more details about how the Flashback Database feature..