Jump to main content
Oracle Revenue Management and Billing
Oracle Revenue Management and Billing
  1. Home
  2. Oracle Revenue Management and Billing
  3. Business Processes
  4. Oracle Revenue Management and Billing Generic Business Processes
  5. Information Lifecycle Management (ILM)
  6. Additional Tasks After Dropping Table Partitions
  • Oracle Revenue Management and Billing
    • Business Processes
      • Oracle Utilities Application Framework Business Processes
      • Oracle Revenue Management and Billing Generic Business Processes
        • Person Information
        • Billing
        • Payments
        • Adjustments
        • Credit & Collections
        • Financial Transactions
        • Statements
        • Sales & Marketing
        • Rates
        • Quotes
        • Service Credits
        • Loans
        • Deposits
        • Case Management
        • Job Streams
        • Workflow and Notifications
        • Overdue Financial Obligations
        • Division
        • Approval Workflow
        • Rules Engine
        • Alternate Sequential Bill Numbers
        • Transaction Feed Management
        • Upload Validated Payment Data
        • Freeze Payments on Notification
        • Trial Billing
        • Bill Tolerance
        • GL Account Validation
        • Mass Adjustment Creation via CSV
        • Payment Request
        • Account Receivable Central
        • Offset Request
        • Funding Request
        • Hold Request
        • Delinquency Central
        • Upload Request
        • General Ledger (GL) Accounting Template
        • Payment Agreement Request
        • Deferred Revenue Recognition
        • File Upload Interface
        • Mass Pricing Update
        • Price Item, Parameter, and SQI Upload
        • Product and Product Version Upload
        • Price List and Price Item Pricing Upload
        • Refund/Write Off Request
        • Garbling Customer Information
        • Information Lifecycle Management (ILM)
          • ILM Process
          • ILM Implementation
          • Scope of ILM Implementation
          • ILM Specific Option Types in a Maintenance Object
          • ILM Implementation Process
          • ILM Batches
          • ILM Archival
          • Dropping the Eligible Table Partitions
          • Additional Tasks After Dropping Table Partitions
            • Rebuilding the Global Indexes
            • Generating the Database Statistics
        • Extract Template
        • Batch Scheduler
        • Data Extractor
        • Hold Request Creation, Modification, Release, and View Through Inbound Web Service
        • Hold Direct Debit Instruction
        • Deleting Inactive Customer or Closed Account Information
        • Generic Request
      • Oracle Revenue Management and Billing Financial Services Business Processes
      • Oracle Revenue Management and Billing Insurance Business Processes
    • Administrative Processes

Additional Tasks After Dropping Table Partitions

Once you drop the eligible table partitions, you need to do the following:

  1. Rebuild the Global Indexes

  2. Generate the Database Statistics

Related Topics

For more information on... See...
How to rebuild the global indexes Rebuilding the Global Indexes
How to generate the database statistics Generating the Database Statistics

Parent Topic: Information Lifecycle Management (ILM)

© Oracle   About Oracle   Contact Us   Products A-Z   Terms of Use and Privacy