At 06:00 PM 23/12/2009, you wrote:

>Hi,
>
>We have an application which takes some raw data as input, processes it and stores the output in different tables.
>Now i dont want my raw data to be the part of the backup, as over a period of time the raw data will increase.
>
>Also, i dont want to delete the raw data from my original database, unless the user explicitly asks to delete the data.
>
>I thought of keeping the data in a seperate db initially, but later thought certain queries may take long time to execute.

Well - either
/ you want the raw data in the database (because you have to return to it for some reason) and therefore it should be backed up
or
/you are not interested in the raw data once it has been extracted into tables

Are you using external tables for the raw input?

./heLen