Mir Sayeed Hassan – Oracle Blog

Managing Redo Logfiles in Oracle database 11gR2

Brief about the Redo logfiles in an Oracle databases it should contain atleast 2 redo logfile group as mandatory & Oracle writes every statement expect the select statement, Example – update etc, The Oracle writes to the datafile in case if there is power failure or any system crush occur...

Creation of dblink from Oracle to SQL Server

Step by step procedure to create a database link from Oracle Database 11g to SQL Server.

Database Version:

sys@testdb> select INSTANCE_NAME, VERSION from v$instance;

INSTANCE_NAME    VERSION
---------------- -----------
testdb          ... 
Read more..			

How to move the table from one tablespace to another in Oracle database 11gR2

Fallow the step by step procedure as shown below for testing env:

sys@testdb> sho user
USER is "SYS"

sys@testdb> create user mir identified by mir;
User created.

sys@testdb> grant connect,resource... 
Read more..			

Installation of the SQL Developer in Linux

Step by step Procedure to set up the SQL Developer in Linux:

[oracle@testdb etc]$ cat system-release
CentOS Linux release 7.1.1503 (Core)
Dowload the RPM Package for Sql Developer for Linux JDK

Download: JDK1.8

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Filename:...

Resize Redo log files in Oracle database 11gr2

 Note:

• We cannot resize the redo log files in Oracle database as we need to drop them & re-create it, Hence its the only way to resize the redo log files
• Therefore database require at least 2 groups of redo log files regardless the no of...
  Read more..

Set up your own SID name by connecting Sql*Plus in Oracle database

Below example will change the Sql*Plus view & display your DB Name (SID) by connecting username instead of word “SQL”

By default in all the Oracle database as shown below:

SQL> show user;
USER is “SYS”

You need...