Radu Pârvu

Notes on tech, tools, and thinking

    Welcome to Radu Parvu’s site on tech and news of the world!

    Enabling tracing on a running DATAPUMP job

    Oracle

    • Enabling tracing on a running DATAPUMP job

      Enabling tracing on a running DATAPUMP job

      Hi guys, In the last article I’ve mentioned about how to enable tracing on a datapump (export/import) job. What if I already triggered my datapump … Enabling tracing on a running DATAPUMP job

    • Best Practices: Data Migration using Oracle datapump

      Best Practices: Data Migration using Oracle datapump

      This article emphasizes common mistakes clients make in data migration strategies using Oracle datapump. Instead of risking the migration process with large data dumps, the author suggests a strategy to ensure the success of data migration. This includes validating all constraints, refraining from exporting certain database elements, and running jobs in interactive mode. The article…

    • Oracle database identity column

      Oracle database identity column

      A few days ago, I came across the topic of identity columns in Oracle. So I decided to try it out to check if it would benefit my database tables.  I… Oracle database identity column

    • Keep Linux Open and Free—We Can’t Afford Not To

      Keep Linux Open and Free—We Can’t Afford Not To

      Oracle underscores its commitment to helping keep Linux open and free for the global Linux community. — Read on www.oracle.com/news/announcement/blog/keep-linux-open-and-free-2023-07-10/

    • SQLcl: Customizing on a Mac

      SQLcl: Customizing on a Mac

      In this post I will summarize the steps I’ve taken to customize SQLcl on my Mac working environment. We assume that the reader is familiar with the procedures outline din my previous post on SQLcl on setting up SQLcl on Mac environment. Terminal customization First I start with changing the terminal a bit in order…

    • Only on Windows: SQL Developer 23.1 and the Instant Client!!

      Only on Windows: SQL Developer 23.1 and the Instant Client!!

      If you require a ‘thick’ connection in SQL Developer 23.1 running on Windows, you’ll need to either: Use a 21c Client Use the 21c Instant Client with… SQL Developer 23.1 and the Instant Client

    • SQLcl: Setup on a Mac

      SQLcl: Setup on a Mac

      Simple and straightforward steps about how to setup Oracle’s new SQL command line tool on a macOS X environment. Download Application and Environment Setup Attempt to start the application: Setup Java Download Java from the Oracle site. As I am on a mac wit M processor (ARM) , I cannot install jre-8u371-macosx-x64.dmg, so I cannot…

    • BUG? Oracle SQL Developer cannot access files on mac OS X

      BUG? Oracle SQL Developer cannot access files on mac OS X

      I used Oracle SQL Developer for years until recently (possibly after the upgrade to macOS 12.6.5?) when the SQL Developer stopped being able to access the files stored locally: The software does not prompt for access at start-up, not after the upgrade nor if I delete the fully the ./sqldeveloper/ directory. The solution seems to…

    • Oracle SQL Developer 23.1 is now available

      Oracle SQL Developer 23.1 is now available

      It’s time to go update your desktop copy of SQL Developer! We have some very important bug fixes for our community of Oracle Database users, … Oracle SQL Developer 23.1 is now available

    • Linux Playground on #OCI

      Linux Playground on #OCI

      Spring is here and I will definitely spend more time outside on my bike and carrying my iPad in my backpack. So I was looking for an easy to setup environment to practice and train my shell scripting skills. And Oracle Always Free has a simple solution for that! I setup a small compute instance…

    • Always Free Resources

      Learn what Always Free resources are available to all Oracle Cloud Infrastructure users. — Read on docs.oracle.com/en-us/iaas/Content/FreeTier/freetier_topic-Always_Free_Resources.htm

    • Managed disaster recovery and managed reader farm with Amazon RDS for Oracle using Oracle Active Data Guard | AWS Database Blog

      Managed disaster recovery and managed reader farm with Amazon RDS for Oracle using Oracle Active Data Guard | AWS Database Blog — Read on aws.amazon.com/blogs/database/managed-disaster-recovery-and-managed-reader-farm-with-amazon-rds-for-oracle-using-oracle-active-data-guard/