Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

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
0
sachin_dba
Asked:
sachin_dba
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) 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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now