Home » RDBMS Server » Server Administration » command buffer space exhausted
command buffer space exhausted [message #369433] Thu, 21 September 2000 08:50 Go to next message
Charleton
Messages: 4
Registered: September 2000
Junior Member
I am having a problem creating a package. I give the path to the file in sql*plus (SQL>@c:\temp\procs.sql) then I get the following messages:

Package created.

command buffer space exhausted
command buffer space exhausted
command buffer space exhausted

The package body is not created. What is going on here? Is this a memory issue? Can anyone help me???

Report message to a moderator

Re: command buffer space exhausted [message #369435 is a reply to message #369433] Thu, 21 September 2000 11:22 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
If you are using the sqlplus on a Windows Machine.
Then you can go under options on the menu bar.

And select environment and increase the buffer width and buffer length parameters.

Bala.

Report message to a moderator

Re: command buffer space exhausted [message #369436 is a reply to message #369435] Thu, 21 September 2000 12:29 Go to previous messageGo to next message
Charleton
Messages: 4
Registered: September 2000
Junior Member
Hello again. I tried increasing the buffer width and length parameters and still received the same error. Any oher ideas?

Report message to a moderator

Re: command buffer space exhausted [message #369439 is a reply to message #369435] Thu, 21 September 2000 14:16 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,

Did you try to run the sql from the svrmgr.
svrmgr>@c:\temp\procs.sql.

Thanks
Bala

Report message to a moderator

Previous Topic: Rollback Segment
Next Topic: moving of datafiles.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 05:42:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.