Member Avatar for rotten69

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
  • 145 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by rotten69
Member Avatar for debasisdas

You need to increase the buffer.

You need to prepare a dynamic script for the same.

Member Avatar for rotten69

any idea on how to do this, mate?

Member Avatar for debasisdas

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;
Member Avatar for rotten69

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.