question on fnd_lobs partition (in ebiz)

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 5 Jan 2010 23:58:30 -0800
Message-ID: <a2b1e7611001052358y439281cbl3262ae92be05acad_at_mail.gmail.com>

Hi
Has anyone tried to use program_name to partition the fnd_lobs table. I have seen people using upload_date and range partitioning but in my case the developer wants to load a bunch of data by specifying program_name in his program. The developer will use the program_name column in fnd_lobs table and load all his data where program_name would be 'po_queries' . Developer would want all his data to be loaded in to a partition called po_queries in that case.
I was thinking list partition may fit the requirement where I would create list partitions for export, fnd_help,Nulls, ; one partition for defaults . Has anyone list partioned the fnd_lobs tables. SQL> select count(*), program_name from fnd_lobs g 2 roup by program_name;
  COUNT(*) PROGRAM_NAME
---------- --------------------------------

    178825

     30203 export
         1 BIAF_FR_XML
         2 PER_WS5_gb_UK.pdf
         1 PAY_R55_ar_KW.pdf
         2 PER_WS3_gb_UK.pdf
         3 PAY_NL_ATS_TEMPL.pdf
         1 PAY_R167_ar_KW.rtf
         1 PER_ADDR_gb_UK.pdf
         2 PER_SUMM_gb_UK.pdf
         1 PAY_TWR_e_ES.pdf

  COUNT(*) PROGRAM_NAME
---------- --------------------------------

         1 PAY_NL_WTS_TEMPL.rtf
         1 PER_VIS_ar_AE.pdf
         1 PAY_PRG_ar_AE.pdf
         1 PAY_MCF_ar_AE.rtf
         1 PER_CTR_ar_AE.rtf
     62563 FND_HELP
         1 PAY_NL_IZA_TEMPL.rtf
         2 ghr_sf50_report.pdf
         2 PER_WS6_gb_UK.pdf
         2 PAY_G42003_ar_SA.pdf
         2 ES_company_cert.pdf

  COUNT(*) PROGRAM_NAME
---------- --------------------------------

         3 FOLDER_VERIFY
         1 PER_PASS_ar_AE.pdf
         1 PAY_R166_ar_KW.pdf
         1 PER_CTR_ar_KW.pdf
         2 PER_WS1_gb_UK.pdf
         2 PER_WS2_gb_UK.pdf
         2 PAY_G32003_ar_SA.pdf
         1 PAY_F2_ar_AE.pdf
         1 PAY_MCP_ar_AE.rtf
         1 PAY_PRG_ar_KW.pdf
     43262 FNDATTCH

  COUNT(*) PROGRAM_NAME
---------- --------------------------------

         1 PAY_G52003_ar_SA.pdf
         2 Oracle E Records
         1 PAY_F7_ar_AE.rtf
         1 PERDTUPR.rtf
         1 PAY_NL_ATS_NLTMP.pdf
         1 PAY_NL_WTS_NLTMP.rtf
         1 alert_export
         2 ghr_sf52_report.pdf
         1 PAY_F1_ar_AE.pdf
         1 PAY_F6_ar_AE.rtf
         1 PAY_R103_ar_KW.pdf

  COUNT(*) PROGRAM_NAME
---------- --------------------------------

         1 PAY_R168_ar_KW.pdf
         2 PER_P11D_gb_UK.pdf
         2 PER_WS4_gb_UK.pdf
         1 PAY_US_GTN_TEMPL.rtf
         1 PER_DIS_ar_KW.pdf
         1 PAY_R56_ar_KW.pdf
         1 PAY_NL_IZA_NLTMP.rtf

Thank you
Kumar

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 06 2010 - 01:58:30 CST