Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Prerequisites before Export and Import Process datapump

Prerequisites before Export and Import Process
1.Make sure you have set variable ORACLE_HOME in your environment. Yours may be vary from mine. 
export ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
2.Create a directory on your system, where we gonna put the Oracle Data Pump (dump) file. As for me, I wanna save the data pump file into /home/oracle/dpump_dir mkdir /home/oracle/dpump_dir

3.Next we need to create the “directory” from SQLPlus. You must logged in as SYSDBA. dbora is SID name on my system. 
$ORACLE_HOME/bin/sqlplus sys@dbora as sysdba

4.After logged in SQLPlus, execute this command
 create directory dpump_dir as '/home/oracle/dpump_dir';
grant read,write on directory dpump_dir to dbuser;
dbuser is the username that we will use it for export and import process.

5.We also need to give the dbuser privileges to create any directory and to export / import full database. 
grant create any directory to dbuser;
grant EXP_FULL_DATABASE to dbuser;
grant IMP_FULL_DATABASE to dbuser;

Comments

Popular posts from this blog

PostgreSQL pgBadger

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart