Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp/imp Oracle 7.3
I take issue with the compress=y. I always set it to 'n', but then I design
and implement my databases properly following the Oracle White Papers on
Space Management. Compressing the extents blows all that design and
implementation work out the window.
MotoX.
MMK Productions wrote in message <6msct9$e6t_at_world6.bellatlantic.net>...
>You might want to use a parameter file to include the export/import
>parameters. This is an ASCII file with the parameters on each line.
>
>Here is an example for your question:
>
># filename: db1fulexp.par
>userid=system/manager
>log=db1fulexp.log
>file=/dir1/exports/db1fulexp.dmp
>full=y
>buffer=500000
>indexes=y
>rows=y
>grants=y
>compress=y
><the line above was the last line of the file>
>
>You can use a similar file for imports
># filename: db1fulimp.par
>userid=system/manager
>log=db1fulimp.log
>file=/dir1/exports/db1fulexp.dmp
>full=y
>commit=y
>buffer=500000
>ignore=y
><the line above was the last line of the file>
>
>
>
Received on Thu Jun 25 1998 - 02:47:33 CDT