Re: Deleting data permanently

if this is a permanant requirement , you batter consider to create a stored Procedure that will select the vendor specific data and populate another schema having same structure which you can do by dumping database structure without data.

Faheem Rao

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0110161610.565e85da_at_posting.google.com>...
> Martin Schröder <gichtl_at_gmx.de> wrote in message news:<3BCAE7AE.5A563FAE_at_gmx.de>...
> > marcin schrieb:
> > >
> > > 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 ?
> > >
> >
> > Delete all unwanted data, export it an give it to him.
> >
> > 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
>
> Note that in some versions of Oracle (I just happened to be looking at the
> 9.0 release notes a few minutes ago) CREATE TABLE... AS SELECT... won't
> propagate NOT NULL constraints in keys, when the constraints are named
> by Oracle. You might find such pesky things with:
>
> select constraint_name, owner from dba_constraints where owner not in
> ('SYS','SYSTEM') and constraint_name like 'SYS%' and constraint_type = 'P'
> /
>
> And probably something interesting from dba_cons_columns, too.
>
> jg
Received on Wed Oct 17 2001 - 02:38:10 CDT