Re: 2 DBA problems

From: s Lehaire <s.lehaire_at_meilleuregestion.com>
Date: Mon, 14 Oct 2002 17:10:52 +0200
Message-ID: <aoelm5$7dt$1@reader1.imaginet.fr>

I've got the response for the second question :

I've made a script in a SQL file :

set linesize 500
set heading off
set pagesize 0
spool dropconstraints.sql
select 'ALTER TABLE '||TABLE_NAME||' DROP CONSTRAINT '||CONSTRAINT_NAME||';' FROM USER_CONSTRAINTS;
spool off

"s Lehaire" <s.lehaire_at_meilleuregestion.com> a écrit dans le message de news: aoeja2$6me$1_at_reader1.imaginet.fr...
> HI,
> I've got 2 problems:
>
> 1 - I want to know when a structure of a table have changed and what was
the
> change done.
> 2 - My DB is not correctly structure and I want to create the constraints
> but there's yet constraints existing so how can I drop all constraints
(DROP
> CONSTRAINT my_constraint is not working).
>
> Thx for response
>
>
Received on Mon Oct 14 2002 - 10:10:52 CDT