update a table through a .sh script

We require a table to be refreshed with production data in every three hours.
•  Table size is only 125KB
•  There are no associated Indexs/constraints/triggers on this table

Both Database are 10g R2 and on aix 6. Both the Database is on different Hosts(machine)




Thanks
sachin_dbaAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Assuming database links between the two systems isn't allowed.

Easiest way is to just use export/import.

If you can do remote shells:
Create a script to run exp or expdp on the remote machine, rcp or ftp it over to the other machine.  Truncate the table and run imp or impdp to load the data.
0
 
sachin_dbaAuthor Commented:
I've requested that this question be deleted for the following reason:

Old question, not required now.
0
 
slightwv (䄆 Netminder) Commented:
Just because you no longer need the answer does not mean we didn't answer the question.

Just deleting a question to get around the new question lock isn't the correct thing to do.
0
 
sachin_dbaAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.