Tag Archives: data

Two Simple Methods to Move/Rename Oracle DB Data Files

First Method (must be done as sysdba): 1. First, shut down the database: “shutdown immediate;” 2. Rename and/or move data files to new destination using OS commands (e.g. mv for linux) 3. Startup DB in mount mode: “startup mount;” 4. … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

How to run the Oracle Data Pump Command as sysdba

If you have access to the Oracle DB server OS and user (e.g. via ssh or telnet), then you don’t need to have credentials for any DB user to be able to run the data pump commands, all you have … Continue reading

Posted in Oracle | Tagged , , , , , | Leave a comment

Create a folder for importing an Oracle dump file

Generally speaking, in Oracle DB, for you to be able to import a dump file, you have to use a predefined list of directories in order to read the dump file from, don’t know why, but that’s how it goes. … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment