NOTE: Each correct answer would give you 5 points Which portion of the System Global Area, also known as SGA holds information about changes made to the database? The redo log buffer The database buffer cache The large pool The shared pool Which task is performed by the system monitor or SMON process? Copying redo log ... Read more Oracle Database (QUIZ)
Tool Used : SQL Developer version 3.1.07 Schema Used : HR Tables Used : Countries, Departments, Employees, Job_History, Jobs, Locations, Regions Navigate the below path and step by step screen shots: File > Data Modeler > Import > Data Dictionary 1# Select DB Connection and click on next 2# Select Schema/DB you wish to import ... Read more How to generate ER diagram using Oracle SQL developer
In my earlier post I showed you the steps to install Oracle database 10gR2 installation in RedHat 5.4 (64-bit). Now in this post I will guide with the steps and the pre-requisites required for the installation of Oracle 11gR2 in Red Hat 6.2 (32-bit) Pre-requisites before installing database GUI Environment Make sure you have ... Read more Oracle database 11gR2 installation in RedHat 6.2 (32-bit)
While installing Oracle database I was getting this error. I searched various blogs and forums and found out many solutions but lastly I got one solution which worked for me. But well I will post all the possible ways which you can try (as per my knowledge) to overcome this issue. Error: Xlib: connection to ... Read more How to Fix "Xlib: No protocol specified"
In this post I'll show you the steps required to install Oracle Database 10g Release 2 on Red Hat Enterprise Linux 5.4 (64-bit) Assuming you have downloaded Oracle Database 10g R2 from their official website. If not you can get it from the below mentioned link Oracle Database 10g R2 for Linux 64-bit For my ... Read more Oracle database 10gR2 installation in RedHat 5.4
The other day I was installing Peopletools on a Linux instance when I came across this error and I am sure some body else also might get stuck at this stage so i would like to post the solution for this error. Error: SQL Error. Error position: 129 Return: 12899 - ORA-12899: value too ... Read more How to Fix ORA-12899: value too large