Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

ORACLE EXP/IMP &DATAPUMP INTERVIEW QUESTIONS

-
  1. How can i make export faster?
    1. By using DIRECT=Y and BUFFER parameters
  1. Which process is responsible for writing data into dumpfile?
    1. Which process is responsible for writing data into dumpfile?
  1. What is the use of consistent=y parameter in export?
    1. It will take consistent values while taking export of a table
  1. What the parameter COMPRESS will do during export?
    1. During import, It will put entire data in a single extent
  1. How can we confirm that export dumpfile is valid?
    1. By using SHOW=Y option during import
  1. If you got a dumpfile to import and don’t know the fromuser, how you will get  that information?
    1. We can check that in export log file. If not, we can do import with SHOW=Y which generates a log file. Fromuser will be there in that log file
  1. What precautions you will take t perform a schema exp/imp between a prod and  dev database?
    1. We need to check if already user existing in dev database
    2. If so, drop the user (take DDL and permissions info well before) or drop all the objects
  1. What are the advantages of datapump over exp/imp?
    1. It is faster than exp/imp as we can use parallel and other options
    2. List all other from your class notes
  1. Can we import a 11g dumpfile into 10g database using datapump? If so, is it also  possible between 10g and 9i?
    1. Yes we can import from 11g to 10g using VERSION option. This is not possible between 10g and 9i as datapump is not there in 9i
  1. We exported a table and imported into dev database. After checking we found  table is residing in SYSTEM tablespace. What could be the reason?
    1. The user is having RESOURCE role assigned. If we assign RESOURCE role, it will give some quota on SYSTEM tablespace which is dangerous
  1. What you will do when export is running slow?
    1. We need to skip taking export of indexes, use BUFFER and DIRECT parameters
  1. Import process is running slow, what can you do now to make it faster?
    1. We can skip importing indexes as it is the most time taking job during import
  1. You are observing undo tablespace error during import, how you will avoid it?
    1. We can use COMMIT=Y option

Comments

Post a Comment

Popular posts from this blog

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

-
Image
Below tutorialdba.com collected and sorted out hundreds of universal License Keys for all major versions of VMware Workstation Pro (not for VMware Workstation Player) 4.x, 5.x, 6.x, 7.x, 8.x, 9.x, 10.x, 11.x, 12.x and v14.x on Windows and Linux platforms (support both 32-bit and 64-bit operating system) in this single post. Besides, we also provide some license keys for VMware other projects. Just enjoy and share them. // 4~14 Universal License Keys // Version License Keys VMware Workstation VMware Workstation 4.x.x ZHDH1-UR90N-W844G-4PTN6 G1NP0-T88AL-M016F-4P8N2 ZC14J-4U16A-0A04G-4MEZP J1WF8-58LDE-881DG-4M8Q3 VMware Workstation 5.x.x LUXRM-WP0DN-A256U-4M9Q3 DJXDR-NDT27-Y2NDU-4YTZK DA925-HP80U-Z8HDC-4WXXP 3KW2W-AYR2C-88M6F-4MDQ2 VMware Workstation 6.x.x A0E8R-YUDFV-6AK2F-4GAN2 CRX0D-VWL0V-7CJ6C-46C7A NA8RX-QPNDU-D2LA9-4WAZL 1H4WM-N21FZ-7GK2A-44U5U 6AJ6N-THY2P-42KEF-4WTFG FK8R9-LPCDT-88H4Y-4WRN3 KAR8R-T8MAL-K8J6A-4WDXQ YJEKW-JMFF4-YA1DC-4WTQ...
Read more

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

-
Method 1 You can check the mode of the server using "pg_controldata". [pgsql@test~]$ pg_controldata /usr/local/pgsql/data84/ Database cluster state: in archive recovery --> This is Standby Database Database cluster state: in production --> This is Production Database [Master] Method 2 You can use pg_is_in_recovery() which returns True if recovery is still in progress(so the server is running in standby mode or slave) postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) If Return    false   so the server is running in primary mode or master postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row)
Read more

Oracle to Postgresql migration

-
Oracle migration: For migration first we need to install oracle database and ora2pg software and DBD oracle packages. =>first install oracle database in server and note down the paths,username,password needed For installing the oracle database follow the below steps: From the root user: create group "groupadd oinstall" create group "dba" create user "useradd oracle -G dba -g oinstall create directory "mkdir /home/oracle/software" Change ownership permissions to software directory chown oracle:oinstall /home/oracle/software copy the downloaded files to /home/oracle/software and untar the files After untaring we can find "database" directory in /home/oracle/software In database directory we find runinstaller file we need to run that file ./runinstaller and finish the oracle database installation. ======================================================================= After finishing the installation switch to oracle use...
Read more

PostgreSQL Enterprise Manager - PEM Monitoring Tools

-
Image
Database administration and management is required for any database on which there are continuous business transactions.  If databases across enterprises are not monitored and maintained, then such databases are vulnerable to disasters, which eventually brings downtime to missions-critical application and, of course, it will incur losses in the business. Data is now one of the key assets for running a business, globally. Hence, it is one of the major responsibilities of enterprises to invest in resources for database monitoring and management. There are many database management and monitoring tools available for proactive database monitoring. In this article, we will look at  PEM – “PostgreSQL Enterprise Manager” .Enterprise Manager, or PEM, is a graphical database management/monitoring tool that can help database administrators, system administrators, database developers, database managers, system architects, and performance analysts manage databases efficiently and proacti...
Read more

7 Steps to configure BDR replication in postgresql

-
Image
 The  BDR  (Bi-Directional Replication) project adds multi-master replication to PostgreSQL 9.4.  Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.   Here We are using  postgres version 9.4.12 and bdr version 1.0.2. for configuring  multi master replication . Simply Following 7 steps you can configure the multi master replication in postgresql. To download the bdr in below link. .   https://github.com/2ndQuadrant/bdr/archive/bdr-pg/REL9_4_12-1.tar.gz $ tar -xzvf REL9_4_12-1.tar.gz $ wget https://github.com/2ndQuadrant/bdr/archive/bdr-plugin/1.0.2.tar.gz $ tar -xzvf 1.0.2.tar.gz 1. To install BDR. $ cd ~/bdr-bdr-pg-REL9_4_12-1 $ ./configure --prefix=/usr/lib/postgresql/9.4 --enable-debug --with-openssl $ make -j4 -s install-world $ cd ~/bdr-bdr-plugin-1.0.2 $ PATH=/usr/lib/p...
Read more