Exporting and importing data

[jgustin]

Is it possible to export based on last modified date? And if I can wll it be able to import into a different database with all the same fields and schema but with slightly different account information. I would like to update this with all information that was exported but lose any of the current info.

[karthiarun]

Its is possible to export the last modified data. U can use Incremental Export. And if u have altered the structure of the tables then u have to create the modified table structure in the database in which the import is done. Any suggestions...

[sambavan]

The way to do this is to create table xyz as select * from table_name where lastmodifiedfdate between x and y.

Then you can export this table. and import into another user or to the same user.
Sam