RE: A special way of migration

Unfortunately, it's not a misinformation. With "consistent=y", you will have SET TRANSACTION READ ONLY as the first statement in the export. What does this statement do you can read for yourself in the manual. It wasn't an overuse of sarcasm.
As far as logical backup goes, I would tend not to disagree, but it has nothing to do with CONSISTENT=YES. This "read consistent export" can only ensure consistency with respect to certain point in time if it builds a read-consistent image of the database with respect to that point in time. You have three guesses to guess which structures are used for building such a consistent image.
So Mark, please read the fine manual before you accuse me of being overly sarcastic.

--

Mladen Gogala
Ext. 121

-----Original Message-----

From: Mark Bole [mailto:makbo_at_pacbell.net] Sent: Wednesday, September 28, 2005 12:12 PM Cc: ORACLE-L_at_freelists.org
Subject: Re: A special way of migration

I started a reply on this same point, then cancelled it, but since you (Michael McMullen) brought it up, I will add that the whole quoted paragraph below about "consistent=y" is a jumble of misinformation.

I suggest that over-use of sarcasm intermingled with technical information is resulting in less signal and more noise.

Exp/imp is the only way to perform a logical backup, and as such has its legimate uses, and should not be dismissed out-of-hand. Data pump in version 10g addresses some of the limitations of exp/imp that previously could only be addressed at the OS level (such as using pipefiles in Unix).

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 28 2005 - 11:26:06 CDT