Category: Database Troubleshooting
-
Oracle Data Pump- External Tables
We discussed external tables using SQL*Loader, but let’s take a little bit of time to look at Data Pump as well. This is a utility to unload and load data into the database. It can also provide you with a quick backup, replicate, and secure copy of your data and metadata. You can use Data…
-
Taking an Export- External Tables
A small amount of setup is required when you run a Data Pump export job. Here are the steps: 1. Create a database directory object that points to an OS directory that you want to write/read Data Pump files to/from. (We used the directory object with our external tables.) 2. Grant read and write privileges…
-
Starting and Stopping the Database and Listener- Automation and Troubleshooting
If a database server is to reboot or restart, it is desirable to have the Oracle databases and listener automatically restart with the server. This process used to be part of a parameter in the /etc/oratab file for the database to automatically restart. It would be called in the dbstart and dbshut commands and was…