| Daily Base Back up file [message #550625] |
Wed, 11 April 2012 02:17  |
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
|
Senior Member |
|
|
Hello Friends,
I made small Inventory software for Medical store. Now I want daily base data in DMP file. How to make current date in DMP file don't need all.
I mean I have 30 tables in oracle sql . They are daily update with new entry and some table has date column and some not.
Actually I want to send daily Data via mail.
Regards,
Haider Ali
03335875026
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Daily Base Back up file [message #550736 is a reply to message #550733] |
Thu, 12 April 2012 01:20  |
 |
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Huh, right. However, depending on data model, this *might* be possible with some help of EXPDP's QUERY parameter. For example, if there was another table, let's call it "daily_records", that contains time stamp, then you'd be able to fetch these records from Michel's "t" table. For example:select *
from t
where t.id in (select d.id from daily_records d
where d.date_column = trunc(sysdate) - 1
)
If that's so, it could be used in QUERY parameter as well. Creating a command line with 30 tables that look like this is not an option, but - creating a parameter file is something different (read: better). Here's an example of how to do that: Using QUERY parameter in expdp/impdp which, along with Oracle documentation might help.
|
|
|
|
|
|
|
|
|
|
| Re: Daily Base Back up file [message #550754 is a reply to message #550752] |
Thu, 12 April 2012 02:30 |
|
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
If you can make it work as described above, then Forms is capable of calling an operating system batch script (using HOST or CLIENT_HOST built-in) which will do the rest of the job. Crucial thing is to make it work.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
