Re: Deleting data permanently

Why not perform an export and set ROWS=N and export the whole database or just the tables you want. That in turn will export the tables, ddl for indexes, constraints, roles, grants, so on and so on. Then you could do your temp table bit with just their data. They then still will not be able to get the data you have, just the data you supply them with in your temp tables. I've done a full export on a 90 gig db on AIX and only took approx. 30 min. time with a relatively small dump file.

HTH,
Pete's

"marcin" <gormar_at_poczta.wprost.pl> wrote in message news:<3bcbd95d$0$12222$4d4efb8e_at_news.be.uu.net>...
> Howard J. Rogers wrote in message <3bcb500b_at_news.iprimus.com.au>...
> >No version supplied, so this is just guess work, but transportable
> >tablespaces seem like the way to go. Use the 'alter table X move
> tablespace
> >Y' to move all the vendor's data segments into a single tablespace. Use
> the
> >transport tablespace options to create a fairly small dump file, then ship
> >that and the relevant dbf to the vendor. He should then simply be able to
> >plug it in to whatever database he has available.
> >
> >Regards
> >HJR
>
> Oooppsss,
> sorry - really forgotten. Oracle 8.1.6 on NT 4.0
> Your solution seems ok for transporting a table - what about indexes ? They
> would also have to be moved to different tablespace then. If there are a
> lot of objects to be moved - that's gonna be time-consuming. I was rather
> looking for simple approach like dumping DB structure without data (if
> possible), recreating that on the vendor's side, then creating temp_tables
> containing only vendor data , dumping and bulk loading them to the vendors.
>
> My primary question , however , is , considering my first approach - would
> turning db into noarchivelog mode before deleting records be enough not to
> let the DB be recovered by the vendor ? (vendor has no backup of the
> original DB)
>
> best regards
>
> marcin
Received on Tue Oct 16 2001 - 08:24:08 CDT