-
ORU-10027 Buffer overflow
When running a SQL script, I got error ORU-10027 Buffer overflow,limit of 2000 byte. How to set a biger buffer, I tried
set buffer ??? , but did not work.
Another question is , how to use spool command to let the SQL output
going to a file.
Thanks
-
I would suggest RTM first especially this one - Oracle Concepts
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Hi,
Do u want to spool the data from table.
Just try the following steps.
1. select * from table name;
2. Go to File
3. Select Spool
4. Give a Spool file name
5. Just enter the /
6. GO to file
7. Select Spool
8. Select Spool off
9. It will save as LST file
10.Open the LST file in XL or Word.
That's all.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|