Aklımdan Kaçanlar...

DBMS_SCHEDULER job işlemlerinde alınan hata  Bu hata işlem yapılmak istenen job'ta herhangi bir özel karakter varsa oluşuyor. BEGIN DBMS_SCHEDULER.DROP_JOB( job_name => 'cyurter.borclari?guncelle' ); END ; ORA-20001: comma-separated list invalid near T ORA-06512: in "SYS.DBMS_UTILITY" , regel 236 ORA-06512: in "SYS.DBMS_UTILITY" , regel 272 ORA-06512: in "SYS.DBMS_SCHEDULER" , regel 623 ORA-06512: in line 2 "?" özel karakter olduğu için hata olşuyor. Çözüm için kodu aşağıdaki gibi " kullanarak düzenleyebilirsiniz. BEGIN DBMS_SCHEDULER.DROP_JOB( job_name => 'cyurter."borclari?guncelle"' ); END ;

Developerlar için 12C ile gelen özelliklerin anlatıldı güzel bir makale http://allthingsoracle.com/oracle-database-12c-new-features-part-4/ Diğer makalelere de göz atmak da fayda var, okumanızı tavsiye ederim.

Configuring WebUtil at OS: 1.Download WebUtil http://www.oracle.com/technology/software/products/forms/files/webutil/webutil_106.zip 2. Download Java Com Library  http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip 3. Extract both zips to some directory. 4. Copy   File  frmwebutil.jar   From folder: webutil_106\webutil_106\java  To: $ORACLE_HOME/forms/java   File:  jacob.jar    From folder: jacob_18  To: $ORACLE_HOME/forms/java   File:  d2kwut60.dll, JNIsharedstubs.dll   From folder: webutil_106\webutil_106\webutil To: $ORACLE_HOME/forms/webutil   File:  jacob.dll  From folder: jacob_18 To: $ORACLE_HOME/forms/webutil   File:  forms_base_ie.js, forms_ie.js - From folder: webutil_106\webutil_106\java To: $ORACLE_HOME/forms/java  File:  webutil.olb, webutil.pll and create_webutil_db.sql  From folder: webutil_106\webutil_106 To: $ORACLE_HOME/forms  ...

SQL Developer Dil Ayarları IncludeConfFile ../../ide/bin/ide.conf SetJavaHome ../../jdk AddVMOption  -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true AddVMOption -Dsun.java2d.ddoffscreen=false AddVMOption -Dwindows.shell.font.languages= AddVMOption  -XX:MaxPermSize=128M AddVMOption -Duser.language=en  AddVMOption -Duser.region=US AddVMOption -Doracle.jdbc.mapDateToTimestamp=false IncludeConfFile  sqldeveloper-nondebug.conf

DBMS_SQL paketinin kullanılması DECLARE Source_Cursor      INTEGER; Num_Rows_Processed Integer; BEGIN Source_Cursor := Dbms_Sql.Open_Cursor;      Dbms_Sql.Parse(Source_Cursor, 'select * from dba_source where object_name =  ', 1);      Num_Rows_Processed := Dbms_Sql.EXECUTE(Source_Cursor);      Dbms_Sql.Close_Cursor(Source_Cursor); end;

SELECT * FROM dba_scheduler_jobs where job_name=:job_name; SELECT * FROM dba_scheduler_job_log WHERE job_name=:job_name ; SELECT * FROM dba_scheduler_job_run_details where job_name=:job_name; SELECT 'SELECT * FROM '||object_name||';' FROM dba_objects where OBJECT_name like 'DBA_SCHEDULER%' and object_type='VIEW';

declare CURSOR c1 IS   SELECT p.index_owner,p.table_owner,p.table_name,p.index_name, wm_concat(p.column_name) kolonlar    FROM   DBA_IND_COLUMNS p    WHERE table_name =:TABLE_NAME    AND NOT EXISTS           (SELECT 1 FROM dba_ind_columns@diger_db r            WHERE p.index_name=r.index_name            AND p.index_owner=r.index_owner )    GROUP BY p.index_owner,p.table_owner,p.table_name,p.index_name; BEGIN FOR r1 IN c1 loop   dbms_output.put_line('CREATE INDEX '||r1.index_owner||'.'||r1.index_name||' ON '||r1.table_owner||'.'||r1.table_name||' ('||r1.kolonlar||');' ); end loop; end;