| e-mail from one software to another software which have same database [message #60651] |
Tue, 24 February 2004 01:27  |
shahzad
Messages: 17
Registered: February 2002
|
Junior Member |
|
|
|
dear sir, pls help me . we have software application installed on different locations....we want to send an e-mail from the one location to another, bcoz they are sharing same information.....if we send using the export utility and attched with mail. then the everey time the time is waste to drop the existing tables and create the new....it is possible to send mail of the specific records.....thx for help me ..
|
|
|
|
| Re: e-mail from one software to another software which have same database [message #60658 is a reply to message #60651] |
Tue, 24 February 2004 04:43  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
If you are on 8i & later, you could use the QUERY exp parameter to restrict the rows exported (say only additional rows) into the dump file. This then can be imported without having to drop & recreate the tables. But if you want to copy over 'changed rows' then it might also include purging those corresponding rows in the target and exporting all the changed rows followed by import. The better alternative is to implement Oracle replication for replicating changes between databases.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
