Home » RDBMS Server » Server Utilities » incremental export
incremental export [message #74353] Mon, 22 November 2004 23:06 Go to next message
yazid
Messages: 3
Registered: November 2004
Junior Member
hello,

hello,
i have multiple oracle databases in differnet locations, i make a consolidation between those databases and the central databases by ftp each end of day manually, i have a table in each location, for each table i make import/export to the central database in dump files, i make the export by ftp, the problem is that i make the export for all records in the table in each location to export it to an other table in the central database, can you help me to make an export for just records thar are changing since the last export, because the dump files have a very large size.

can i use incremental export but for one table.

thanks
Re: incremental export [message #74355 is a reply to message #74353] Tue, 23 November 2004 00:56 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
incremental export is desupported.
Infact it never was an incremental export in the table level.
EVEN if one row of the table is changed the entire table is considered into NEXT incremental export.
Previous Topic: Using EXP utility from Oracle 9i to Oracle 8i
Next Topic: sqlloader newbie
Goto Forum:
  


Current Time: Wed Jul 03 09:46:59 CDT 2024