Home » RDBMS Server » Server Utilities » incremental export
incremental export [message #286028] Thu, 06 December 2007 05:44 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
What is incremental export?
Is it the same as RMAN incremental backup?

Of course apart from logical/physical difference
Re: incremental export [message #286082 is a reply to message #286028] Thu, 06 December 2007 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forget it.
It no more exists.

Regards
Michel
Re: incremental export [message #286262 is a reply to message #286028] Fri, 07 December 2007 01:08 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Does it exist in 9.0.1?
Re: incremental export [message #286279 is a reply to message #286262] Fri, 07 December 2007 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know but don't use it, it was not really useful and was not really fully tested on new (>7) versions.

Regards
Michel
Re: incremental export [message #286292 is a reply to message #286028] Fri, 07 December 2007 02:09 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Ok
We have data coming from 28 different centres evrymonth.
If we do export than evry month the entire database needs to be exported.
How to do incremental export?
ie month wise
Re: incremental export [message #286302 is a reply to message #286292] Fri, 07 December 2007 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

If we do export than evry month the entire database needs to be exported.

Why?

Regards
Michel
Re: incremental export [message #286310 is a reply to message #286028] Fri, 07 December 2007 02:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
To make the backup obviously
Re: incremental export [message #286324 is a reply to message #286310] Fri, 07 December 2007 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
export is not a backup utility.
Use RMAN to backup, then you can make an incremental backup.

Regards
Michel
Re: incremental export [message #286329 is a reply to message #286028] Fri, 07 December 2007 03:18 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
If i lost a table i have to apply the recovery for all the tables in that particular tablespace.
For one table all the tables will get previous data.
In export on the other hand,i can use which table to import.

Is this possible with rman?
Re: incremental export [message #286341 is a reply to message #286329] Fri, 07 December 2007 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With an export, you can RESTORE a table and not RECOVER it.

In addition, with a RMAN backup you can also get back a lone table in addition to many and many things you can't do with an export.

Regards
Michel
Re: incremental export [message #286357 is a reply to message #286028] Fri, 07 December 2007 03:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
So in rman is there an option to restore a single table just as in exp/imp
Re: incremental export [message #286369 is a reply to message #286357] Fri, 07 December 2007 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, I said you can do it, I didn't say there is an option.
RMAN is not a replacement for export/import.
This is explained in the documentation.

Regards
Michel
Re: incremental export [message #286605 is a reply to message #286028] Sat, 08 December 2007 22:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

in rman is there an option to restore a single table


No.
Re: incremental export [message #286612 is a reply to message #286605] Sat, 08 December 2007 23:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Isn't this the first word of my previous reply?

Regards
Michel
Re: incremental export [message #286614 is a reply to message #286028] Sun, 09 December 2007 00:06 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Oh, Sorry Michel. Unfortunately, I omitted it.
Previous Topic: Is import handle relation between parent and child rows.
Next Topic: problem with import in oracle10g express edition
Goto Forum:
  


Current Time: Wed Dec 07 18:40:58 CST 2016

Total time taken to generate the page: 0.05409 seconds