question on fnd_lobs partition (in ebiz)

From: Kumar Madduri <ksmadduri@xxxxxxxxx>
To: oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
Date: Tue, 5 Jan 2010 23:58:30 -0800
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
question on fnd_lobs partition (in ebiz)

Other related posts:
