Re: exp/imp Oracle 7.3

On Thu, 25 Jun 1998 08:47:33 +0100, MotoX <at_at_at.com> wrote:
>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.

I take issue with your issue. Many situations arise in the real world where either the volume of data cannot be known at the time of initial table creation, or the implementation was done improperly for any number of reasons, from silly to practical. I find compress=y useful in many of these situations, particularly coming into a screwy development environment, or even production environments that have lacked proper DBA's for a period of time. There is such a thing as "growth," too. Consider yourself lucky to be in an environment where you can assume you have the time and resources to do it all properly.

Cool email address, though.

>
>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>
>>
>>
>>
>
>

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Jun 25 1998 - 18:21:09 CDT