<?xml version="1.0" encoding="utf-8"?>
<feed xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xml:lang="en-us" xmlns="http://www.w3.org/2005/Atom">
  <title>Mennan On Writing...</title>
  <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/" />
  <link rel="self" href="http://mennan.kagitkalem.com/SyndicationService.asmx/GetAtom" />
  <icon>favicon.ico</icon>
  <updated>2008-09-22T23:30:06.831875+03:00</updated>
  <author>
    <name>admin</name>
  </author>
  <subtitle>Articles, Codes and Algorithms about Software</subtitle>
  <id>http://mennan.kagitkalem.com/</id>
  <generator uri="http://dasblog.info/" version="2.2.8279.16125">DasBlog</generator>
  <entry>
    <title>Isyerinde “oldukca nazik” olma tehlikesi</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/IsyerindeOldukcaNazikOlmaTehlikesi.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,bddffafc-754f-4f2e-bcef-9afa245bec8a.aspx</id>
    <published>2008-09-22T23:26:08.816+03:00</published>
    <updated>2008-09-22T23:30:06.831875+03:00</updated>
    <category term="Business Life" label="Business Life" scheme="http://mennan.kagitkalem.com/CategoryView,category,BusinessLife.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
          <font size="4">Bugün </font>
          <a href="http://www.cio.com/">
            <font size="4">cio.com</font>
          </a>
          <font size="4"> da
bir makale okudum. Makale "</font>
          <a href="http://cio.com/article/print/450066">
            <font size="4">The
Danger of Being Too Nice at Work</font>
          </a>
          <font size="4">" hakkındaydı. Toplum olarak
insanları kırmama ve nezaket konularında hassas olduğumuz için öncelikli olarak bizi
de ilgilendirdiğini düşündüm. CIO editörlerinden "Meridith Levinson", <em>Nice Guys
Can Get the Corner Office</em>(<span style="FONT-SIZE: 9pt"><em>Eight Strategies for
Winning in Business Without Being a Jerk</em></span>)(<span style="FONT-SIZE: 10pt"><em>Russ
C. Edelman, Timothy R. Hiltabiddle, Charles C. Manz</em></span>) adlı kitaptan alıntılar
yaparak makaleyi tamamlıyor. Makalenin tamamını aktarmayacağım. Sadece ilgimi çeken
bir noktayı aşağıya alıntılıyorum: </font>
        </p>
        <p style="MARGIN-LEFT: 36pt">
          <span style="FONT-SIZE: 10pt">
            <em>
              <font size="4">"The nice guy is forever putting
the oxygen mask on someone else before putting it on himself"(nazik insanlar, oksijen
maskesini kendilerinden önce başkalarına takar...) </font>
            </em>
          </span>
        </p>
        <p>
          <font size="4">Makaleyi okumanızı öneririm...</font>
        </p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=bddffafc-754f-4f2e-bcef-9afa245bec8a" />
      </div>
    </content>
  </entry>
  <entry>
    <title>Using Data Pump Export(expdp) Over Network</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/UsingDataPumpExportexpdpOverNetwork.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,6a6d093a-8d9d-4018-8561-ff2d2feab7b3.aspx</id>
    <published>2008-09-15T23:47:13.375+03:00</published>
    <updated>2008-09-15T23:47:13.375+03:00</updated>
    <category term="Oracle" label="Oracle" scheme="http://mennan.kagitkalem.com/CategoryView,category,Oracle.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
Data Pump Export can be used over Networks. Normally when data pump export utility(expdp)
executes, it creates a dump file to the server where the database is installed. You
can DIRECTORY parameters in order to specify operating system file path. 
</p>
        <p>
