Re: Deleting data permanently

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

--
Dang, what was that funny sig quote?