Oracle Base Database service is a for pay offering on OCI but it is quite reasonably priced and suitable for setting up test environments. Still the setup is relatively complex … More Setting up Oracle Base Database Service on OCI
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 … More Enabling tracing on a running DATAPUMP job
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 also provides recommended parameters for exporting and importing, backed by relevant references.
… More Best Practices: Data Migration using Oracle datapump
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 … More Oracle database identity column
Oracle underscores its commitment to helping keep Linux open and free for the global Linux community. — Read on http://www.oracle.com/news/announcement/blog/keep-linux-open-and-free-2023-07-10/
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 … More SQLcl: Customizing on a Mac
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 … More Only on Windows: SQL Developer 23.1 and the Instant Client!!
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 … More SQLcl: Setup on a Mac
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 … More BUG? Oracle SQL Developer cannot access files on mac OS X
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 … More Oracle SQL Developer 23.1 is now available
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 … More Linux Playground on #OCI
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 — Read on aws.amazon.com/blogs/database/managed-disaster-recovery-and-managed-reader-farm-with-amazon-rds-for-oracle-using-oracle-active-data-guard/
How do you calculate the total cost of a cloud database? In this blog, we’ll provide a framework to think about the costs incurred when buying a database. — Read … More How to calculate your true database costs
