Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting data permanently
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
-- Resources for OracleT: www.geocities.com/howardjr2000 ========================================= "marcin" <gormar_at_poczta.wprost.pl> wrote in message news:3bcaeb93$0$7111$4d4efb8e_at_news.be.uu.net...Received on Mon Oct 15 2001 - 16:08:05 CDT
>
> Martin Schröder wrote in message <3BCAE7AE.5A563FAE_at_gmx.de>...
> >
> >Delete all unwanted data, export it an give it to him.
> >
>
> I can not delete any data prior export as it's a production DB.
>
>
> >If you have multiple customers you can keep all data in one special
> >(hidden) table. Then you create the specific table by "create table xxx
> >as select * from special_table where customerid=0815". Now do an export
> >(without the hidden table) ad give it away.
> >
> >Martin
>
> It's not one table - it's a lot of tables, containing some data, which
only
> part should be made available to the vendor.
> Creating copy of those tables with required data is not a problem, but
there
> are also indexes, constraints that has to be supplied to the vendor.
>
> regards
>
> marcin
>
>