Home » RDBMS Server » Backup & Recovery » Incremental Backup of updated and new records/tables
icon5.gif  Incremental Backup of updated and new records/tables [message #247171] Sun, 24 June 2007 23:30 Go to next message
mk_agg1969
Messages: 19
Registered: August 2006
Location: india
Junior Member
Hi Gurus,

I am new to oracle server. I want to learn how can we use export utility in oracle 8.0.3.0.0. My target is to export only the new records/tables/triggers/procedures and changed things not the entire tables in which records have been modified or added.

right now I am using following command:

export: exp80 inv/inv FILE=C:\INC\SLVINC FULL=Y INCTYPE=INCREMENTAL

import: IMP80 INV/INV FILE=C:\INC\SLVINC FULL=Y IGNORE=Y

which exports the entire tables in which changes have been made.

Can anyone help me in this matter?

Regards,

Manoj Aggarwal

Report message to a moderator

Re: Incremental Backup of updated and new records/tables [message #247172 is a reply to message #247171] Sun, 24 June 2007 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can anyone help me in this matter?
NO!
V8 has not been supported any time this century.
exp does not support any viable incremental capability.

Report message to a moderator

Re: Incremental Backup of updated and new records/tables [message #247182 is a reply to message #247171] Mon, 25 June 2007 00:22 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
mk_agg1969 wrote on Mon, 25 June 2007 10:30
Hi Gurus,



right now I am using following command:

export: exp80 inv/inv FILE=C:\INC\SLVINC FULL=Y INCTYPE=INCREMENTAL

import: IMP80 INV/INV FILE=C:\INC\SLVINC FULL=Y IGNORE=Y

which exports the entire tables in which changes have been made.



Regards,

Manoj Aggarwal



How does that work!!! I think you are making wrong. Export does not support incremental.

Report message to a moderator

Previous Topic: rman restore error
Next Topic: question about recover until restore point
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 04:32:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.