Posted by Mir Sayeed Hassan on 31st January 2018
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..
Posted in DBA Administration | Comments Off on Creation of dblink from Oracle to SQL Server
Posted by Mir Sayeed Hassan on 22nd January 2018
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..
Posted in DBA Administration | Comments Off on How to move the table from one tablespace to another in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 22nd January 2018
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:… Read more..
Posted in DB Install & Create | Comments Off on Installation of the SQL Developer in Linux