SQL & PL/SQL

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!

Pass value from plsql to unix? unix commands in plsql?

Jason ORCLFeb 6 2006 — edited Feb 6 2006

I'm new to all this.

I am migrating table data from source DB to target.

In a PL/SQL procedure, I am passing in a date. With that date, I am taking all the rows in a table that are created before that date and exporting the data to a dmp file, then importing it to another table on the target side.

3 questions...

Can I do this? Call a unix 'exp' or 'imp' command from plsql?

Can I use the date in the exp call? ie) exp apps/apps ... query /"where creation_date=v_date_in/"

When I import...will the constraints on the target table ignore all duplicates?

Thanks!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2006

Added on Feb 6 2006

2 comments

338 views