Search This Blog

Friday, July 17, 2015

Scrpt to find products installed information in oracle applications 

select substr(FND_APPLICATION.APPLICATION_ID,1,10) Appl_id,
substr(FND_APPLICATION.APPLICATION_SHORT_NAME,1,10) Shortname,
substr(FND_APPLICATION_TL.APPLICATION_NAME,1,40) Longname,
substr(FND_APPLICATION_TL.LANGUAGE,1,4) Language,
substr(PATCH_LEVEL,1,15) Patchlevel,
substr(STATUS,1,5) Inst
from FND_APPLICATION,
FND_APPLICATION_TL,
FND_PRODUCT_INSTALLATIONS
WHERE FND_APPLICATION.APPLICATION_ID = FND_APPLICATION_TL.APPLICATION_ID
and FND_APPLICATION.APPLICATION_ID =
FND_PRODUCT_INSTALLATIONS.APPLICATION_ID(+)
and language = 'US'
order by FND_APPLICATION.APPLICATION_SHORT_NAME, FND_APPLICATION_TL.LANGUAGE;


Sample output (order by INST)



 
 
 
 
 
 
 


  APPL_ID
  SHORTNAME
  LONGNAME
  LANGUAGE
  PATCHLEVEL
  INST
 



  869
  ASP
  Oracle Sales for Handhelds
  US
  R12.ASP.B.3
  I
 



  178
  ICX
  Oracle iProcurement
  US
  R12.ICX.B.3
  I
 



  697
  ASO
  Order Capture
  US
  R12.ASO.B.3
  I
 



  660
  ONT
  Order Management
  US
  R12.ONT.B.3
  I
 



  200
  SQLAP
  Payables
  US
  R12.AP.B.3
  I
 



  673
  IBY
  Payments
  US
  R12.IBY.B.3
  I
 



  555
  GMF
  Process Manufacturing Financials
  US
  R12.GMF.B.3
  I
 



  558
  PMI
  Process Manufacturing Intelligence
  US
  R12.PMI.B.3
  I
 



  551
  GMI
  Process Manufacturing Inventory
  US
  R12.GMI.B.3
  I
 



  556
  GML
  Process Manufacturing Logistics
  US
  R12.GML.B.3
  I
 



  553
  GME
  Process Manufacturing Process Execution
  US
  R12.GME.B.3
  I
 



  554
  GMP
  Process Manufacturing Process Planning
  US
  R12.GMP.B.3
  I
 



  552
  GMD
  Process Manufacturing Product Developmen
  US
  R12.GMD.B.3
  I
 



  557
  GR
  Process Manufacturing Regulatory Managem
  US
  R12.GR.B.3
  I
 



  550
  GMA
  Process Manufacturing Systems
  US
  R12.GMA.B.3
  I
 



  455
  ENI
  Product Intelligence
  US
  R12.ENI.B.3
  I
 



  1292
  PJI
  Project Intelligence
  US
  R12.PJI.B.3
  I
 



  712
  PJM
  Project Manufacturing
  US
  R12.PJM.B.3
  I
 



  275
  PA
  Projects
  US
  R12.PA.B.3
  I
 



  240
  PN
  Property Manager
  US
  R12.PN.B.3
  I
 



  8401
  PSB
  Public Sector Budgeting
  US
  R12.PSB.B.3
  I
 



  8450
  PSA
  Public Sector Financials
  US
  R12.PSA.B.3
  I
 



  8400
  IGI
  Public Sector Financials International
  US
  R12.IGI.B.3
  I
 



  8302
  PQH
  Public Sector HR
  US
  R12.PQH.B.3
  I
 



  201
  PO
  Purchasing
  US
  R12.PO.B.3
  I
 



  452
  POA
  Purchasing Intelligence
  US
  R12.POA.B.3
  I
 



  250
  QA
  Quality
  US
  R12.QA.B.3
  I
 



  880
  QOT
  Quoting
  US
  R12.QOT.B.3
  I
 



  222
  AR
  Receivables
  US
  R12.AR.B.3
  I
 



  265
  FRM
  Report Manager
  US
  R12.FRM.B.3
  I
 



  804
  SSP
  SSP
  US
  R12.SSP.B.3
  I
 



  280
  ASN
  Sales
  US
  R12.ASN.B.3
  I
 



  279
  AS
  Sales Foundation
  US
  R12.AS.B.3
  I
 



  676
  BIL
  Sales Intelligence
  US
  R12.BIL.B.3
  I
 



  544
  ASL
  Sales Offline
  US
  R12.ASL.B.3
  I
 



  522
  ASF
  Sales Online
  US
  R12.ASF.B.3
  I
 



  519
  IES
  Scripting
  US
  R12.IES.B.3
  I
 



  661
  QP
  Advanced Pricing
  US
  R12.QP.B.3
  I
 



  724
  MSC
  Advanced Supply Chain Planning
  US
  R12.MSC.B.3
  I
 



  160
  ALR
  Alert
  US
  R12.ALR.B.3
  I
 



  190
  AZ
  Application Implementation
  US
  R12.AZ.B.3
  I
 



  0
  FND
  Application Object Library
  US
  R12.FND.B.3
  I
 



  168
  RG
  Application Report Generator
  US
  R12.RG.B.3
  I
 



  191
  BIS
  Applications BIS
  US
  R12.BIS.B.3
  I
 



  873
  CSE
  Asset Tracking
  US
  R12.CSE.B.3
  I
 



  140
  OFA
  Assets
  US
  R12.FA.B.3
  I
 



  702
  BOM
  Bills of Material
  US
  R12.BOM.C.3
  I
 



  690
  JTF
  CRM Foundation
  US
  R12.JTF.B.3
  I
 



  689
  ASG
  CRM Gateway for Mobile Devices
  US
  R12.ASG.B.3
  I
 



  705
  CRP
  Capacity
  US
  R12.CRP.B.3
  I
 



  260
  CE
  Cash Management
  US
  R12.CE.B.3
  I
 



  866
  CUG
  Citizen Interaction Center
  US
  R12.CUG.B.3
  I
 



  601
  AK
  Common Modules-AK
  US
  R12.AK.B.3
  I
 



  708
  CZ
  Configurator
  US
  R12.CZ.B.3
  I
 



  723
  MSO
  Constraint Based Optimization
  US
  R12.MSO.B.3
  I
 



  549
  IBC
  Content Manager
  US
  R12.IBC.B.3
  I
 



  510
  OKC
  Contracts Core
  US
  R12.OKC.B.3
  I
 



  524
  OKX
  Contracts Integration
  US
  R12.OKX.B.3
  I
 



  870
  OKI
  Contracts Intelligence
  US
  R12.OKI.B.3
  I
 



  511
  CSC
  Customer Care
  US
  R12.CSC.B.3
  I
 



  518
  BIC
  Customer Intelligence (obsolete)
  US
  R12.BIC.B.3
  I
 



  722
  MSD
  Demand Planning
  US
  R12.MSD.B.3
  I
 



  512
  CSD
  Depot Repair
  US
  R12.CSD.B.3
  I
 



  235
  ZX
  E-Business Tax
  US
  R12.ZX.B.3
  I
 



  709
  EDR
  E-Records
  US
  R12.EDR.B.3
  I
 



  703
  ENG
  Engineering
  US
  R12.ENG.C.3
  I
 



  8901
  FV
  Federal Financials
  US
  R12.FV.B.3
  I
 



  513
  CSF
  Field Service
  US
  R12.CSF.B.3
  I
 



  450
  FII
  Financial Intelligence
  US
  R12.FII.B.3
  I
 



  101
  SQLGL
  General Ledger
  US
  R12.GL.B.3
  I
 



  600
  AX
  Global Accounting Engine
  US
  11i.AX.J
  I
 



  283
  CN
  Incentive Compensation
  US
  R12.CN.B.3
  I
 



  542
  CSI
  Install Base
  US
  R12.CSI.B.3
  I
 



  539
  IEO
  Interaction Center Technology
  US
  R12.IEO.B.3
  I
 



  170
  CS
  Service
  US
  R12.CS.B.3
  I
 



  515
  OKS
  Service Contracts
  US
  R12.OKS.B.3
  I
 



  862
  BIV
  Service Intelligence
  US
  R12.BIV.B.3
  I
 



  665
  WSH
  Shipping Execution
  US
  R12.WSH.B.3
  I
 



  202
  CHV
  Supplier Scheduling
  US
  R12.CHV.B.3
  I
 



  454
  ISC
  Supply Chain Intelligence
  US
  R12.ISC.B.3
  I
 



  1
  SYSADMIN
  System Administration
  US
  
  I
 



  521
  AST
  TeleSales
  US
  R12.AST.B.3
  I
 



  8301
  GHR
  US Federal Human Resources
  US
  R12.GHR.B.3
  I
 



  696
  IEU
  Universal Work Queue
  US
  R12.IEU.B.3
  I
 



  385
  WMS
  Warehouse Management
  US
  R12.WMS.B.3
  I
 



  231
  BNE
  Web Applications Desktop Integrator
  US
  R12.BNE.B.4
  I
 



  706
  WIP
  Work in Process
  US
  R12.WIP.B.3
  I
 



  174
  ECX
  XML Gateway
  US
  R12.ECX.B.3
  I
 



  603
  XDO
  XML Publisher
  US
  R12.XDO.B.3
  I
 



  175
  EC
  e-Commerce Gateway
  US
  R12.EC.B.3
  I
 



  205
  IA
  iAssets
  US
  R12.IA.B.3
  I
 



  177
  POS
  iSupplier Portal
  US
  R12.POS.B.3
  I
 



  401
  INV
  Inventory
  US
  R12.INV.B.3
  I
 



  530
  AMS
  Marketing
  US
  R12.AMS.B.3
  I
 



  517
  BIM
  Marketing Intelligence
  US
  R12.BIM.B.3
  I
 



  704
  MRP
  Master Scheduling/MRP
  US
  R12.MRP.B.3
  I
 



  874
  JTM
  Mobile Application Foundation
  US
  R12.JTM.B.3
  I
 



  405
  MWA
  Mobile Applications
  US
  R12.MWA.B.3
  I
 



  534
  XNP
  Number Portability
  US
  R12.XNP.B.3
  I
 



  451
  OPI
  Operations Intelligence
  US
  R12.OPI.B.3
  I
 



  278
  IZU
  Oracle E-Business Suite Diagnostics
  US
  R12.IZU.B.3
  I
 



  545
  IEC
  Advanced Outbound Telephony
  US
  R12.IEC.B.3
  N
 



  431
  EGO
  Advanced Product Catalog
  US
  R12.EGO.C.3
  N
 



  203
  AME
  Approvals Management
  US
  R12.AME.B.3
  N
 



  7000
  JA
  Asia/Pacific Localizations
  US
  R12.JA.B.3
  N
 



  663
  VEA
  Automotive
  US
  R12.VEA.B.3
  N
 



  271
  BSC
  Balanced Scorecard
  US
  R12.BSC.B.3
  N
 



  674
  IBP
  Bill Presentment & Payment
  US
  
  N
 



  430
  DDD
  CADView-3D
  US
  R12.DDD.C.3
  N
 



  875
  JTS
  CRM Self Service Administration
  US
  11i.JTS.B
  N
 



  8724
  CUF
  Capital Resource Logistics - Financials
  US
  
  N
 



  8721
  IPA
  Capital Resource Logistics - Projects
  US
  R12.IPA.B.3
  N
 



  695
  IEX
  Collections
  US
  R12.IEX.B.3
  N
 



  867
  AHL
  Complex Maintenance Repair and Overhaul
  US
  R12.AHL.B.3
  N
 



  8407
  IGC
  Contract Commitment
  US
  
  N
 



  879
  IMC
  Customers Online
  US
  R12.IMC.B.3
  N
 



  9003
  DDR
  Demand Signal Repository
  US
  R12.DDR.B.3
  N
 



  429
  DNA
  Development
  US
  R12.DNA.C.3
  N
 



  432
  DOM
  Document Managment and Collaboration
  US
  R12.DOM.B.3
  N
 



  426
  EAM
  Enterprise Asset Management
  US
  R12.EAM.B.3
  N
 



  274
  FEM
  Enterprise Performance Foundation
  US
  R12.FEM.B.3
  N
 



  210
  ZPB
  Enterprise Planning and Budgeting
  US
  R12.ZPB.B.3
  N
 



  7002
  JE
  European Localizations
  US
  R12.JE.B.3
  N
 



  298
  POM
  Exchange
  US
  R12.POM.B.3
  N
 



  868
  CSL
  Field Service/Laptop
  US
  R12.CSL.B.3
  N
 



  883
  CSM
  Field Service/Palm
  US
  R12.CSM.B.3
  N
 



  8406
  IGF
  Financial Aid
  US
  
  N
 



  505
  ZFA
  Financial Analyzer
  US
  
  N
 



  266
  GCS
  Financial Consolidation Hub
  US
  R12.GCS.B.3
  N
 



  435
  FUN
  Financials Common Modules
  US
  R12.FUN.B.3
  N
 



  8402
  GMS
  Grants Accounting
  US
  R12.GMS.I
  N
 



  8404
  IGW
  Grants Proposal
  US
  R12.IGW.B.3
  N
 



  438
  ITA
  Information Technology Audit
  US
  R12.ITA.B.3
  N
 



  699
  IEB
  Interaction Blending
  US
  R12.IEB.B.3
  N
 



  242
  AMW
  Internal Controls Manager
  US
  R12.AMW.B.3
  N
 



  230
  ITG
  Internet Procurement Enterprise Connecto
  US
  R12.ITG.B.3
  N
 



  410
  WSM
  Shop Floor Management
  US
  R12.WSM.B.3
  N
 



  718
  RRS
  Site Management
  US
  R12.RRS.B.3
  N
 



  396
  PON
  Sourcing
  US
  R12.PON.B.3
  N
 



  8405
  IGS
  Student System
  US
  R12.IGS.A
  N
 



  778
  JMF
  Supply Chain Localizations
  US
  R12.JMF.B.3
  N
 



  701
  CLN
  Supply Chain Trading Connector for Roset
  US
  R12.CLN.C.3
  N
 



  808
  HXT
  Time and Labor
  US
  R12.HXT.B.3
  N
 



  809
  HXC
  Time and Labor Engine
  US
  11i.HXC.C
  N
 



  682
  OZF
  Trade Management
  US
  R12.OZF.B.3
  N
 



  508
  FTP
  Transfer Pricing
  US
  R12.FTP.B.3
  N
 



  716
  FTE
  Transportation Execution
  US
  R12.FTE.B
  N
 



  390
  MST
  Transportation Planning
  US
  R12.MST.B
  N
 



  185
  XTR
  Treasury
  US
  R12.XTR.B.3
  N
 



  821
  IRC
  iRecruitment
  US
  R12.IRC.B.3
  N
 



  672
  IBU
  iSupport
  US
  R12.IBU.B.3
  N
 



  726
  MSR
  Inventory Optimization
  US
  R12.MSR.B.3
  N
 



  7004
  JL
  Latin America Localizations
  US
  R12.JL.B.3
  N
 



  810
  OTA
  Learning Management
  US
  R12.OTA.B.3
  N
 



  540
  OKL
  Lease and Finance Management
  US
  R12.OKL.B.3
  N
 



  204
  XLE
  Legal Entity Configurator
  US
  R12.XLE.B.3
  N
 



  206
  LNS
  Loans
  US
  R12.LNS.B.3
  N
 



  560
  GMO
  Manufacturing Execution System for Proce
  US
  R12.GMO.B.3
  N
 



  388
  WPS
  Manufacturing Scheduling
  US
  R12.WPS.B.3
  N
 



  8727
  CUS
  Network Logistics
  US
  
  N
 



  8722
  CUI
  Network Logistics - Inventory
  US
  
  N
 



  8723
  CUP
  Network Logistics - Purchasing
  US
  
  N
 



  667
  QPR
  Oracle Deal Management
  US
  R12.QPR.C.3
  N
 



  207
  IPM
  Oracle Imaging Process Management
  US
  
  N
 



  9004
  INL
  Oracle Landed Cost Management
  US
  R12.INL.B.3
  N
 



  9001
  MTH
  Oracle Manufacturing Operations Center
  US
  R12.MTH.B.3
  N
 



  9000
  DPP
  Oracle Price Protection
  US
  R12.DPP.B.3
  N
 



  507
  PFT
  Oracle Profitability Manager
  US
  R12.PFT.B.3
  N
 



  881
  XNB
  Oracle Telecommunications Billing Integr
  US
  R12.XNB.B.3
  N
 



  666
  IBW
  Oracle Web Analytics
  US
  R12.IBW.B.3
  N
 



  300
  OE
  Order Entry
  US
  R12.OE.B.3
  N
 



  691
  PV
  Partner Management
  US
  R12.PV.B.3
  N
 



  777
  OKE
  Project Contracts
  US
  R12.OKE.H
  N
 



  440
  FPA
  Project Portfolio Analysis
  US
  R12.FPA.B.3
  N
 



  694
  PRP
  Proposals
  US
  R12.PRP.B.3
  N
 



  8303
  PQP
  Public Sector Payroll
  US
  R12.PQP.B.3
  N
 



  7003
  JG
  Regional Localizations
  US
  R12.JG.B.3
  N
 



  662
  RLM
  Release Management
  US
  R12.RLM.B.3
  N
 



  186
  QRM
  Risk Management
  US
  R12.QRM.B.3
  N
 



  506
  ZSA
  Sales Analyzer
  US
  
  N
 



  698
  CSR
  Scheduler
  US
  R12.CSR.B.3
  N
 



  805
  BEN
  Advanced Benefits
  US
  R12.BEN.B.3
  S
 



  535
  XDP
  Provisioning
  US
  R12.XDP.B.3
  S
 



  50
  AD
  Applications DBA
  US
  R12.AD.B.3
  S
 



  60
  SHT
  Applications Shared Technology
  US
  R12.SHT.B.3
  S
 



  8731
  CUA
  Capital Resource Logistics - Assets
  US
  
  S
 



  803
  DT
  DateTrack
  US
  R12.DT.B.3
  S
 



  680
  IEM
  Email Center
  US
  R12.IEM.B.3
  S
 



  802
  FF
  FastFormula
  US
  R12.FF.B.3
  S
 



  714
  FLM
  Flow Manufacturing
  US
  R12.FLM.B.3
  S
 



  800
  PER
  Human Resources
  US
  R12.PER.B.3
  S
 



  453
  HRI
  Human Resources Intelligence
  US
  R12.HRI.B.3
  S
 



  677
  BIX
  Interaction Center Intelligence
  US
  R12.BIX.B.3
  S
 



  523
  CSP
  Spares Management
  US
  R12.CSP.B.3
  S
 



  602
  XLA
  Subledger Accounting
  US
  R12.XLA.B.3
  S
 



  172
  CCT
  Telephony Manager
  US
  R12.CCT.B.3
  S
 



  671
  IBE
  iStore
  US
  R12.IBE.B.3
  S
 



  8403
  PSP
  Labor Distribution
  US
  R12.PSP.B.3
  S
 



  700
  MFG
  Manufacturing
  US
  R12.MFG.B.3
  S
 



  520
  AMV
  Marketing Encyclopedia System
  US
  R12.AMV.B.3
  S
 



  801
  PAY
  Payroll
  US
  R12.PAY.B.3
  S
 



  3
  AU
  Application Utilities
  US
  
  S
 



  41
  PTX
  Patch Tracking System
  US
  
  
 



  20003
  XPIP
  Pip Application
  US
  
  
 



  20023
  XXPPS
  Custom Applications
  US
  
  
 



  548
  IEP
  Predictive
  US
  
  
 



  559
  GMW
  Process Manufacturing Portal
  US
  
  
 



  420
  IPD
  Product Development (obsolete)
  US
  
  
 



  20139
  PSR
  Public Sector Receivables
  US
  
  
 



  437
  RCM
  Regulatory Capital Manager (obsolete)
  US
  
  
 



  710
  RLA
  Release Management Integration Kit (Obso
  US
  
  
 



  719
  RRC
  Retail Core
  US
  
  
 



  8726
  CUC
  Revenue Accounting
  US
  
  
 



  509
  RMG
  Risk Manager
  US
  
  
 



  877
  OKT
  Royalty Management
  US
  
  
 



  270
  EAA
  SEM Exchange (obsolete)
  US
  
  
 



  501
  AN
  Sales Analysis
  US
  
  
 



  532
  XNC
  Sales for Communications (Obsolete)
  US
  
  
 



  13017
  CLA
  APAC Consulting Localizations
  US
  
  
 



  272
  ABM
  Activity Based Management (Obsolete)
  US
  
  
 



  725
  RHX
  Advanced Planning Foundation(obsolete)
  US
  
  
 



  20043
  BPA
  Automate
  US
  
  
 



  711
  VEH
  Automotive Integration Kit (Obsolete)
  US
  
  
 



  538
  FPT
  Banking Center (obsolete)
  US
  
  
 



  543
  CUE
  Billing Connect (obsolete)
  US
  
  
 



  502
  PBR
  Budgeting and Planning
  US
  
  
 



  20160
  OKC_REP_TX
  Build/syncronize Contracts Repository Te
  US
  
  
 



  20090
  CPGC
  CPG - CDOA
  US
  
  
 



  20180
  CSN
  Call Center
  US
  
  
 



  547
  IET
  Call Center Connectors
  US
  
  
 



  3002
  CTB
  Clinical Transaction Base
  US
  
  
 



  679
  BIN
  Communications Intelligence
  US
  
  
 



  876
  OKP
  Contracts for Procurement (Obsolete)
  US
  
  
 



  541
  OKR
  Contracts for Rights (Obsolete)
  US
  
  
 



  871
  OKO
  Contracts for Sales (Obsolete)
  US
  
  
 



  865
  OKB
  Contracts for Subscriptions (Obsolete)
  US
  
  
 



  516
  ME
  Controlled Availability Product(Obsolete
  US
  
  
 



  707
  CST
  Cost Management
  US
  
  
 



  525
  ODQ
  Data Query
  US
  
  
 



  878
  IAM
  Digital Asset Management
  US
  
  
 



  13014
  CLE
  EMEA Consulting Localizations
  US
  
  
 



  40
  EMS
  Environment Management System
  US
  
  
 



  882
  AMF
  Fulfillment Services (Obsolete)
  US
  
  
 



  747
  GNI
  Genealogy Intelligence
  US
  
  
 



  3004
  HCA
  Healthcare
  US
  
  
 



  3003
  HCP
  Healthcare Intelligence
  US
  
  
 



  3005
  HCT
  Healthcare Terminology Server
  US
  
  
 



  864
  AHM
  Hosting Manager(Obsolete)
  US
  
  
 



  546
  IEV
  IVR Integrator
  US
  
  
 



  872
  XNI
  Install Base Intelligence (Obsolete)
  US
  
  
 



  536
  XNA
  Service Assurance for Communications
  US
  
  
 



  533
  XNS
  Service for Communications (obsolete)
  US
  
  
 



  514
  CSS
  Support (obsolete)
  US
  
  
 



  863
  BIY
  Systems Intelligence
  US
  
  
 



  20200
  DEM01
  Team 01 Order Entry Demo
  US
  
  
 



  537
  XNT
  TeleBusiness for Telecom/Utilities
  US
  
  
 



  681
  OZP
  Trade Planning (Obsolete)
  US
  
  
 



  20114
  OUC
  University Curriculum
  US
  
  
 



  436
  BLC
  Utility Billing
  US
  
  
 



  273
  EVM
  Value Based Management
  US
  
  
 



  678
  BIE
  eCommerce Intelligence
  US
  
  
 



  675
  IBT
  iAuction
  US
  
  
 



  683
  OZS
  iClaims (Obsolete)
  US
  
  
 



  3000
  HCC
  iHCConnect
  US
  
  
 



  3001
  HCN
  iHCIntegrate
  US
  
  
 



  670
  IBA
  iMarketing (Obsolete)
  US
  
  
 



  861
  IMT
  iMeeting (obsolete)
  US
  
  
 



  415
  ISX
  iSettlement
  US
  
  
 



  20159
  TEST
  test
  US
  
  
 



  13016
  CLJ
  Japan Consulting Localizations
  US
  
  
 



  13015
  CLL
  LAD Consulting Localizations
  US
  
  
 



  407
  WMA
  Manufacturing Mobile Applications
  US
  
  
 



  531
  XNM
  Marketing for Communications (Obsolete)
  US
  
  
 



  8725
  CUR
  Mass Market Receivables for Comms
  US
  
  
 



  860
  MIV
  Media Interactive
  US
  
  
 



  403
  MIA
  Mobile Applications for Inventory Manage
  US
  
  
 



  425
  MQA
  Mobile Quality Applications
  US
  
  
 



  8729
  CUN
  Network Logistics - NATS (obsolete)
  US
  
  
 



  1776
  DUMMY_GMO
  Obsolete Process Operations
  US
  
  
 



  20161
  OKC_REP_TX
  Optimize Contracts Repository Text index
  US
  
  
 



  99
  OAM
  Oracle Applications Manager
  US
  
  
 



  3006
  CDR
  Oracle Clinical Data Repository
  US
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...