How can we see the database version in os level
- 6 Answers
- 11994 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / vivek
Run sqlplus command and check.
$sqlplus username/password@connection string
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Why would you call update statistics? : sql server DBA
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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
which background process invoke at the time of upgradation tell me???
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the default port no on which sql server listens? : sql server DBA
how to restore files with rman?
how can you find out if a table can be redefined?
What authentication modes does sql server support? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
