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

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 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… Read more..

Monitoring any table operation from your own schema in Oracle database SQL> conn mir/mir123; Connected. SQL> select table_name from user_tables; TABLE_NAME ———— TEST1 SQL> conn sys/sys as sysdba Connected. SQL> alter table mir.test1 monitoring; Table… Read more..

How to delete duplicate rows from the table in oracle database Now create new table & insert some records init with duplicate: SQL> create table test_del_dup_rows(eno number(20),name varchar2(20)); Table created. SQL> insert into test_del_dup_rows values(1,’mir’); 1 row created.