Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how can we use set pause command

Posted on 2008-10-18
2
Medium Priority
?
1,108 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 2000 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Suggested Courses

580 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