Re: Impact on exp/imp in production system.-Direct=y

On Mon, 18 Oct 1999 13:40:31 -0400, duraisingh <duraisingh_at_yahoo.com> wrote:

>Hellow Gurus.
>Can any one can tell me , what is the difference between direct &
>conventional path on the exports.I know it ll fasten exp/imp timings.
>
>Since I want to reorg the fragmented tables thru direct =y option .
>Some of my friends told me that it's not the secured & proven method on
>any production system.
>Is it true & why???
>I think some of you guys might have gone thru this question.
>
>John Durai
>Prod.Supp Dba -Tampa
>

Normal export issues normal selects. Direct export bypasses the select layer and reads directly from tables. I would think this precludes the use of consistent=Y, which makes sure your export is consistent, ie the export process will not see any transactions. You will usually not manage to do so, because your rollback segments are too small. Also direct export is always done in the native characterset of the database, no conversion will be allowed. To minimize the consistency issue, you could as well kick everyone out, and issue an alter system set restricted_session=true, which makes sure only DBAs can connect.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Oct 18 1999 - 14:01:12 CDT