oracle bakup for record frorm database.and import.

[abidali3]

hi for all .
can we tack backup from developer .. like we are working all day and at night we will want to backup only today data from developer what we can do ...
also import data from file to oracle database by developer..
i am using developer6i and oracle8i.
abidali3.

 

[HimanB]

Hi,
If you have Log date feild in all of your Tables and if the name of the feild is same across the Tables then you may add WHERE Clause while taking the EXPORT i.e WHERE TRUNC(LOG_DATE)=TRUNC(SYSDATE).

If the name of Log date feild is different across the Tables the you will have to Take tablewise export for each table with WHERE clause.

If the log date feild is not available thn I'm afraid nothing can be done.

The only catch for you is to first take a Full export and then form subsequent days start with Incremental/Cumelative export/import from the next day.

HTH
Regards
Himanshu