• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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