Importing Database

To make db instance up:-
login as oracle user

source sett.csh <db>
lsnrctl start
sqlplus /nolog
conn logon as sysdba;
password <blank>
startup
================================================
Steps to import Import Data dump:

create Directory <name> AS '<path>/dumpfile'
grant read,write on DIRECTORY <name> TO sa;
impdp sa/sa@<Instance> DIRECTORY=<name> dumpfile=file.dmp


Comments

Popular posts from this blog

How to use a value between two different threads in Jmeter

Steps to Analyze AWR Report in Oracle

Correlation and checking in Results