Sunday, April 4, 2010

EXP nd IMP

EXP:
===
Always it adiviceble and time saving to backup of Large Tables like this

exp userid=applsys/*****file=$ORACLE_HOME/FND_LOBS.DMP indexes=n log=$ORACLE_HOME/EXPORT.LOG tables=fnd_lobs

IMP:
===
imp userid=applsys/*******file=$ORACLE_HOME/FND_LOBS.DMP log=$ORACLE_HOME/IMPORT.LOG fromuser=applsys touser=applsys tables=fnd_lobs ignore=y

1 comment:

  1. Guys add up the Post with Detailed information about export/import options & about data pump too.

    ReplyDelete