Code:
    SPOOL drop_constraint.sql

    SELECT 'alter table '||owner||'.'||table_name||
                ' drop constraint '|| constraint_name ||';'
      FROM DBA_CONSTRAINTS
      WHERE OWNER = ' your_name';

     SPOOL OFF;

    Note: If you only have the user privileges, then use 
            USER_CONSTRAINTS instead of DBA_CONSTRAINTS 
                view.
Now edit the drop_constraint.sql script and then execute it on the sqlplus...

Code:
           SQL> @drop_constraint

Hope this would help you.

Sam

[Edited by sambavan on 10-15-2001 at 01:39 PM]