Home » RDBMS Server » Server Administration » problem in execution
problem in execution [message #261549] Thu, 23 August 2007 00:47 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
hello all,

i have a large database. problem is that here if i m executing then there is no show error and also database is not running.
what to do??

regards,
Anamika
Re: problem in execution [message #261553 is a reply to message #261549] Thu, 23 August 2007 00:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What you execute?
What is the result of this query?
select open_mode from v$database;
Re: problem in execution [message #261556 is a reply to message #261553] Thu, 23 August 2007 00:58 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
11:22:02 SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE



but if i m execting select statement the database is not shown and oracle is also not given error.

if the database upload is less then the execetion is fine..if upload the database is more then the execution is not show the database or any errors.
Re: problem in execution [message #261566 is a reply to message #261549] Thu, 23 August 2007 01:14 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It seems to be it is working ok. It may be a problem in the terminal from which you are executing command. If you use sql*plus check the settings on

Show Pause
Re: problem in execution [message #261569 is a reply to message #261566] Thu, 23 August 2007 01:17 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
nope i m not using SQL*PLUS

it is not working fine

if i m using select statement the data is not shown and not shown any error
Re: problem in execution [message #261573 is a reply to message #261549] Thu, 23 August 2007 01:21 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

By it I mean database not about client tools.

Use "show pause" and whats the result of it. Ensure that you set it off.

set pause off
Re: problem in execution [message #261577 is a reply to message #261573] Thu, 23 August 2007 01:28 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
it is not here...
it is some another place...
Re: problem in execution [message #261892 is a reply to message #261577] Thu, 23 August 2007 23:58 Go to previous message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member


when was my execution is not terminate.so my collegaue restart a computer after that database execute fine.
how to solve this problem?

Previous Topic: Create a new oracle home
Next Topic: Session increase
Goto Forum:
  


Current Time: Wed Dec 07 18:37:21 CST 2016

Total time taken to generate the page: 0.10828 seconds