Re: Deleting data permanently

From: Kirmo Uusitalo <kirmo.uusitalo.no.spam_at_iki.fi>
Date: Wed, 17 Oct 2001 12:21:57 +0300
Message-ID: <dD3NO=pFxKmMVMnOIDdqDiOyr6D1@4ax.com>

On Mon, 15 Oct 2001 15:22:35 +0200, "marcin" <gormar_at_poczta.wprost.pl> wrote:

>Hi there ,
>
>I would like to give a part of the database to one of vendors, shipping him
>with the whole structure and only that part of data it's interesting for the
>vendor.
>
>Shall I do that by restoring full database from the backup, altering db to
>noarchivelog mode and then deleting unwanted data , or is there any other
>way, effortless and quick-to-apply ?
>
>regards
>
>marcin
>

Wouldn't it be easy to do an export file with the query= parameter? such as exp scott/tiger tables=emp query=\"where empno>99\"

We've found this new option in Oracle export and import programs very useful.

HTH, Kirmo Uusitalo
kirmo.uusitalo(at)iki.fi Received on Wed Oct 17 2001 - 04:21:57 CDT