Re: What to do if space for database decrease and no additional hard drive is possible?

2010/7/26 A. Kretschmer <andreas.kretschmer@schollglas.com>:
> In response to Ivan Voras :
>> * buy external storage (NAS, or even an external USB drive), move the
>> database to it
>
> buy external USB-Drive, and create a new tablespace, and move some large
> table into this new tablespace and/or use the new tablespace for new
> tables. You can also use table-partitioning with different tablespaces.

Table space on a USB drive?
You must be really sinking for this very option!
I'd rather move everything else from the crowded partition onto the USB drive,
as I would suppose that the database (performance and reliability) is
more important by far ...

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS