| How to Query Large table .? [message #428005] |
Mon, 26 October 2009 14:23  |
MR[T]
Messages: 62
Registered: March 2009
|
Member |
|
|
Hello
I have a table which have More than 2,00,000 Rows .
Now when i query SQL prompt becomes Not responding .
I am unable to understand how to view records of table .?
Regards
MR.T
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to Query Large table .? [message #429798 is a reply to message #428005] |
Thu, 05 November 2009 17:30  |
 |
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
|
Senior Member |
|
|
when you execute a query in sqlplus, it will get all the rows you asked for and dump them to your screen.
You are asking sqlpus to show you 2 million rows? Really? How long did you think that would take? Are you spooling this to a file? Are you actually going to watch 2 million rows scroll across your screen for hours or days?
Please explain what you were expecting?
Kevin
[Updated on: Thu, 05 November 2009 17:30] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
