Data export/import problem.
hi every1 here
this is my first posting n i expect ur co-ordination if my question is upto ur level.
my problem is described as.
First I export data from FTP site to a server(nothing particular just common spare server) and then i import this data into my oracle server where my oracle enterprise is running.
I keep tranferring data about two time a day.First time i export it in morning tht is abt 100-150 MB arhived data.When i export data second time..it takes data (arhived file) from starting that is thata data also gets exported again that is already recivede in morning. Is there any alternative that i should export that file to my server without taking the data that is already exported first time.
I only want the differential i.e the difference of data (data that is uploaded after first shift)
As my boss has put me to handle oracle server i donnt know n othing..n he has ordered me to take me only as future DBA of company as a dummy DBA ...still m doing woteva i can..despite no help
Thx in advance !!
Please do help.
Re: Data export/import problem.
Hi Friend
Can u tell me that in which format u export the data from FTP site?And how u export this?
where u store your this data in your spare sever?
and do not worry about bosses,they are meant for abuses.......
praveen
Quote:
Originally posted by secureall
hi every1 here
this is my first posting n i expect ur co-ordination if my question is upto ur level.
my problem is described as.
First I export data from FTP site to a server(nothing particular just common spare server) and then i import this data into my oracle server where my oracle enterprise is running.
I keep tranferring data about two time a day.First time i export it in morning tht is abt 100-150 MB arhived data.When i export data second time..it takes data (arhived file) from starting that is thata data also gets exported again that is already recivede in morning. Is there any alternative that i should export that file to my server without taking the data that is already exported first time.
I only want the differential i.e the difference of data (data that is uploaded after first shift)
As my boss has put me to handle oracle server i donnt know n othing..n he has ordered me to take me only as future DBA of company as a dummy DBA ...still m doing woteva i can..despite no help
Thx in advance !!
Please do help.