Re: 2 DBA problems

s Lehaire wrote:

> 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

Q1:
Go to http://tahiti.oracle.com
and search on "DDL TRIGGER"

Q2:
SELECT CONSTRAINT_NAME
FROM user_constraints
WHERE TABLE_NAME = '<table_name>';

ALTER TABLE <table_name>
DROP CONSTRAINT <constraint_name>;

And do them one at a time.

Daniel Morgan Received on Mon Oct 14 2002 - 10:39:41 CDT