Skip to content

Bijoos OracleNotes

Mastering the Oracle Stack, One Post at a Time.

  • Home
  • My Certs
  • OCA 12c Certification
  • All Posts
  • All Presentations

dbms_datapump

A PL/SQL Program – After many many years!

February 7, 2026August 2, 2013 by Biju

Wrote a little pl/sql program after several years… glad it worked as expected… thought of sharing the code, might be useful for someone out there… The requirement is to drop tables that are older than 60 days from a schema named CR_BKUP periodically. Did not want to just drop the tables, so taking a backup … Read more

Categories Oracle Database, Scripts & Tools Tags dbms_datapump, utl_file

Recent Posts

  • Part 5: Picking the Right Database@Azure Service for EBS — A Decision-Maker’s Guide to Sizing and Licensing
  • Part 4: EBS Platform Move — Unix to Azure Linux with Smaller Cutovers — Migrating Oracle EBS from Legacy Unix to Oracle Database@Azure
  • Part 3: Resilient ERP — Backup, Recovery, and Cyber-Resiliency with Database@Azure
  • Part 2: Oracle EBS Economics: Oracle on Azure VMs vs Oracle Database@Azure — A Real TCO Comparison
  • Part 1: The EBS Cloud Reality Check — Why “Lift and Shift to VMs” Doesn’t Work for ERP

Categories

  • Certification & Learning
  • Cloud & Autonomous Database
  • GenAI and Automation
  • Infrastructure & Exadata
  • Multi-Cloud & Hybrid
  • Oracle Database
  • Oracle E-Business Suite
  • Scripts & Tools
  • TidBits & Quick Tips
  • Uncategorized

Archives

Tags

autonomous-database autoupgrade certification change-data-capture claude clone cloud-control concurrent-jobs conference data-refresh database-azure database-upgrade dbca dbms_datapump ebs exadata fusion-aidp genai goldengate installation machine-learning multicloud oci oracle-11g oracle-12c oracle-19c oracle-20c oracle-21c oracle-26ai oracle-aidp oracle-cloud oracle-ebs oracle-restart oracle-security oratidbit oui partition performance platform-migration printer security srvctl streams tablespace utl_file

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

© 2026 Bijoos OracleNotes • Built with GeneratePress