Skip to content

Bijoos OracleNotes

Mastering the Oracle Stack, One Post at a Time.

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

utl_file

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

  • Upgrading Oracle Autonomous AI Database with Cross-Region Data Guard from 19c to 26ai
  • Oracle GoldenGate and Microsoft Fabric: Better Together for Oracle Database@Azure
  • Optimizing Oracle Database Experience with SQLCL and Claude Desktop
  • Oracle AI Database 26ai Software Install using AutoUpgrade on a Brand New VM!
  • ExaDB-XS vs ExaDB-D – When to choose ExaDB-XS

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 fabric genai goldengate installation machine-learning multicloud oci oracle-11g oracle-12c oracle-19c oracle-20c oracle-21c oracle-26ai oracle-cloud oracle-restart oratidbit oui partition performance 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