Interested to Buy Any Domain ? << Click Here >> for more details...
how will you see when the database was started using sql prompt?
- 2 Answers
- 6596 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pvenkiroyal
select to_char(startup_time,'hh24:mi:ss dd-mom-yy') from
v$instance;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what are the benefits of flashback feature?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Where would you look for errors from the database engine?
what is the role of dip user in our database?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different types of indexes available in sql server? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
how can you communicate with operating system files from oracle?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the default fill factor value? : sql server DBA
What is a system database and what is a user database? : sql server DBA
which background process invoke at the time of upgradation tell me???
