Blog - Our findings and learning
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
