Home » RDBMS Server » Server Utilities » Daily Base Back up file
Daily Base Back up file [message #550625] Wed, 11 April 2012 02:17 Go to next message
haider_1pk
Messages: 67
Registered: March 2009
Location: PAKISTAN
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 #550645 is a reply to message #550625] Wed, 11 April 2012 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?

Regards
Michel
Re: Daily Base Back up file [message #550657 is a reply to message #550645] Wed, 11 April 2012 05:56 Go to previous messageGo to next message
haider_1pk
Messages: 67
Registered: March 2009
Location: PAKISTAN
Member
oracle 9i
Re: Daily Base Back up file [message #550659 is a reply to message #550657] Wed, 11 April 2012 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And your OS is?

Regards
Michel
Re: Daily Base Back up file [message #550660 is a reply to message #550659] Wed, 11 April 2012 06:02 Go to previous messageGo to next message
haider_1pk
Messages: 67
Registered: March 2009
Location: PAKISTAN
Member
OS? mean if u want to know about oracle server machine , that is dual core 3.0 ghz
Re: Daily Base Back up file [message #550669 is a reply to message #550660] Wed, 11 April 2012 07:12 Go to previous messageGo to next message
cookiemonster
Messages: 10999
Registered: September 2008
Location: Rainy Manchester
Senior Member
OS = operating system.
In other words - is it running on windows, unix, linux, something else?
We don't particular care what processor you have.
Re: Daily Base Back up file [message #550727 is a reply to message #550669] Thu, 12 April 2012 00:53 Go to previous messageGo to next message
haider_1pk
Messages: 67
Registered: March 2009
Location: PAKISTAN
Member
Windows
Re: Daily Base Back up file [message #550733 is a reply to message #550727] Thu, 12 April 2012 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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.


This is not clear.
If this means that you want to export only data of a specific date but have no date column in your table then it is not possible.
Example:
SQL> select * from t;
        ID F
---------- -
         1 N
         3 N
         5 N

Tell me the date of each row. If you can't, Oracle can't.

Regards
Michel
Re: Daily Base Back up file [message #550735 is a reply to message #550733] Thu, 12 April 2012 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For information, if you were in 10g, you could recreate your tables with ROWDEPENDENCIES option then Oracle adds a hidden column to your table giving the last update time (actually scn) of each row you could access (and so select) with ORA_ROWSCN function.

Regards
Michel
Re: Daily Base Back up file [message #550736 is a reply to message #550733] Thu, 12 April 2012 01:20 Go to previous messageGo to next message
Littlefoot
Messages: 19653
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 #550739 is a reply to message #550736] Thu, 12 April 2012 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OP is using 9i, so documentation is about EXP with also has a QUERY parameter with the same limits; so it will not be 1 export but several (many?) ones: one per query clause.

Regards
Michel

[Updated on: Thu, 12 April 2012 01:28]

Report message to a moderator

Re: Daily Base Back up file [message #550740 is a reply to message #550739] Thu, 12 April 2012 01:33 Go to previous messageGo to next message
Littlefoot
Messages: 19653
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
9i? Is he? Sorry, I missed that (checked topic title, but it wasn't there. Didn't read the rest. Shame on me).
Re: Daily Base Back up file [message #550752 is a reply to message #550740] Thu, 12 April 2012 02:27 Go to previous messageGo to next message
haider_1pk
Messages: 67
Registered: March 2009
Location: PAKISTAN
Member
Is there any solution to make back up program in oracle forms?
Considering dates, between from date to end date in oracle 9i.
Regards,
Haider Ali
Re: Daily Base Back up file [message #550754 is a reply to message #550752] Thu, 12 April 2012 02:30 Go to previous message
Littlefoot
Messages: 19653
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.
Previous Topic: SQL Loader TRIM in WHEN clause
Next Topic: overwrite existing dump file in expdp in oracle 10g
Goto Forum:
  


Current Time: Thu Oct 02 08:28:38 CDT 2014

Total time taken to generate the page: 0.10494 seconds