Running Background Process (Oracle Export or Import)

Every time I run an Export or Import in oracle there is always a fear that I might close the window and cancel the process. And believe me it’s not easy or fun to start a process that takes 6-12 hrs. (Not to mention ppl who are ready to kill me).

Any way here is an easy and reliable way to run Export or Import in UNIX.

All you need is to define the text file and a script to execute.


Export.txt
------------

userid=[User ID of the user you going to Export]
filesize=[How much you want the Dump file to be Eg:2000MB]
file=[Names of the Dump files…..Eg:DUMP_1.dmp,DUMP_2.dmp……]
log=[Name the log file …Eg:export.log ]
consistent=n
compress=y
rows=y
indexes=y
..
..
..
..
TABLES=[Names of the table you want to Export]


Note: for more details on Oracle Export check my previous post…[Link]


ExportScript.sh
-------------------
nohup exp parfile=export.txt


That’s all you need, now you need to run the script that’s it….and to check your progress you “more” the nohup file that will be generated after running the script.
For import also you can do the same thing just need to change the text file. (Yah I Know I haven’t post about Oracle Import, but going to post about it soon)

This might not be the best detailed tutorial about this, any way hope this help you get started. =ELK=

Oracle: monitor import session

Importing data from one database to another is a useful feature in oracle. But this takes time so its a good thing to know you progress.Here is a cool script that you can use to monitor your import session:

SELECT
SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name
, rows_processed
, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1)
minutes
, TRUNC(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_minute
FROM
sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "%'
AND command_type = 2
AND open_versions > 0;

I know that i have not yet written about how to use the export and import in oracle(i will be explaining it very soon). But for guys who already using the import method this might be helpful .=ELK=