[vc_row][vc_column][vc_custom_heading text=”Top Reviews” font_container=”tag:h2|text_align:left|color:%23000000″ use_theme_fonts=”yes”]
Before You Begin Purpose In this tutorial, you learn how to migrate on-premises Oracle 11g database schemas to an 11g database in Oracle Database Cloud Service, using Data Pump conventional export and import. Last Updated March 2016, Release 16.1.5 Please note that Oracle develops its cloud services in an agile manner and makes rapid changes…
Today I want to write about one of the most used tools for migrating from Oracle to PostgreSQL. Ora2Pg is Free Software written and maintained by Gilles Darold. In this example Oracle database and the PostgreSQL database are running on the same server. I will show both variants of migration: Variant 1- Oracle and PostgreSQL running…
A massive database storing tens of millions of SMS text messages, most of which were sent by businesses to potential customers, has been found online. The database is run by TrueDialog, a business SMS provider for businesses and higher education providers, which lets companies, colleges, and universities send bulk text messages to their customers and students. The Austin,…
Monitoring data about your servers helps you troubleshoot and optimize for your workload. Azure Database for PostgreSQL provides various monitoring options to provide insight into the behavior of your server. Metrics Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted…
As an application user you might have been asked to write a cleanup script to delete old data from a big table which is having millions of rows based on date or some fields. Being a DBA, application guys used to ask me any best way to delete huge amounts of rows from a huge…
it’s hard sometimes to know which skillsets are most crucial to your job when taken on the responsibilities of a DBA. The job responsibilities of DBAs are vast and complex and often dip into other areas of IT – so which ones should you hone first? In this blog post, we’re going to outline the ones…
