Mir Sayeed Hassan – Oracle Blog

Managing Temporary Tablespaces in Oracle database 11gR2

The temporary tablespace is basically used for sorting the large tables in database & database should contain 1 temp tbs in it, this temp tbs are created while creation of the database itself, Therefore if it requires you can create multiple temp tbs in the database.

sys@TESTDB>... 
Read more..			

Increase or decrease the size of Tablespace and Datafiles in Oracle database 11gR2

 To Increase/extend the Size of a tablespace

Method 1 – Increase/Extend the size of the tbs using the resize keyword as shown below:

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

INSTANCE_NAME   ... 
Read more..			

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:...