DATABASE

How to create a database manually

An oracle database can be created either using Manually or using DBCA( GUI Method).  But few organizations recommend to use manual method for creating database. Here I have provided steps for creating database Manually with installation of differnt optional components. Before creating an oracle database, Make sure oracle database software is installed. REFER –  Steps […]

create database link from oracle to sql server

Creating a database link from oracle to oracle database is easy. But setting up db_link from oracle to mssql server isn’t straight forward. We need to do odbc setup. Its knows as heterogeneous db_link.  We can achive this either by using third party odbc drivers or using oracle provided gateways utility. Here in this article […]

How to connect to another user without knowing the password in oracle

Suppose  you want to do some activity under another user, But you don’t know the password of that user. Then how you will do it? There is a way you can do it.  See the below demo. Suppose a user TEST1 wants to connect to TEST2 user and create a table and we don’t know […]

How to deinstall and install XDB component

Follow below steps for deinstalling XDB component:  

FOR INSTALLING XDB COMPONENT:  

   SecureFiles = YES or NO (If YES is specified, the XDB repository will use SecureFile storage. If NO is specified, LOBS will be used. To use SecureFiles, compatibility must be set to 11.2. The tablespace specified for the XDB […]

How to create synonym for a schema

 Usually we create synonym for table. But can we really create synonym for a schema?   Yes, there is an undocumented parameter  _enable_schema_synonyms oracle which enables this feature. Check the parameter status and make it true.  

Now Lets say you have a schema named ORA and you want to create synonym for that […]

How to enable/disable archive log mode in oracle database

   There are 2 types of logging mode in oracle database.   1. Archivelog mode In this mode, after the online redo logs are filled , it will move to archive location 2. Noarchivelog mode In this mode, filled online redo logs wont be archives, instead they will be overwritten.   Enable archive log mode: […]

Partition an existing table oracle using exchange method

There are different methods to partition an existing table. Here we will create a non partitioned table(PRODUCT) and convert it to a partitioned table using EXCHANGE option. EXAMPLE: Create a normal table with index and constraints and insert some data:  

Now create an empty interim partitioned table with similar structure as that of […]

Page 5 of 512345
Skip to toolbar