Blog - Our findings and learning
loadjava: Loading Java Sources/Classes/Jars into oracle Database
Loading the Java Sources/Classes into Database is important thing in Java based application software. Java sources (jar/Classes) can be loaded into database by using few
ORA-12154: TNS: could not resolve the connect identifier specified
WhatDatabase link is an option to connect to a remote database from another database. By using this database link option one can connect to remote
get tables and their number of rows in Oracle Database Schema
Simplest way is to use the data dictionaries provided by Oracle. And you can depend on the results if the schema is up to date
expdp : Exporting datadump in Oracle 11g
The export can be done in two ways from local machine from Server From Local MachineFor Windows operating system Follow the steps# create directorycreate directory
OLAP vs OLTP vs Datawarehouse Database
There is nothing about the database itself that “makes” it an OLAP, or a DW, or an OLTP.That is all a matter of how it
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE in PLSQL
In Big/complex applications, it is essential to call Sub-programs (Procedures/Functions) from other sub-programs. In that case it will be difficult to trace out Errors/Exceptions from
Histograms in Oracle for Table Columns
Histogram:A histogram is a special type of column statistic that provides more detailed information about the data distribution in a table column. Purpose of Histograms:By
ORA-30926: unable to get a stable set of rows in the source tables
We will get this when we are trying to update a row in a table, for which there will be two or more corresponding records.
ORA-06502: PL/SQL: numeric or value error
We may get this error, when we try to assign a value to a variable which is bigger than the maximum size of the variable.Find
