Skip to content
Saturday, June 25, 2022
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • Data Pump

Category: Data Pump

Oracle DataPump Quick Start

21 August 202021 August 2020 Administrator

INTRODUCTION Oracle Data Pump is the replacement for the original Export and Import utilities.Available starting in Oracle Database 10g, Oracle DaRead More…

Oracle 12c expdp DBMS_AW_EXP: SYS.AW$: OLAP not enabled

21 August 202021 August 2020 Administrator

DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabledDBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabledDBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabledDBMS_AW_EXP: SYS.Read More…

Importing Schema Privileges IMPDP

21 August 202021 August 2020 Administrator

This is expected behavior for a schema level import.Object privileges for which the import schema is the grantee will not be imported in a schema levRead More…

How expdp is faster than exp, what oracle internally change to speed up datapump?

21 August 202021 August 2020 Administrator

Data pump is block mode and exp is a byte mode. So, block mode is always faster than the byte mode ORACLE Export (exp) vs Datapump (expdp) ORACRead More…

exp & expdp: Export file to remote server

21 August 202021 August 2020 Administrator

In this article I will show you how to perform an Export but creating the file in a remote server. Sometimes we have to deal with these kind of “chalRead More…

DataPump on ASM Disk

21 August 202021 August 2020 Administrator

Data pump is really a handy tool. It has many options allowing you to try different ways and provides flexibility. In this entry, I’ll use some of thRead More…

Expdp Backup Using Shell Script

21 August 202021 August 2020 Administrator

Configure a shell script, to take export backup of table daily at 3 PM and send the log to stake holders. Script: ( EXP_TAB_cmprss.sh) !/bin/baRead More…

IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE

19 August 202019 August 2020 Administrator

Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATEIn conventional import utility (IMP) we have ignore =y option which will igRead More…

How to use PARALLEL parameter in Datapump?

19 August 202019 August 2020 Administrator

Many a times, we may observe that datapump is running slow even after using PARALLEL option. But, we donít know that there is a method to calculate Read More…

Different ways to get dumpfile version & other information

19 August 202019 August 2020 Administrator

Lets suppose we have a dumpfile and we have no clue from which database or atleast which version of database it is exported. (assume we donít have aRead More…

Posts navigation

Older posts

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 25
  • 32,394

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.