Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need auto prompt (yes/no) in impdp script !

shipon_97Jan 22 2014 — edited Jan 22 2014

Dear Friends ,

I write a script to kill a oracle impdp job like below :

[oracle@rptsvr ~]$ cat kill_job.sh

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

export ORACLE_SID=ORCL

impdp system/sys123 attach=SYS_IMPORT_FULL_01 << !

kill_job

After run the script it needs to give manual entry option , 'yes' or 'no' .

like :

Import> Are you sure you wish to stop this job ([yes]/no): UDI-00005: unexpected End-Of-File encountered

while reading input.

Now I want this script will be killed prompting 'yes' command automatically , not manually .

Hope My question is clear .

Please help me regarding this .

This post has been answered by unknown-698157 on Jan 22 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2014

Added on Jan 22 2014

#database-key-features, #export-import-sql-loader-external-tables

3 comments

1,997 views