Solved

how can we use set pause command

Posted on 2008-10-18
2
1,094 Views
Last Modified: 2013-12-18
How can we use set pause command
sp2 0311 error string expected but not found..
What is the reason?

0
Comment
Question by:dbaseek
2 Comments
 
LVL 6

Expert Comment

by:Jankovsky
ID: 22749875
You have to use either
SET PAUSE ON
or
SET PAUSE OFF
Set pause on pauses after each page (according to SET PAGESIZE xxx ) and requires to press Enter (or Next in iSQL as written:)
0
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 500 total points
ID: 22750857
sp2-0311
SQL*Plus was expecting a string at the end of the command, but could not find it.
Retry the command with a valid string. Check the syntax of the command you used for the correct options.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question