DATABASE

User Management in Oracle

User is basically used to connect to database. All db objects like table,index,view etc can be created under that user.In Oracle, users and schemas are essentially the same thing. You can consider that a user is the account you use to connect to a database, and a schema is the set of objects (tables, views, […]

Tablespace Management in oracle

What is a tablespace and datafile: Tablespace is the primary logic structure of the oracle database. It consists of one or more physical datafiles. Datafiles physical stores database data in storage.(DISKS) . So when we create a datafile of 30G in database, it will eat 30G of space from defined storage. All the table or […]

Cloning Oracle home from one server to another server

    Below are the steps for cloning ORACLE_HOME from one server to another server. 1. Check the oracle_home inventory [ SOURCE DB]

2. Check the ORACLE_HOME size[ SOURCE DB]

3. Create the ORACLE_HOME directory [TARGET HOST]

4. Take ORACLE_HOME binary backup [ SOURCE HOST]

5. Scp the tar file to […]

Clone a RAC database to Standalone database using RMAN backup

                    Cloning from a RAC database to standalone database, can be done either using ACTIVE CLONE or by taking  a RMAN backup from RAC database and restoring in standalone database. SEE ALSO – RMAN ACTIVE CLONING Here in this article,we will show db cloning by taking […]

Expdp Impdp Tutorial

1. Import using NETWORK_LINK 2. QUERY CLAUSE in EXPDP 3. SQLFILE parameter in impdp 4. TABLE_EXISTS_ACTION option in IMPDP 5. EXCLUDE/INCLUDE option 6. DATA_OPTION=SKIP_CONSTRAINT_ERRORS 7.LOGTIME=ALL Parameter – Oracle 12c new feature 8. Views_as_tables Parameter In Datapump Of Oracle 12c 9. TRANSFORM=DISABLE_ARCHIVE_LOGGING – Oracle 12c new feature 10. ENCRYPTION in export Import 11. CONTENT parameter in […]

Drop and recreate undo tablespace

Sometimes we may require to drop the existing tablespace undo and create a fresh one if the size of undo has increased a lot and we are unable to reclaim it. Below are the steps: 1. Check the existing UNDO details:

2. Create a new undo tablespace:

3. Update undo_tablespace parameter

4. Check […]

How to recover a dropped user using flashback oracle

                Using flashback method, we can restore an accidentally dropped users in oracle. Basically, we will flashback the database to past, when the user was available, Then take an export dump of the schema, and restore the database to same current state. Once db is up, we can import […]

How to Reload expdp and impdp utility in oracle

   In some cases the datapump utility gets corrupted .  To overcome it , we need to reload the expdp and impdp datapump utility in oracle.   Applicable from 11g onwards.  STEPS: 1.  start the database in upgrade mode:

2. Run catproc.sql and ultrp.sql script.

Tracing sessions in oracle

           There are multiple methods for enabling tracing for sessions in oracle. 1. Enabling tracing for all session of a user.              For this we need to create a trigger.

2. Enabling trace for a single session(using dbms_system)

3.  Enabling trace using oradebug.

[…]

Disabling auto tasks from dba_autotask_client

                       Follow below steps for disabling auto tasks in oracle database.

Page 3 of 612345...Last »
Skip to toolbar