Suppose that you have 2 databases(srv1db and srv2db) in 2 different servers(srv1 and
srv2). If you run expdp on srv2db, dump file shall be created in srv2 server. You
can also run expdp on srv1db and dump file shall be created in srv2 server, with NETWORK_LINK
expdp parameter. See demostration below: 
</p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--srv1db </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; select DIRECTORY_PATH
from all_directories where directory_name = 'DATA_PUMP_DIR'; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">DIRECTORY_PATH </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-------------------------------------------------------------------------------- </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">/usr/users/oracle/DP </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--srv2db </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; select DIRECTORY_PATH
from all_directories where directory_name = 'DATA_PUMP_DIR'; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">DIRECTORY_PATH </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-------------------------------------------------------------------------------- </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">/home/oracle/DP </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">---srv1 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">uccs01 oracle@srv1:/usr/users/oracle/DP&gt;
ls -ltr </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--srv2 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$ ls -ltr /home/oracle/DP </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--expdp on srv2 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$ expdp mte/mte@srv1db
tables=t directory=DATA_PUMP_DIR dumpfile=mte_t.dmp logfile=mte_t.log </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Export: Release 10.2.0.2.0 -
64bit Production on Wednesday, 13 August, 2008 10:15:53 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Copyright (c) 2003, 2005, Oracle.
All rights reserved. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Connected to: Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 - Production </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">With the Partitioning, OLAP
and Data Mining options </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Starting "MTE"."SYS_EXPORT_TABLE_01":
mte/********@srv1db tables=t directory=DATA_PUMP_DIR dumpfile=mte_t.dmp logfile=mte_t.log </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Estimate in progress using BLOCKS
method... </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type TABLE_EXPORT/TABLE/TABLE_DATA </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Total estimation using BLOCKS
method: 64 KB </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type TABLE_EXPORT/TABLE/TABLE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">. . exported "MTE"."T" 5.125
KB 31 rows </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Master table "MTE"."SYS_EXPORT_TABLE_01"
successfully loaded/unloaded </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">****************************************************************************** </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Dump file set for MTE.SYS_EXPORT_TABLE_01
is: </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> /usr/users/oracle/DP/mte_t.dmp </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Job "MTE"."SYS_EXPORT_TABLE_01"
successfully completed at 10:12:11 </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">---srv1 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">uccs01 oracle@srv1:/usr/users/oracle/DP&gt;
ls -ltr </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">total 2455 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-rw-r----- 1 oracle dba 69632
Aug 13 10:12 mte_t.dmp </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-rw-r--r-- 1 oracle dba 981
Aug 13 10:12 mte_t.log </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">uccs01 oracle@srv1:/usr/users/oracle/DP&gt; </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--srv2 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$ ls -ltr /home/oracle/DP </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--srv2db, create a dblink for
srv1db </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt;create public database
link srv1db_LINK.ORC </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> connect to USER1 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> using 'srv1db.ORC'; </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--expdp on srv2 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$ expdp USER1/USER1@srv2db
tables=t directory=DATA_PUMP_DIR dumpfile=mte_t2.dmp logfile=mte_t2.log network_link=srv1db_link </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Export: Release 10.2.0.2.0 -
64bit Production on Wednesday, 13 August, 2008 10:22:09 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Copyright (c) 2003, 2005, Oracle.
All rights reserved. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Connected to: Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">With the Partitioning, OLAP
and Data Mining options </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Starting "USER1"."SYS_EXPORT_TABLE_01":
USER1/********@srv2db tables=t directory=DATA_PUMP_DIR dumpfile=mte_t2.dmp logfile=mte_t2.log
network_link=srv1db_link </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Estimate in progress using BLOCKS
method... </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type TABLE_EXPORT/TABLE/TABLE_DATA </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Total estimation using BLOCKS
method: 64 KB </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type TABLE_EXPORT/TABLE/TABLE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">. . exported "USER1"."T" 5.351
KB 16 rows </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Master table "USER1"."SYS_EXPORT_TABLE_01"
successfully loaded/unloaded </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">****************************************************************************** </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Dump file set for USER1.SYS_EXPORT_TABLE_01
is: </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> /home/oracle/DP/mte_t2.dmp </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Job "USER1"."SYS_EXPORT_TABLE_01"
successfully completed at 10:22:45 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$ </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">---srv1 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">uccs01 oracle@srv1:/usr/users/oracle/DP&gt;
ls -ltr </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">total 2455 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-rw-r----- 1 oracle dba 69632
Aug 13 10:12 mte_t.dmp </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-rw-r--r-- 1 oracle dba 981
Aug 13 10:12 mte_t.log </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">uccs01 oracle@srv1:/usr/users/oracle/DP&gt; </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">--srv2 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$ ls -ltr /home/oracle/DP </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-rw-r--r-- 1 oracle oinstall
0 Aug 13 10:22 mte_t2.log </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">-rw-r----- 1 oracle oinstall
4096 Aug 13 10:22 mte_t2.dmp </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$</span>
        </p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=6a6d093a-8d9d-4018-8561-ff2d2feab7b3" />
      </div>
    </content>
  </entry>
  <entry>
    <title>Workaround for ORA-39014, ORA-12801, ORA-29913</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/WorkaroundForORA39014ORA12801ORA29913.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,3ea9892e-7037-4f5c-bfbe-b30815450207.aspx</id>
    <published>2008-09-15T01:50:47.296875+03:00</published>
    <updated>2008-09-15T01:50:47.296875+03:00</updated>
    <category term="Oracle" label="Oracle" scheme="http://mennan.kagitkalem.com/CategoryView,category,Oracle.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
There in an Oracle Bug(5472417 , Note:438608.1) about parallelism mechanism of data
pump export. Workaround fort his may be removing parallelism parameter from export(running
as a single process) 
</p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">bash-3.00$ expdp MT/MT full=y
directory=DATA_PUMP_DIR dumpfile=orcl_full_imp_p%u.dmp logfile=orcl_full_imp.log parallel=4
network_link=orcl_link </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Export: Release 10.2.0.2.0 -
64bit Production on Wednesday, 13 August, 2008 10:49:49 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Copyright (c) 2003, 2005, Oracle.
All rights reserved. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Connected to: Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">With the Partitioning, OLAP
and Data Mining options </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Starting "MT"."SYS_EXPORT_FULL_01":
MT/******** full=y directory=DATA_PUMP_DIR dumpfile=orcl_full_imp_p%u.dmp logfile=orcl_full_imp.log
parallel=4 network_link=orcl_link </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Estimate in progress using BLOCKS
method... </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Total estimation using BLOCKS
method: 13.06 GB </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/TABLESPACE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/PROFILE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SYS_USER/USER </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/USER </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/ROLE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/RESOURCE_COST </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/CONTEXT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/JAVA_CLASS/JAVA_CLASS </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/JAVA_RESOURCE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-39014: One or more workers
have prematurely exited. </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-39029: worker 4 with process
name "DW04" prematurely terminated </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-31671: Worker process DW04
had an unhandled exception. </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-12801: error signaled in
parallel query server </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-29913: error in executing
ODCIEXTTABLEPOPULATE callout </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-29400: data cartridge error </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">KUP-04038: internal error: kupax-meta1 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-06512: at "SYS.ORACLE_DATAPUMP",
line 78 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-06512: at "SYS.KUPW$WORKER",
line 1345 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-06512: at line 2 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Job "MT"."SYS_EXPORT_FULL_01"
stopped due to fatal error at 11:13:47</span>
        </p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=3ea9892e-7037-4f5c-bfbe-b30815450207" />
      </div>
    </content>
  </entry>
  <entry>
    <title>Solution of ORA-39002, ORA-39070, ORA-39087</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/SolutionOfORA39002ORA39070ORA39087.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,a760e630-ec30-443b-b66f-5682699898a9.aspx</id>
    <published>2008-09-15T01:40:38.078+03:00</published>
    <updated>2008-09-15T01:41:54.484375+03:00</updated>
    <category term="Oracle" label="Oracle" scheme="http://mennan.kagitkalem.com/CategoryView,category,Oracle.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
          <span style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana">The errors that i mentioned in
the subject, can be occured during data pump export/import(expdp/impdp executables).
If the directory object does not have necessary rigths, will fire an exception. Giving
rights(read - write) will be a solution. </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #548dd4; FONT-FAMILY: Courier New">bash-3.00$
expdp mte/mte@test02 tables=t directory=DATA_PUMP_DIR dumpfile=mte_t.dmp logfile=mte_t.log </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #548dd4; FONT-FAMILY: Courier New">Export: Release
10.2.0.2.0 - 64bit Production on Wednesday, 13 August, 2008 10:09:48 </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #548dd4; FONT-FAMILY: Courier New">Copyright
(c) 2003, 2005, Oracle. All rights reserved. </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #548dd4; FONT-FAMILY: Courier New">Connected
to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #548dd4; FONT-FAMILY: Courier New">With the Partitioning,
OLAP and Data Mining options </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier New">ORA-39002: invalid
operation </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier New">ORA-39070: Unable
to open the log file. </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier New">ORA-39087: directory
name DATA_PUMP_DIR is invalid </span>
        </p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">&gt;sqlplus </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected to Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected as HR </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; conn mte/mte@test02; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected to Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected as mte </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; select directory_name
from all_directories; </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">DIRECTORY_NAME </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">------------------------------ </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">HLR_DIR </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; conn HR/HR@test02; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected to Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected as HR </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; grant read, write
on directory DATA_PUMP_DIR to mte; </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Grant succeeded </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; conn mte/mte@test02; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected to Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Connected as mte </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; select directory_name
from all_directories; </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">DIRECTORY_NAME </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">------------------------------ </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">DATA_PUMP_DIR </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">HLR_DIR </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; </span>
        </p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">bash-3.00$
expdp mte/mte@test02 tables=t directory=DATA_PUMP_DIR dumpfile=mte_t.dmp logfile=mte_t.log </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Export: Release
10.2.0.2.0 - 64bit Production on Wednesday, 13 August, 2008 10:15:53 </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Copyright
(c) 2003, 2005, Oracle. All rights reserved. </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Connected
to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">With the Partitioning,
OLAP and Data Mining options </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Starting "MTE"."SYS_EXPORT_TABLE_01":
mte/********@test02 tables=t directory=DATA_PUMP_DIR dumpfile=mte_t.dmp logfile=mte_t.log </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Estimate in
progress using BLOCKS method... </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Processing
object type TABLE_EXPORT/TABLE/TABLE_DATA </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Total estimation
using BLOCKS method: 64 KB </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Processing
object type TABLE_EXPORT/TABLE/TABLE </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">. . exported
"MTE"."T" 5.125 KB 31 rows </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Master table
"MTE"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">****************************************************************************** </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Dump file
set for MTE.SYS_EXPORT_TABLE_01 is: </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">/usr/users/oracle/DP/mte_t.dmp </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: Courier New">Job "MTE"."SYS_EXPORT_TABLE_01"
successfully completed at 10:12:11 </span>
        </p>
        <p>
 
</p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=a760e630-ec30-443b-b66f-5682699898a9" />
      </div>
    </content>
  </entry>
  <entry>
    <title>An Interesting PL/SQL Bug about References</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/AnInterestingPLSQLBugAboutReferences.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,fdce2b4f-12cd-4f96-ba68-108970bdc37d.aspx</id>
    <published>2008-09-14T14:12:39.437+03:00</published>
    <updated>2008-09-14T14:15:31+03:00</updated>
    <category term="Oracle" label="Oracle" scheme="http://mennan.kagitkalem.com/CategoryView,category,Oracle.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
          <span style="FONT-FAMILY: Verdana">I have struggled a PL/SQL problem a few days ago.
The problem was, as Pl/SQL Compiler says, "PLS-00225: subprogram or cursor 'string'
reference is out of scope". It was not as easy as Compiler mentions. </span>
        </p>
        <p>
          <span style="FONT-FAMILY: Verdana">Let me show it by an example: </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-FAMILY: Verdana">Suppose that you have 2 packages, PACK1 and PACK2.
In PACK2, you have a procedure in PACK1 named PACK1 and another procedure that named
PACK1 in PACK2 package. When the namings are established like that you will get "PLS-00225:
subprogram or cursor 'string' reference is out of scope" error. </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-FAMILY: Verdana">Example below CMP.COMPARE and P_TEST.COMPARE exists.
In P_TEST, there is a reference for COMPARE package. It Works fine. </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE CMP IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 TYPE t_HashTable IS TABLE
OF VARCHAR2(512) INDEX BY VARCHAR2(32); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 TYPE t_SQL IS RECORD( </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 SQL_STATEMENT VARCHAR2(4000), </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 BIND_LIST t_HashTable </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 ); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 END CMP; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">10 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE BODY CMP IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 PROCEDURE Compare IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 BEGIN </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 NULL; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 END Compare; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 END CMP; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package body created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE p_test IS END p_test; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE BODY p_test IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 TYPE t_SQLList IS TABLE
OF CMP.t_SQL INDEX BY VARCHAR2(16); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 PROCEDURE Compare IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 BEGIN </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 NULL; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 END Compare; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">10 END p_test; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">11 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package body created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; </span>
        </p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
          <span style="FONT-FAMILY: Verdana">Example2 below COMPARE.COMPARE and P_TEST.COMPARE
exists. In P_TEST, there is a reference for COMPARE package. Altough there won't seem
any errors, PL/SQL Compiler is angry with code. </span>
        </p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE COMPARE IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 TYPE t_HashTable IS TABLE
OF VARCHAR2(512) INDEX BY VARCHAR2(32); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 TYPE t_SQL IS RECORD( </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 SQL_STATEMENT VARCHAR2(4000), </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 BIND_LIST t_HashTable </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 ); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 END COMPARE; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">10 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE BODY COMPARE IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 PROCEDURE Compare IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 BEGIN </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 NULL; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 END Compare; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 END COMPARE; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package body created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE p_test IS END p_test; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE BODY p_test IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 TYPE t_SQLList IS TABLE
OF COMPARE.t_SQL INDEX BY VARCHAR2(16); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 PROCEDURE Compare IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 BEGIN </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 NULL; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 END Compare; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">10 END p_test; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">11 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Warning: Package body created
with compilation errors </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; show errors; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Errors for PACKAGE BODY SYSADM.P_TEST: </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">
            <font color="#ff0000">LINE/COL
ERROR </font>
          </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">
            <font color="#ff0000">--------
------------------------------------------------------------------- </font>
          </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">
            <font color="#ff0000">3/30
PLS-00225: subprogram or cursor 'COMPARE' reference is out of scope </font>
          </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">
            <font color="#ff0000">3/3
PL/SQL: Item ignored </font>
          </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; </span>
        </p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
 
</p>
        <p>
          <span style="FONT-FAMILY: Verdana">Example3 below CMP.COMPARE and P_TEST.COMPARE2
exists.(i changed the name of COMPARE to COMPARE2 in P_TEST) In P_TEST, there is a
reference for COMPARE package. It Works fine. </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE COMPARE IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 TYPE t_HashTable IS TABLE
OF VARCHAR2(512) INDEX BY VARCHAR2(32); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 TYPE t_SQL IS RECORD( </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 SQL_STATEMENT VARCHAR2(4000), </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 BIND_LIST t_HashTable </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 ); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 END COMPARE; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">10 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE BODY COMPARE IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 PROCEDURE Compare IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 BEGIN </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 NULL; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 END Compare; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 END COMPARE; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package body created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE p_test IS END p_test; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQL&gt; CREATE OR REPLACE
PACKAGE BODY p_test IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">2 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">3 TYPE t_SQLList IS TABLE
OF COMPARE.t_SQL INDEX BY VARCHAR2(16); </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">4 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">5 PROCEDURE Compare2 IS </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">6 BEGIN </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">7 NULL; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">8 END Compare2; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">9 </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">10 END p_test; </span>
        </p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">11 / </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">Package body created </span>
        </p>
        <p>
 
</p>
        <p>
          <span style="FONT-SIZE: 10pt; FONT-FAMILY: Courier New">SQ </span>
        </p>
        <p>
 
</p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=fdce2b4f-12cd-4f96-ba68-108970bdc37d" />
      </div>
    </content>
  </entry>
  <entry>
    <title>Solution for ORA-01092, ORA-00704, ORA-39700 </title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/SolutionForORA01092ORA00704ORA39700.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,16b9325a-681e-4c7f-a29a-c0bca4491d8c.aspx</id>
    <published>2008-09-14T13:04:07.71875+03:00</published>
    <updated>2008-09-14T13:04:07.71875+03:00</updated>
    <category term="Oracle" label="Oracle" scheme="http://mennan.kagitkalem.com/CategoryView,category,Oracle.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
          <span style="font-family:Verdana">A few days ago i have created an Oracle database
manually(once i have crated an automated DB creation tamplate, it has a bug </span>
          <span style="font-family:Wingdings">L</span>
          <span style="font-family:Verdana">).
Somehow, some errors occured during creation. Then, when i started open the db, i
got some errors. I explained below what the work around is. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">orcl oracle@srv:/data06/app/oracle/admin/orcl/scripts&gt;
sqlplus / as sysdba </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL*Plus: Release 10.2.0.2.0
- Production on Tue Aug 5 23:50:26 2008 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Copyright (c) 1982, 2005, Oracle.
All Rights Reserved. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Connected to an idle instance. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; startup </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORACLE instance started. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Total System Global Area 104857600
bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Fixed Size 2046864 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Variable Size 75498608 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Database Buffers 20971520 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Redo Buffers 6340608 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Database mounted. </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-01092: ORACLE instance terminated.
Disconnection forced </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; quit </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Disconnected from Oracle Database
10g Enterprise Edition Release 10.2.0.2.0 - Production </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">With the Partitioning, OLAP
and Data Mining options </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Verdana">Check the alert log and trace </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">orcl oracle@srv:/data06/app/oracle/admin/orcl/bdump&gt;
more alert_orcl.log </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">...... </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">..... </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Errors in file /data06/app/oracle/admin/orcl/udump/orcl_ora_151225.trc: </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-00704: bootstrap process
failure </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-39700: database must be
opened with UPGRADE option </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Tue Aug 5 23:45:33 2008 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Error 704 happened during db
open, shutting down database </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">USER: terminating instance due
to error 704 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Instance terminated by USER,
pid = 151225 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORA-1092 signalled during: alter
database open... </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Verdana">Then solution </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">orcl oracle@srv:/data06/app/oracle/admin/orcl/scripts&gt;
sqlplus / as sysdba </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL*Plus: Release 10.2.0.2.0
- Production on Tue Aug 5 23:51:59 2008 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Copyright (c) 1982, 2005, Oracle.
All Rights Reserved. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Connected to an idle instance. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; startup upgrade </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">ORACLE instance started. </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Total System Global Area 104857600
bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Fixed Size 2046864 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Variable Size 75498608 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Database Buffers 20971520 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Redo Buffers 6340608 bytes </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Database mounted. </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Database opened. </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; @/data06/app/oracle/product/10.2/rdbms/admin/catalog.sql; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">..... </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">SQL&gt; @/data06/app/oracle/product/10.2/rdbms/admin/catproc.sql;</span>
        </p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=16b9325a-681e-4c7f-a29a-c0bca4491d8c" />
      </div>
    </content>
  </entry>
  <entry>
    <title>RGB to/from CMYK Color Conversion Resources</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/RGBTofromCMYKColorConversionResources.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,26e08b93-5173-4bd1-9649-4432b9c10d68.aspx</id>
    <published>2008-05-24T11:50:18.67375+03:00</published>
    <updated>2008-05-24T11:50:18.67375+03:00</updated>
    <category term="Image Processing" label="Image Processing" scheme="http://mennan.kagitkalem.com/CategoryView,category,ImageProcessing.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
          <span style="color:red">
            <strong>Online conversion </strong>
          </span>
        </p>
        <p>
          <a href="http://web.forret.com/tools/color.asp?R=100&amp;G=0&amp;B=255">http://web.forret.com/tools/color.asp?R=100&amp;G=0&amp;B=255</a>
        </p>
        <p>
        </p>
        <p>
          <span style="color:red">
            <strong>codeproject </strong>
          </span>
        </p>
        <p>
          <a href="http://www.codeproject.com/KB/applications/xcmyk.aspx">http://www.codeproject.com/KB/applications/xcmyk.aspx</a>
        </p>
        <p>
          <a href="http://www.codeproject.com/KB/GDI-plus/colorclass.aspx">http://www.codeproject.com/KB/GDI-plus/colorclass.aspx</a>
        </p>
        <p>
          <a href="http://www.codeproject.com/KB/cpp/adobe_cp_clone_part_1.aspx">http://www.codeproject.com/KB/cpp/adobe_cp_clone_part_1.aspx</a>
        </p>
        <p>
        </p>
        <p>
          <span style="color:red">
            <strong>tutorial </strong>
          </span>
        </p>
        <p>
          <a href="http://www.maxostudio.com/Tut_CS_CMYK.cfm">http://www.maxostudio.com/Tut_CS_CMYK.cfm</a>
        </p>
        <p>
        </p>
        <p>
          <span style="color:red">
            <strong>wikipedia </strong>
          </span>
        </p>
        <p>
          <a href="http://en.wikipedia.org/wiki/CMYK_color_model">http://en.wikipedia.org/wiki/CMYK_color_model</a>
        </p>
        <p>
        </p>
        <p>
          <span style="color:red">
            <strong>RGB-&gt;CMY-&gt;CMYK conversion </strong>
          </span>
        </p>
        <p>
          <a href="http://www.easyrgb.com/math.php?MATH=M13#text13">http://www.easyrgb.com/math.php?MATH=M13#text13</a>
        </p>
        <p>
        </p>
        <p>
          <span style="color:red">
            <strong>Sample source </strong>
          </span>
        </p>
        <p>
//RGB values = 0 ÷ 255 
</p>
        <p>
//CMY values = 0 ÷ 1 
</p>
        <p>
        </p>
        <p>
C = 1 - ( R / 255 ) 
</p>
        <p>
M = 1 - ( G / 255 ) 
</p>
        <p>
Y = 1 - ( B / 255 ) 
</p>
        <p>
        </p>
        <p>
//Where CMYK and CMY values = 0 ÷ 1 
</p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">var_K = 1 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">if ( C &lt; var_K ) var_K =
C </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">if ( M &lt; var_K ) var_K =
M </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">if ( Y &lt; var_K ) var_K =
Y </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">if ( var_K == 1 ) { //Black </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> C = 0 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> M = 0 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> Y = 0 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">} </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">else { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> C = ( C - var_K ) / ( 1 - var_K
) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> M = ( M - var_K ) / ( 1 - var_K
) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> Y = ( Y - var_K ) / ( 1 - var_K
) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">} </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">K = var_K</span>
        </p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=26e08b93-5173-4bd1-9649-4432b9c10d68" />
      </div>
    </content>
  </entry>
  <entry>
    <title>Noise Generation</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/NoiseGeneration.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,ead8acb9-e295-4e57-8e26-908bd43893cf.aspx</id>
    <published>2008-04-26T16:43:46.020625+03:00</published>
    <updated>2008-04-26T16:43:46.020625+03:00</updated>
    <category term="C#" label="C#" scheme="http://mennan.kagitkalem.com/CategoryView,category,C.aspx" />
    <category term="Computer Vision" label="Computer Vision" scheme="http://mennan.kagitkalem.com/CategoryView,category,ComputerVision.aspx" />
    <category term="Image Processing" label="Image Processing" scheme="http://mennan.kagitkalem.com/CategoryView,category,ImageProcessing.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <ol style="margin-left: 39pt">
          <li>
            <h2>Gürültü Oluşturma(Noise Generation) 
</h2>
          </li>
        </ol>
        <p>
Gerçek hayatta resimler tam istenildiği şekilde elde edilemezler. Resim bilgisi yanında
bir takım çevresel faktörlerden dolayı gürültü de içerirler. Bu gürültüler bazen modellenebilir
bazen de modellenemez. Resim üzerinde yapılacak işlemler için gerçek hayattaki resimlerin
modellenebilmesi, çalışmanın başarısını arttıracaktır. Bu nedenle var olan resim üzerinde
gürültü oluşturma, resim işlemede yerini almıştır. 
</p>
        <p style="text-align: center">
d(r,c)=I(r,c)+n(r,c) 
</p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Denklem 1 Gürültü Formülü </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
Gürültünün, resme etkisini bulabilmek için Sinyal Gürültü Oranı(Signal Noise Ratio,
SNR) hesaplanır. Bu değerin yüksek olması, gürültülü resmin orijinaline yakınlığını
belirtir. Bir diğer ifadeyle SNR değeri ne kadar yüksek ise resim, o kadar az bozulmuş
olarak algılanır. 
</p>
        <p style="text-align: center">
          <img src="http://mennan.kagitkalem.com/content/binary/042608_1342_NoiseGenera1.png" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Denklem 2 SNR Formülü </strong>
          </span>
        </p>
        <p>
. 
</p>
        <ol style="margin-left: 61pt">
          <li>
            <h2>Gauss Gürültüsü(Gauss Noise) 
</h2>
          </li>
        </ol>
        <p>
Bir Gauss dağılımı(normal dağılım, gauss distribution) yardımıyla gürültü oluşturulur.
Dağılımdaki her bir değer(olasılık) kadar rastgele pikseller değiştirilir. Örneğin
standart sapması 14 olan bir dağılımda g(5) = 0,027'dir. Resmin de 10.000 pikselden
oluştuğu varsayılırsa, 0,027* 10.000 = 270 piksel değerine +5'in eklenmesi gerekir.
Uç değerler için 0 ve 255'e göre yuvarlama yapılır. 
</p>
        <p>
Aşağıda farklı standart sapma değerlerine göre dağılımlar verilmiştir: 
</p>
        <p style="text-align: center">
          <img src="C:\mennan\edu\school\master\Semester IV\Computer Vision\Concepts\Noise Generation\gauss.xlsx" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Grafik 1 Gauss Dağılım(Standart
Sapma = 14) </strong>
          </span>
        </p>
        <p>
        </p>
        <p style="text-align: center">
          <img src="C:\mennan\edu\school\master\Semester IV\Computer Vision\Concepts\Noise Generation\gauss.xlsx" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Grafik 2 Gauss Dağılım(Standart
Sapma = 27) </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
Gauss gürültüsü bir resme uygulanırken, asıl görüntü bilgisi, gürültüden etkilenmemektedir.
Asıl görüntü üzerinden rastgele alınan her bir piksele gürültü uygulanıp, gürültülü
eklemiştir. Bu işlemler rastgele yapıldığı için asıl görüntü üzerindeki bir piksel
birçok defa gürültüden etkilenebilmektedir. Gürültülü resmin her bir piksel değeri,
o piksele uygulanan en son gürültülü ile oluşmaktadır. 
</p>
        <ol style="margin-left: 86pt">
          <li>
            <h2>Algoritma ve Kodlama 
</h2>
          </li>
        </ol>
        <p>
Kodlamanın göze çarpan kısımları aşağıda belirtilmiştir: 
</p>
        <p>
          <span style="font-family:Courier New; font-size:9pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> GrayLevel
= -255; GrayLevel &lt;= 255; GrayLevel++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt">{ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt"> Probability = GaussFunction.GetGaussValue(GrayLevel); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt"> EffectedPixelCount = (<span style="color:blue">int</span>)(Probability
* PixelCount); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; EffectedPixelCount; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt"> RandomIndex = Randomizer.Next(0,PixelCount-1); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt"> NoisyData[RandomIndex] = GetPixel(ImageData[RandomIndex]
+ GrayLevel); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:9pt">}</span>
        </p>
        <ol style="margin-left: 86pt">
          <li>
            <h2>Analiz ve Yorumlar 
</h2>
          </li>
        </ol>
        <p>
Peppersgary PGM formatlı resim üzerinde gürültü oluşturulmuştur. Çıkan sonuçlar aşağıda
belirtilmiştir: 
</p>
        <p style="text-align: center">
          <img src="http://mennan.kagitkalem.com/content/binary/042608_1342_NoiseGenera2.png" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Şekil 3 peppergray.pgm(noisy,gauss,σ
=14) </strong>
          </span>
        </p>
        <p>
        </p>
        <p style="text-align: center">
          <img src="http://mennan.kagitkalem.com/content/binary/042608_1342_NoiseGenera3.png" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Şekil 4 peppergray.pgm(noisy,gauss,σ
=27) </strong>
          </span>
        </p>
        <p>
          <table style="border-collapse:collapse" border="0">
            <colgroup>
              <col style="width:205px" />
              <col style="width:205px" />
              <col style="width:205px" />
            </colgroup>
            <tbody valign="top">
              <tr>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>σ =27</strong>
                    </span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>σ =14</strong>
                    </span>
                  </p>
                </td>
              </tr>
              <tr style="background: #d3dfee">
                <td style="padding-left: 7px; padding-right: 7px; border-left:  none; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>Piksel Sayısı</strong>
                    </span>
                  </p>
                </td>
                <td colspan="2" style="padding-left: 7px; padding-right: 7px; border-left:  none; border-right:  none">
                  <p style="text-align: center">
                    <span style="color:#365f91">263169</span>
                  </p>
                </td>
              </tr>
              <tr>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">
                      <strong>Signal Noise Ratio (SNR)</strong>
                    </span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">39.196</span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">136.058</span>
                  </p>
                </td>
              </tr>
            </tbody>
          </table>
        </p>
        <p>
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Tablo 1 Gauss Gürültü Analizi </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
Yukarıdaki tablo ışığında peppersgray resmi için yapılabilecek yorumlar aşağıda belirtilmiştir: 
</p>
        <ul>
          <li>
Standart sapma değerlerine göre oluşan SNR değerleri farklılık göstermektedir. 
</li>
        </ul>
        <ul>
          <li>
Düşük SNR değerleri için resim, daha fazla bozulmuş olarak algılanır. 
</li>
        </ul>
        <p>
        </p>
        <p>
        </p>
        <ol style="margin-left: 61pt">
          <li>
            <h2>Tekdüze Gürültü(Uniform Noise) 
</h2>
          </li>
        </ol>
        <p>
Bu gürültü şeklinde, gürültü sabit bir şekilde görüntü üzerinde dağılmıştır. -47 ile
+47 arasındaki bir sınır için 
</p>
        <p style="text-align: center">
1 / (47-(-47)) = 1/94 
</p>
        <p>
Olasılığında gürültü uygulanmıştır. Bir başka ifadeyle -47'den +47'e kadar her bir
değer 1/94 olasılığında gürültüye etkimiştir. 
</p>
        <p>
        </p>
        <p>
Aşağıda farklı sınır değerlerine ait tekdüze grafikler verilmiştir. 
</p>
        <p>
        </p>
        <p style="text-align: center">
          <img src="C:\mennan\edu\school\master\Semester IV\Computer Vision\HW\002\Odev2\docs\gauss-uniform.xlsx" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Grafik 3 Tekdüze Gürültü(-47,+47) </strong>
          </span>
        </p>
        <p>
        </p>
        <p style="text-align: center">
          <img src="C:\mennan\edu\school\master\Semester IV\Computer Vision\HW\002\Odev2\docs\gauss-uniform.xlsx" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Grafik 4 Tekdüze Gürültü(-7,+7) </strong>
          </span>
        </p>
        <ol style="margin-left: 86pt">
          <li>
            <h2>Algoritma ve Kodlama 
</h2>
          </li>
        </ol>
        <p>
Kodlamanın göze çarpan kısımları aşağıda belirtilmiştir: 
</p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Probability = 1.0 / (_end -
_start); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">EffectedPixelCount = (<span style="color:blue">int</span>)(Probability
* PixelCount); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> GrayLevel
= _start; GrayLevel &lt;= _end; GrayLevel++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">{ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; EffectedPixelCount; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> RandomIndex = Randomizer.Next(0,
PixelCount - 1); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> NoisyData[RandomIndex] = GetPixel(ImageData[RandomIndex]
+ GrayLevel); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">} </span>
        </p>
        <ol style="margin-left: 86pt">
          <li>
            <h2>Analiz ve Yorumlar 
</h2>
          </li>
        </ol>
        <p>
Peppersgary PGM formatlı resim üzerinde gürültü oluşturulmuştur. Çıkan sonuçlar aşağıda
belirtilmiştir: 
</p>
        <p style="text-align: center">
          <img src="http://mennan.kagitkalem.com/content/binary/042608_1342_NoiseGenera4.png" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Şekil 5 peppersgray.pgm(noisy,uniform,-47:47) </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p style="text-align: center">
          <img src="http://mennan.kagitkalem.com/content/binary/042608_1342_NoiseGenera5.png" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Şekil 6 peppersgray.pgm(noisy,uniform,-7:7) </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
          <table style="border-collapse:collapse" border="0">
            <colgroup>
              <col style="width:205px" />
              <col style="width:205px" />
              <col style="width:205px" />
            </colgroup>
            <tbody valign="top">
              <tr>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>[-7,7]</strong>
                    </span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>[-47,47]</strong>
                    </span>
                  </p>
                </td>
              </tr>
              <tr style="background: #d3dfee">
                <td style="padding-left: 7px; padding-right: 7px; border-left:  none; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>Piksel Sayısı</strong>
                    </span>
                  </p>
                </td>
                <td colspan="2" style="padding-left: 7px; padding-right: 7px; border-left:  none; border-right:  none">
                  <p style="text-align: center">
                    <span style="color:#365f91">263169</span>
                  </p>
                </td>
              </tr>
              <tr>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">
                      <strong>Signal Noise Ratio (SNR)</strong>
                    </span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">1335,138</span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">37,994</span>
                  </p>
                </td>
              </tr>
            </tbody>
          </table>
        </p>
        <p>
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Tablo 2 Uniform Gürültü Analizi </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
Yukarıdaki tablo ışığında peppersgray resmi için yapılabilecek yorumlar aşağıda belirtilmiştir: 
</p>
        <ul>
          <li>
Sınır değerlerine göre oluşan SNR değerleri farklılık göstermektedir. Birbirine yakın
değerler için resim daha az gürültülü olarak oluşmaktadır. 
</li>
        </ul>
        <ul>
          <li>
Düşük SNR değerleri için resim, daha fazla bozulmuş olarak algılanır. 
</li>
        </ul>
        <p>
        </p>
        <ol style="margin-left: 61pt">
          <li>
            <h2>Tuz-Biber Gürültüsü(Salt-Pepper Noise) 
</h2>
          </li>
        </ol>
        <p>
Bu gürültü şeklinde, gürültü tuz ve biber olacak şekilde uygulanmıştır. Tuz gürültüsü
pikseli beyaz, biber gürültüsü ise pikseli siyah yapmaktadır. 
</p>
        <p>
        </p>
        <ol style="margin-left: 86pt">
          <li>
            <h2>Algoritma ve Kodlama 
</h2>
          </li>
        </ol>
        <p>
Kodlamanın göze çarpan kısımları aşağıda belirtilmiştir: 
</p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">EffectedPixelCount = (<span style="color:blue">int</span>)(_saltRatio
* PixelCount); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; EffectedPixelCount; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">{ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> RandomIndex = Randomizer.Next(0,
PixelCount - 1); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> NoisyData[RandomIndex] = 255; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">} </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">EffectedPixelCount = (<span style="color:blue">int</span>)(_pepperRatio
* PixelCount); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; EffectedPixelCount; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">{ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> RandomIndex = Randomizer.Next(0,
PixelCount - 1); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> NoisyData[RandomIndex] = 0; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">} </span>
        </p>
        <ol style="margin-left: 86pt">
          <li>
            <h2>Analiz ve Yorumlar 
</h2>
          </li>
        </ol>
        <p>
Peppersgary PGM formatlı resim üzerinde gürültü oluşturulmuştur. Çıkan sonuçlar aşağıda
belirtilmiştir: 
</p>
        <p>
        </p>
        <p style="text-align: center">
          <img src="http://mennan.kagitkalem.com/content/binary/042608_1342_NoiseGenera6.png" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Şekil 7 peppersgray.pgm(noisy,salt:%5,pepper:%5) </strong>
          </span>
        </p>
        <p>
        </p>
        <p style="text-align: center">
          <img src="http://mennan.kagitkalem.com/content/binary/042608_1342_NoiseGenera7.png" alt="" />
        </p>
        <p style="text-align: center">
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Şekil 8 peppersgray.pgm(noisy,salt:%1,pepper:%1) </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
          <table style="border-collapse:collapse" border="0">
            <colgroup>
              <col style="width:205px" />
              <col style="width:205px" />
              <col style="width:205px" />
            </colgroup>
            <tbody valign="top">
              <tr>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>Salt:%5; Pepper:%5</strong>
                    </span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-top:  solid #4f81bd 1.0pt; border-left:  none; border-bottom:  solid #4f81bd 1.0pt; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>Salt:%1; Pepper:%1</strong>
                    </span>
                  </p>
                </td>
              </tr>
              <tr style="background: #d3dfee">
                <td style="padding-left: 7px; padding-right: 7px; border-left:  none; border-right:  none">
                  <p>
                    <span style="color:#365f91">
                      <strong>Piksel Sayısı</strong>
                    </span>
                  </p>
                </td>
                <td colspan="2" style="padding-left: 7px; padding-right: 7px; border-left:  none; border-right:  none">
                  <p style="text-align: center">
                    <span style="color:#365f91">263169</span>
                  </p>
                </td>
              </tr>
              <tr>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">
                      <strong>Signal Noise Ratio (SNR)</strong>
                    </span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">9,915</span>
                  </p>
                </td>
                <td style="padding-left: 7px; padding-right: 7px; border-bottom:  solid #4f81bd 1.0pt">
                  <p>
                    <span style="color:#365f91">43,707</span>
                  </p>
                </td>
              </tr>
            </tbody>
          </table>
        </p>
        <p>
          <span style="color:#4f81bd; font-size:9pt">
            <strong>Tablo 3 Salt-Pepper Gürültü Analizi </strong>
          </span>
        </p>
        <p>
        </p>
        <p>
Yukarıdaki tablo ışığında peppersgray resmi için yapılabilecek yorumlar aşağıda belirtilmiştir: 
</p>
        <ul>
          <li>
Salt ve Pepper oranlarına göre oluşan SNR değerleri farklılık göstermektedir. Düşük
oranlar için resim daha az gürültülü olarak oluşmaktadır. 
</li>
        </ul>
        <ul>
          <li>
Düşük SNR değerleri için resim, daha fazla bozulmuş olarak algılanır. 
</li>
        </ul>
        <p>
        </p>
        <p>
        </p>
        <ol style="margin-left: 39pt">
          <li>
            <h2>Sinyal Gürültü Oranı(Signal Noise Ratio, SNR) 
</h2>
          </li>
        </ol>
        <p>
Oluşturulan her bir gürültülü resim için SNR değeri de hesaplanmıştır. Analiz kısmındaki
tablodan bu değerler incelenebilir. 
</p>
        <p>
SNR değerinin hesaplanmasında kullnılan algoritma aşağıda belirtilmiştir: 
</p>
        <p>
          <span style="font-family:Courier New">
            <span style="color:blue">double</span> t1 =
0; </span>
        </p>
        <p>
          <span style="font-family:Courier New">
            <span style="color:blue">double</span> t2 =
0; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; OriginalImageData.Length; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New">{ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> t1 += NoisyImageData[i] * NoisyImageData[i]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> t2 +=(OriginalImageData[i]-NoisyImageData[i])*(OriginalImageData[i]-NoisyImageData[i]); </span>
        </p>
        <p>
          <span style="font-family:Courier New">} </span>
        </p>
        <p>
          <span style="font-family:Courier New">SNR = t1 / t2;</span>
          <span style="font-size:12pt">
          </span>
        </p>
        <ol>
          <li>
            <h1>Uygulama 
</h1>
          </li>
        </ol>
        <p>
        </p>
        <p>
Uygulama ComputerVision.exe adlı dosyadan oluşmaktadır. İşlenecek resimler, bu dosyanın
bulunduğu dizine bırakılmalıdır. İşlem sonucunda oluşan rapor dosyaları ve görüntüler,
bu dizin altında oluşacaktır. Aşağıda uygulamanın ne şekilde kullanılacağı belirtilmiştir: 
</p>
        <p>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">C:\ComputerVision\&gt;ComputerVision.exe </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">Computer Vision v1.0.0 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">Mennan Tekbir </span>
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">Usage: </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision &lt;operation&gt;
&lt;image&gt; [&lt;options&gt;*] </span>
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">Examples: </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 3 peppersgray.pgm </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 5 peppersgray.pgm
gauss 2 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 5 peppersgray.pgm
uniform -49 49 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 5 peppersgray.pgm
salt-pepper 0.05 0.05 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 6 peppersgray.pgm
median noisy_peppersgray.pgm 3 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 6 peppersgray.pgm
gauss noisy_peppersgray.pgm 1.4 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 7 peppersgray.pgm
2 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 8 peppersgray.pgm
1.6 1 7 </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> ComputerVision 9 peppersgray.pgm
0.67 25 100 </span>
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">Operations : </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 1 : Connected Components </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 2 : Erosion(Morphology) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 3 : Otsu Thresholding </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 4 : Region Properties </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 5 : Noise </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 6 : Filter </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 7 : LaplacianOfGaussian(LoG) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 8 : DifferenceOfGaussian(DoG) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> 9 : Canny Edge detector </span>
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">Options : </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;noise type&gt; = [gauss,
uniform, salt-pepper] </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;Standart Deviation&gt;
= (for gauss noise ) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;a&gt; = (for uniform noise
) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;b&gt; = (for uniform noise
) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;salt ration&gt; = (for
salt-pepper noise ) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;pepper ration&gt; = (for
salt-pepper noise ) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;filter type&gt; = [median,
gauss] </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;original file name&gt; </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;filter mask size&gt; =
(for filter operation) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt"> &lt;threshold&gt; = (for edge
operation) </span>
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">Please enter command(quit to
exit) </span>
        </p>
        <p style="margin-left: 35pt">
          <span style="font-family:Courier New; font-size:10pt">&gt; </span>
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p style="margin-left: 35pt">
        </p>
        <p>
          <span style="color:red; font-size:12pt">
            <strong>Uygulamayı indirmek için <a href="http://mennan.kagitkalem.com/content/binary/ComputerVision.zip">tıklayınız...</a></strong>
          </span>
        </p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=ead8acb9-e295-4e57-8e26-908bd43893cf" />
      </div>
    </content>
  </entry>
  <entry>
    <title>How to Sort ArrayList with ICompare Interface</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/HowToSortArrayListWithICompareInterface.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,8cf4f9ed-7e96-4adc-bb7c-8b7d9ce36beb.aspx</id>
    <published>2008-04-19T09:33:32.8475+03:00</published>
    <updated>2008-04-19T09:33:32.8475+03:00</updated>
    <category term="C#" label="C#" scheme="http://mennan.kagitkalem.com/CategoryView,category,C.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
A simple demostration shows how to sort an ArrayList in C#. 
</p>
        <p>
Output of the program will be: 
</p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Printing List before sorting: </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">1 = 2,5 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">2 = 1,9 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">3 = 4 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">4 = 10,5 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">5 = 1,1 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">6 = 3,5 </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">Printing List in ascending order </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">5 = 1,1 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">2 = 1,9 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">1 = 2,5 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">6 = 3,5 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">3 = 4 </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">4 = 10,5 </span>
        </p>
        <p>
        </p>
        <p>
C Sharp Code 
</p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">using</span> System; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">using</span> System.Collections.Generic; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">using</span> System.Collections; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">namespace</span> ArrayListSort </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">{ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">class</span>
            <span style="color:#2b91af">Program </span>
          </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">static</span>
            <span style="color:blue">void</span> Main(<span style="color:blue">string</span>[]
args) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">ArrayList</span> List
= <span style="color:blue">new</span><span style="color:#2b91af">ArrayList</span>(); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> List.Add( <span style="color:blue">new</span><span style="color:#2b91af">Item</span>(1,2.5)
); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> List.Add(<span style="color:blue">new</span><span style="color:#2b91af">Item</span>(2,
1.9)); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> List.Add(<span style="color:blue">new</span><span style="color:#2b91af">Item</span>(3,
4.0)); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> List.Add(<span style="color:blue">new</span><span style="color:#2b91af">Item</span>(4,
10.5)); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> List.Add(<span style="color:blue">new</span><span style="color:#2b91af">Item</span>(5,
1.1)); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> List.Add(<span style="color:blue">new</span><span style="color:#2b91af">Item</span>(6,
3.5)); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Console</span>.WriteLine(<span style="color:#a31515">"Printing
List before sorting:"</span>); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; List.Count; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Item</span> D
= (<span style="color:#2b91af">Item</span>)List[i]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Console</span>.WriteLine(D.Id
+ <span style="color:#a31515">" = "</span> + D.Difference); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> List.Sort(); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Console</span>.WriteLine(<span style="color:#a31515">"\nPrinting
List in ascending order"</span>); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; List.Count; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Item</span> D
= (<span style="color:#2b91af">Item</span>)List[i]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Console</span>.WriteLine(
D.Id + <span style="color:#a31515">" = "</span> + D.Difference ); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Console</span>.ReadLine(); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">class</span>
            <span style="color:#2b91af">Item</span> : <span style="color:#2b91af">IComparable </span></span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue"> #region</span> Members </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">private</span>
            <span style="color:blue">int</span> mId; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">public</span>
            <span style="color:blue">int</span> Id </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">get</span> { <span style="color:blue">return</span> mId;
} </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">set</span> {
mId = <span style="color:blue">value</span>; } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">private</span>
            <span style="color:blue">double</span> mDifference; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">public</span>
            <span style="color:blue">double</span> Difference </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">get</span> { <span style="color:blue">return</span> mDifference;
} </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">set</span> {
mDifference = <span style="color:blue">value</span>; } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue"> #endregion</span> Members </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue"> #region</span> Constructor </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">public</span> Item(<span style="color:blue">int</span> _id, <span style="color:blue">double</span> _diff) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">this</span>.mDifference
= _diff; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">this</span>.mId
= _id; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue"> #endregion</span> Constructor </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue"> #region</span> Compare
Interface </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">public</span>
            <span style="color:#2b91af">Int32</span> CompareTo(<span style="color:#2b91af">Object</span> _item) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:#2b91af">Item</span> ItemInstance
= (<span style="color:#2b91af">Item</span>)_item; </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">if</span> (<span style="color:blue">this</span>.Difference
&gt; ItemInstance.Difference) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">return</span> 1; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">else </span>
          </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue">return</span> -1; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">
            <span style="color:blue"> #endregion</span> Compare
Interface </span>
        </p>
        <p>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt"> } </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:10pt">} </span>
        </p>
        <img width="0" height="0" src="http://mennan.kagitkalem.com/aggbug.ashx?id=8cf4f9ed-7e96-4adc-bb7c-8b7d9ce36beb" />
      </div>
    </content>
  </entry>
  <entry>
    <title>Image Processing :: Region Properites</title>
    <link rel="alternate" type="text/html" href="http://mennan.kagitkalem.com/ImageProcessingRegionProperites.aspx" />
    <id>http://mennan.kagitkalem.com/PermaLink,guid,e513039b-00c5-49af-bbca-e5ade7dffbe7.aspx</id>
    <published>2008-03-25T23:36:03.609375+02:00</published>
    <updated>2008-03-25T23:36:03.609375+02:00</updated>
    <category term="Computer Vision" label="Computer Vision" scheme="http://mennan.kagitkalem.com/CategoryView,category,ComputerVision.aspx" />
    <category term="Image Processing" label="Image Processing" scheme="http://mennan.kagitkalem.com/CategoryView,category,ImageProcessing.aspx" />
    <content type="xhtml">
      <div xmlns="http://www.w3.org/1999/xhtml">
        <p>
Bir resim içindeki parçalar hakkında bilgi sahibi olabilmek, benzerlikler ve farklılıkları
bulabilmek amacıyla bu çalışma yapılacaktır. Genel olarak kullanılan özellikler aşağıda
belirtilmiştir: 
</p>
        <ul>
          <li>
Alan : Toplam piksel sayısıdır. 
</li>
          <li>
Merkez(Centroid) [r',c'] : Satır ve sütundaki toplamların, alana bölünmesidir. 
</li>
          <li>
Mean Radial Distance: Her bir piksel ile merkez nokta arasındaki farkın ortalamasıdır. 
</li>
          <li>
Variance Radial Distance : : Her bir piksel ile merkez nokta arasındaki farktan, Mean
Radial Distance değerinin farkının karelerinin ortalamalarının kareköküdür. 
</li>
          <li>
Second-Order Row Moment : Merkez noktasının apsisiyle her bir pikselin apsisinin farkları
toplamının, alana oranıdır. 
</li>
          <li>
Second-Order Column Moment: Merkez noktasının ordinatıyla her bir pikselin ordinatı
farkları toplamının, alana oranıdır. 
</li>
          <li>
Second-Order Mixed Moment: Merkez noktası ile her bir pikselin apsis ve ordinatları
farkları çarpımlarının toplamının, alana oranıdır. 
</li>
          <li>
Circularity2: Mean Radial Distance değerinin Variance Radial Distance değerine oranıdır. 
</li>
          <li>
Circularity1: Perimeter karesinin alana oranıdır. 
</li>
          <li>
            <div>Perimeter: Şeklin çevresidir. Bu değer, şekil sınırlarının toplamı olarak da
hesaplanabilir. 
</div>
            <p>
            </p>
            <p>
            </p>
            <h2>Algoritma ve Kodlama 
</h2>
          </li>
        </ul>
        <p>
        </p>
        <p>
Kodlamanın göze çarpan kısımları aşağıda belirtilmiştir: 
</p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">public</span>
            <span style="color:blue">static</span> RegionProperties[]
FindRegionsProperties(BinaryPGM _image, <span style="color:blue">int</span> _neighbour) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">{ </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ConnectedComponent CC = <span style="color:blue">new</span> ConnectedComponent(_image,
_neighbour); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> RegionProperties[] Props = <span style="color:blue">new</span> RegionProperties[CC.LabelCount+1]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">byte</span>[][]
ImageData = CC.LabeledImage.GetImageDataInMatrixForm(); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; Props.Length; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> Props[i] = <span style="color:blue">new</span> RegionProperties(); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> Props[i].RegionNumber = i; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> } </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:green">//Props.Length
+ 1 ::: 0 pixel for background.it will not used </span>
          </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">int</span>[]
Area = <span style="color:blue">new</span><span style="color:blue">int</span>[Props.Length
+ 1]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> Area,
0); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">double</span>[]
CentroidRow = <span style="color:blue">new</span><span style="color:blue">double</span>[Props.Length]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> CentroidRow,
0); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">double</span>[]
CentroidColumn = <span style="color:blue">new</span><span style="color:blue">double</span>[Props.Length]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> CentroidColumn,
0); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">double</span>[]
MRD = <span style="color:blue">new</span><span style="color:blue">double</span>[Props.Length]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> MRD,
0); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">double</span>[]
VRD = <span style="color:blue">new</span><span style="color:blue">double</span>[Props.Length]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> VRD,
0); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">double</span>[]
SORM = <span style="color:blue">new</span><span style="color:blue">double</span>[Props.Length]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> SORM,
0); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">double</span>[]
SOCM = <span style="color:blue">new</span><span style="color:blue">double</span>[Props.Length]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> SOCM,
0); </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">double</span>[]
SOMM = <span style="color:blue">new</span><span style="color:blue">double</span>[Props.Length]; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> ArrayOperations.InitializeArray(<span style="color:blue">ref</span> SOMM,
0); </span>
        </p>
        <p>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> i
= 0; i &lt; ImageData.Length; i++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt">
            <span style="color:blue">for</span> (<span style="color:blue">int</span> k
= 0; k &lt; ImageData[i].Length; k++) </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> { </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> Area[ImageData[i][k]]++; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> CentroidColumn[ImageData[i][k]]
+= k; </span>
        </p>
        <p>
          <span style="font-family:Courier New; font-size:8pt"> CentroidRow[ImageData[i][k]]
+= i; </span>
        </p>
        <p>
          <span style="font-family:Co