There are several ways of removing fragmentation in oracle database:

1. Export and Import
2. Moving the tables to a different tablespace and then back to old tablespace.
3. Moving the tables to same tablespace.

You may choose any of the options but moving tables may require you to check space requirements

Not to implement the 3rd option we have two ways :

Method 1- through direct SQL queries.
Method 2- through bash script.

With recent job cuts becoming the headlines of major newspapers these days, it is important to know the reasons for the major downfall of IT market.

Oracle Database Architecture.

Database: It is a system to organize, store and retrieve data.

Relational database: It is that which allows linking tables in a database. This can be manipulate and accessed by SQL (Structured query language), It is to stop data duplication and enforcing data integrity by relating or sharing columns between two tables in a database.

Program Languages: SQL, PL/ SQL, JAVA

Oracle Goldengate supports the data replication across various database platforms. The Goldengate replication topology includes the capture and transfer of the extracted data from the source database to the destination database.

Oracle Goldengate topologies are described in the below diagram:

Goldengate Topologies

• Uni-directional: Data is replicated in one direction from source to target database.

When you share a link of a web page, the social media like Facebook, Google etc. captures an image from the webpage. This may happen in a random manner but if you want to let the social media know how to display your page information, the below code has to be formatted dynamically or statically hard coded in the head of html, for social media to crawl and understand your data:

1. Oracle databases of versions 10.2.0.5, 11.1.07 & 11.2.0.2 or higher can be directly upgraded to 12c version. All others need an indirect upgrade.
2. Prior to upgrade take a cold backup of the source database.