0

Hey everyone,

I'm just wondering if there is a way to get around this problem. I'm running SQLplus on UNIX server and SSHing into the server. Whenever I query Oracle DB, a list of results/bunch of tables comes up but I can not scroll up to the top of tables..... Any solution to this? SQLplus shows me around 80-100 lines

And, Is there a way to delete all constraints on table at once?


cheers,

2
Contributors
4
Replies
5
Views
6 Years
Discussion Span
Last Post by rotten69
0

You need to take the list of constraints from user_constraints using a cursor and then frame and execute the following script dynamically.

alter table
   table_name
DISABLE constraint
   constraint_name;
0

yeah thanks for the help, mate. I have dropped the constraints on tables but they are stored in recycle bin. And their names are starting with BIN.... like an encrypted name. To solve this problem, I had to use

PURGE TABLE table_name
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.