Forgot your password?    
+ Reply to Thread
Results 1 to 10 of 10

Thread: Oracle apps dba interview questions

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120

    Oracle apps dba interview questions

    These are some interview question I remember. There were many other questions, But these questions which I was able recall and am posting here. Apps people should give answers to these questions.

    1. Where is the client server located?
    2. What is the configuration of servers?
    3. How you manage the servers?
    4. Which storage devices are used?
    5. What priveledges are assigned to you?
    6. How many Apps Instances and Databases Instances are running?
    7. What are sizes of the database?
    8. What are the sizes of sga of the database?
    9. Name some of the tablespaces of the Apps Instances?
    10. How you do patching?
    11. Name some of the patch numbers you had applied?
    12. What are your responsibility all the day as Apps dba?
    13. Which ticketing system you use and what are the process?
    14. Do you recieve any calls from the client, if yes, What is the profile of the person who call you?
    15. What kind of calls you recieve from the client?
    16. How you monitor your Apps as well as Database instance?
    17. How you do sql tuning?
    18. What are your backup strategies?
    19. How you do your backup?
    20. Had you faced any recovery scenario, if yes explain it?
    21. How you do cloning, define the steps?
    22. Why Hot backup cloning is preferable than Cold backup Cloning?
    23. If database is not running in archive log mode, which cloning method you will use?
    24. Have you any idea of physical standby, if yes define the steps to create the physical standby database?
    25. Had you created thy logical standby database for Apps Instance database, if yes than define the steps?
    26. How many physical standby database for Apps instance your client is maintaining?
    27. Had you ever simulated the switch over or failover of the production database, if yes what kind of challenges you had faced?
    28. If not than how you are assure that physical standby database siwtch over or failover will work?
    29. What is a concurrent processing server?
    30. How many concurrent processess runs in you environment?
    31. Do you ever need to purge the concurrent processess, if Yes than how many processess you purge daily and how you purge?

  2. #2
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    17
    Thank you sir.

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Good for beginners...
    Regards,
    -Amit

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120

    Some interpersonal skills interview questions

    1. Tell us about yourself/ your background.
    2. What are the three major characteristics that you bring to the job market?
    3. What motivates you to do a good job?
    4. What two or three things are most important to you at work?
    5. What qualities do you think are essential to be successful in this kind of work?
    6. What courses did you attend? What job certifications do you hold?
    7. What subjects/courses did you excel in? Why?
    8. What subjects/courses gave you trouble? Why?
    9. How does your previous work experience prepare you for this position?
    10. How do you define 'success'?
    11. What has been your most significant accomplishment to date?
    12. Describe a challenge you encountered and how you dealt with it.
    13. Describe a failure and how you dealt with it.
    14. Describe the 'ideal' job... the 'ideal' supervisor.
    15. What leadership roles have you held?
    16. What prejudices do you hold?
    17. What do you like to do in your spare time?
    18. What are your career goals (a) 3 years from now; (b) 10 years from now?
    19. How does this position match your career goals?
    20. What have you done in the past year to improve yourself?
    21. In what areas do you feel you need further education and training to be successful?
    22. What do you know about our company?
    23. Why do you want to work for this company. Why should we hire you?
    24. Where do you see yourself fitting in to this organization ...initially? ...in 5 years?
    25. Why are you looking for a new job?
    26. How do you feel about re-locating?
    27. Are you willing to travel?
    28. What are your salary requirements?
    29. When would you be available to start if you were selected?

  5. #5
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120

    Some More Apps Interview Question

    Q. What is wdbsvr.app file used for? What's full path of this file? What's significance of this file ?
    Q. Whats US directory in $AD_TOP or under various product TOP's .
    Q. Whats main concurrent Manager types.
    Q. Where is Concurrent Manager log file location.
    Q. Where would i find .rf9 file, and what execatly it dose ?
    Q. Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why its used ?
    Q. Explain Architecture of Oracle Apps 11i.
    Q. What are various components in Application/Middle Tier.
    Q. What is APPL_TOP, COMN_TOP, ORA_TOP.....
    Q. What are issues you encountered during Oracle Applications 11i?
    Q. What's difference between TWO user & single User Apps 11i Install ? What are advantages/disadvantages of two ?
    Q. Whats US directory in $AD_TOP or under various product TOP's .
    Q. What is multi node system ?
    Q. Can you clone from multi node system to single node system & vice versa ?
    Q. Does rapid clone takes care of Updating Global oraInventory or you have to register manually in Global OraInventory after clone ?
    Q. What is .dbc file , where its stored , whats use of .dbc file ?
    Q. Whats things you do to reduce patch timing ? You can take advantage of following -
    Q. Can you apply patch without putting Applications 11i in Maintenance mode ?
    Q. What are various options available with adpatch ?
    Q. adident utility is used for what ?
    Q. What is adsplice utility ?
    Q. How can you licence a product after installation ?
    Q. What is MRC ? What you do as Apps DBA for MRC ?
    Q. Whats is JVM(Java Virtual Machine) and which component uses JVM ?
    JVM stands for Java Virtual Machine.
    Q. What is access_log in apache , what entries are recored in access_log ? Where is default location of this file ?
    Q. Where is Jserv configuration files stored ?
    Q. What is session time out parameter & where all you define these values ?
    Q. Where is applications start/stop scripts stored ?
    Q. What are main configuration files in Web Server (Apache) ?
    Q. What is APPS listener ? Why its used ?
    Q. How do you start/stop apps listener ?
    Q. If users complaining Oracle Applications 11i system is running slow , what all things you will check at broad level ?
    Q. What is Autoconfig ?
    Q. What is context file ?
    Q. Why appsutil directory under Database ORACLE_HOME used for ?
    Q. How to create User in Oracle Applications 11i ? Can you delete a User ?
    Q. What is Single Sign On ? ( If you are using portal 3.0.9 or 10G )?
    Q. How to configure portal with 11i ? ( If you are using portal 3.0.9 or 10G )?
    Q. How to check if Apps 11i System is Autoconfig enabled ?
    Q. How to check if Oracle Apps 11i System is Rapid Clone enabled ?
    Q. Whats is difference between two env files in <CONTEXT>.env and APPS<CONTEXT>.env under $APPL_TOP ?
    Q. What is your Oracle Apps 11i Webserver Version and how to find it ?
    Q. What is Location of Jserv configuration files ?
    Q. What is plssql/database cache ?
    Q. Where is database/plssql cache stored ?
    Q. How to determine Oracle Apps 11i Version ?
    Q. What is *.dbc file & whats is location of dbc file ?
    Q. What is Location of Jserv configuration files ?
    Q. Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ?
    Q. Output & Logfiles for requests executed on source Instance not working on cloned Instance
    Q. How to confirm if Report Server is Up & Running ?
    Q. What is use of Apps listener ?
    Q. How to start Apps listener ?
    Q. How to confirm if Apps Listener is Up & Running ?
    Q. What is Web Listener ?
    Q. How will you find Invalid Objects in database ?
    Q. How to compile Invalid Objects in database ?
    Q. How to compile JSP in Oracle Apps ?
    Q. What is difference between adpatch & opatch ?
    Q. Can you use both adpatch & opatch in Apps ?
    Q. Where will you find forms configuration details apart from xml file ?
    Q. What is forms server executable Name ?
    Q. What are different modes of forms in which you can start Forms Server and which one is default ?
    Q. How you will start Discoverer in Oracle Apps 11i ?
    Q. How many ORACLE HOME are Oracle Apps and whats significance of each ?
    Q. Where is HTML Cache stored in Oracle Apps Server ?
    Q. What happens if you don't give cache size while defining Concurrent Manager ?
    Q. What are few profile options which you update after cloning ?
    Q. How to retrieve SYSADMIN password ?
    Q. If you have done two node Installation, First machine : Database and concurrent processing server. 2nd machine: form,web Which machine have admin server/node?
    Q. Whats is TWO_TASK in Oracle Database ?
    Q. What is GWYUID ?
    Q. Where GWYUID defined & what is its used in Oracle Applications ?
    Q. What is difference between GUEST_USER_PWD (GUEST/ORACLE) & GWYUID ?
    Q. How to check number of forms users at any time ?
    Q. What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?
    Q. In a Multi Node Installation, How will you find which node is running what SErvices ?
    Q. If your system has more than one Jinitiator, how will the system know, which one to pick. ?
    Q. While applying Apps patch using adpatch, if you want to hide the apps password, how will that be possible ?
    Q. What is importance of IMAP Server in Java Notification Mailer ?
    Q. What is difference between Socket & Servlet Mode in Apps Forms ?
    Q. How to find OUI version ?
    Q. What is make program in Unix ?
    Q. If by mistake you/someone deleted FNDLIBR can this executable be restored if Yes, How & if no, what will you do ?
    Q. What is .pls files which you see with apps ?
    Q. What are .ldt & .lct files which you see in apps patch or with FNDLOAD ?
    Q. What are .odf file in apps patch ?
    Q. What to find Form Server log files in forms ?
    Q. How to convert pll to pld file or pld file to pll ?
    Q. What are .odf file in apps patch ?
    Q. What to find Form Server log files in forms ?
    Q. Is APPS_MRC Schema exists for MRC in 11.5.10 and higher ?
    Q. If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?
    Q. When you apply C driver patch does it require database to be Up & Why ?
    Q. Can C driver in apps patch create Invalid Object in database ?
    Q. What is dev60cgi & f60cgi ?
    Q. Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ?
    Q. What is difference between mod_osso & mod_ose in Oracle HTTP Server ?
    Q. What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms ?
    Q. What is ps -ef or ps command in Unix ? for work ex < 1 yr
    Q. What is GSM in Oracle application E-Business Suite ?
    Q. What is FNDSM ?
    Q. What is iAS Patch ?
    Q. If we run autoconfig which files will get effected ?
    Q. What is difference between .xml file & AutoConfig ?
    Q. What is .lgi files ?
    Q. How will you skip worker during patch ?
    Q. Which two tables created at start of Apps Patch & drops at end of Patch ?
    Q. How to compile an Oracle Reports file ?
    Q. What is difference between AD_BUGS & AD_APPLID_PATCHES ?
    Q. What exactly happens when you put an Oracle Apps instance in maintenance mode ?

  6. #6
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    Thanks masood sir!!!

  7. #7
    Oracle DBA
    Join Date
    Oct 2011
    Location
    Noida
    Posts
    4
    great job masood sir
    Last edited by Sandeep Sharma; 01-03-2012 at 08:52 PM.

  8. #8
    Oracle DBA
    Join Date
    Mar 2013
    Location
    [India]->[Kuwait]->[India]
    Posts
    11
    Thank you !!!!
    all of the contributor... it is my personnel request to, please give the answer with the question, it would be better for us....

  9. #9
    Oracle DBA
    Join Date
    Mar 2013
    Location
    [India]->[Kuwait]->[India]
    Posts
    11
    Question) What is .dbc file , where its stored , whats use of .dbc file ?
    Answer).
    .dbc file mostly used to define the Database parameter, stands for database connect descriptor file, it authenticates user against the database table FND_USER.

    Let us check how it works

    The .dbc file is actually the database connector descriptor file used to connect to database and this file is by-default located in $FND_TOP/secure directory, this file is quite important as whenever any program likes to connect to database like forms it uses dbc file where there you find the Guest_user_pwd ,when the guest user connect it does not allow it to directly connect to the database but it first connect goes via this file and cross verify the password of the guest which is kept in this file.
    DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses dbc file.

    Typical entry in dbc file are:
    GUEST_USER_PWDAPPS_JDBC_URLDB_HOST

    The dbc file is used to set up the connectivity for a given database. Each vendor requires different values to determine the server name, database name, user and password, plus any native options including special instructions for the vendor's client API or utility loader.When you drag an Output Table/Input Table etc. onto the canvas, the DBC file lets the component know where to direct the activity. The DBC file is also the mechanism through which a given table can be accessed and its column definition pulled automatically into the given component's DML definition.


    There will be lot of dbc file under $FND_SECURE, how we determine which dbc file to use from $FND_SECURE ?


    This value is determined from profile option "Applications Database ID"
    Authenication:-

    In order to authenticate your user against database in FND_USER table this request is passed from core Apache Module to mod_pls ( plsql) and it uses few files like wdbsvr.app in Apache/modplsql/conf $CONTEXT_NAME.dbc , tnsnames.ora in 806/network/admin/$CONTEXT_NAME , GUEST user & few other file so focus on these files & directories & see what changed recently.

    .dbc file in R12 -->the dbc file in R12 is in the new $INSTANCE_TOP

    $INST_TOP/appl/fnd/12.0.0/secure or $INSTANCE_TOP/apps/
    /appl/fnd/12.0.o/secure.

    Last but not the least .cfg is a unix-level file that is fed into a Korn Shell script as an auto-parameter feeder for a parameter-driven shell script. Cfg files are unix-defined where dbc files are AbI-defined.

    A Database Connection (DBC) file holds information used by application servers to identify and authenticate with an application database. DBC files must be created on all tiers if it is a multi-tier system.

    To recreate DBC file Login to your system as the APPLMGR, ensure that your environment is set correctly by running
    /.env.
    Run common_top/admin/install/adgendbc.sh (UNIX)
    This will create the DBC file for the current environment instance. Verify log file to check environment, which should be pointing to 806.Location of file is in
    /admin/install/adgendbc.txt.

    DBC file Parameters

    Verify dbc file exists and is in the right location. $FND_TOP/secure//
    _.dbc. Verify db_host using %uname -aVerify db_sid from v$instance or echo $ORACLE_SID.

    Parameters:
    APPL_SERVER_ID APPS_JDBC_DRIVER_TYPE=THIN DB_PORT <> DB_HOST
    GWYUIDFNDNAM <> TWO_TASK GUEST_USER_PWD. this is application account and should exists in applications with out any responsibility.
    Note:Make sure environment value specified for DB_HOST is db host not application host.
    Optional parameters:

    FND_MAX_JDBC_CONNECTIONS
    Maximum number of open connections in the JDBC connection cache. This number is dependent on the amount of memory available, the number of processes specified in the init.ora file of the database.

    FND_IN_USE_CONNECTION_TIMEOUT
    Maximum number of seconds a connection can be in use. In order to avoid connections being locked up for too long, the connection cache uses this parameter to forcibly close connections that have been locked for over this time. If this parameter is unspecified,connections in use will not be cleaned up. This should be set to a number larger than the time taken to complete the largest transaction.It is difficult to estimate and recommendation is not to use this.

    FND_UNUSED_CONNECTION_TIMEOUT
    Maximum number of seconds an unused connection can remain in the cache. The connection cache will close and remove from the cache any connection that has been idle for longer than this specified limit.
    Checking DBC file entries: Check Encrypted String for APPL_SERVER_ID parameter in the DBC file with entry in db using following sql stmt.These should be same.
    Log in as apps/


    Select server_id,server_address from FND_APPLICATION_SERVERS;

    The output server_id should match APPL_SERVER_ID and server_address should match IPADDRESS of db host.

    %nslookup
    Address: xxx.xx.xxx.xx Name: Address:
    verify hostname above with db_host parameter in dbc file.

    Checking db connectivity using DBC file :
    ------------------------------------------


    syntax:

    jre -v oracle.apps.fnd.security.AdminAppServer apps/

    STATUS dbc=

    Output :

    Database Server
    ---------------
    DATABASE_ID: *********
    AUTHENTICATION: OFF

    Application Server
    ------------------
    APPL_SERVER_STATUS: VALID
    APPL_SERVER_ID: 2CF3A427AB3AE01EE0439C143428E01E247391908730606095 92242102215611


    Status return's APPL_SERVER_ID and other db related info. This verifies DBC setup.

  10. #10
    Oracle DBA
    Join Date
    Mar 2013
    Location
    [India]->[Kuwait]->[India]
    Posts
    11
    Question with Answer related to Export and Import Database utility

    1. What is the Import/ Export Utility ?

    Export (exp), Import (imp) are Oracle utilities which allow you to write data in an ORACLE-binary format from the database into operating system files and to read data back from those operating system files.


    2. Which are the Import/ Export modes ?

    a) Full export/export
    The EXP_FULL_DATABASE & IMP_FULL_DATABASE, respectively, are needed to perform a full export. Use the full export parameter for a full export.

    b) Tablespace
    Use the tablespaces export parameter for a tablespace export.


    c) User
    This mode can be used to export and import all objects that belong to a user. Use the owner export parameter and the fromuser import parameter for a user (owner) export-import.


    d) Table
    Specific tables (or partitions) can be exported/imported with table export mode. Use the tables export parameter for a table export/ import mode.



    3. Is it possible to exp/ imp to multiple files ?

    Yes, is possible. Here is an example:
    exp SCOTT/TIGER FILE=C:\backup\File1.dmp,C:\backup\File2.dmp LOG=C:\backup\scott.log


    4. How we can use exp/ imp when we have 2 different Oracle database versions?
    • exp must be of the lower version
    • imp must match thetarget version

    5. What I have to do before importing database objects ?

    Before importing database objects, we have to drop or truncate the objects, if not, the data will be added to the objects. If the sequences are not dropped, the sequences will generate inconsistent values. If there are any constraints on the target table, the constraints should be disabled during the import andenabled after import.



    6. Is it possible to import a table in a different tablespace ?

    By default, NO. Because is no tablespace parameter for the import operation.
    However this could be done in the following manner:
    • (re)create the table in another tablespace (the table will be empty)
    • import the table using INDEXFILE parameter (the import is not done, but a file which contains the indexes creation is generated)
    • modify this script to create the indexes in the tablespace we want
    • import the table using IGNORE=y option (because the table exists)
    • recreate the indexes
    Here is an example of INDEXFILE:



    7. In which cases imp/exp is used ?
    • Eliminate database fragmentation
    • Schema refresh (move the schema from one database to another)
    • Detect database corruption. Ensure that all the data can be read (if the data can be read that means there is no block corruption)
    • Transporting tablespaces between databases
    • Backup database objects

    8. How we can improve the EXP performance ?
    • Set the BUFFER parameter to a high value (e.g. 2M)
    • If you run multiple export sessions, ensure they write to different physical disks.

    9. How we can improve the IMP performance ?
    • Import the table using INDEXFILE parameter (the import is not done, but a file which contains the indexes creation is generated), import the data and recreate the indexes
    • Store the dump file to be imported on a separate physical disk from the oracle data files
    • If there are any constraints on the target table, the constraints should be disabled during the import and enabled after import
    • Set the BUFFER parameter to a high value (ex. BUFFER=30000000 (~30MB) ) and COMMIT =y or set COMMIT=n (is the default behavior: import commits after each table is loaded, however, this use a lot of the rollback segments or undo space for huge tables.)
    • use the direct path to import the data (DIRECT=y)
    • (if possible) Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) considerably in the init<SID>.ora file
    • (if possible) Set the LOG_BUFFER to a big value and restart oracle.

    10. Which are the EXP options ?

    EXP Option Default value Description
    buffer Specifies the size, in bytes, of the buffer (array) used to insert the data
    compress N When “Y”, export will mark the table to be loaded as one extent for the import utility. If “N”, the current storage options defined for the table will be used. Although this option is only implemented on import, it can only be specified on export.
    consistent N Specifies the set transaction read only statement for export, ensuring data consistency. This option should be set to “Y” if activity is anticipated while the exp command is executing. If ‘Y’ is set, confirm that there is sufficient undo segment space to avoid the export session getting the ORA-1555 Snapshot too old error.
    constraints Y Specifies whether table constraints should be exported with table data.
    direct N Determines whether to use direct or conventional path export. Direct path exports bypass the SQL command, thereby enhancing performance.
    feedback 0 Determines how often feedback is displayed. A value of feedback=n displays a dot for every n rows processed. The display shows all tables exported not individual ones.
    file The name of the export file. Multiple files can be listed, separated by commas. When export fills thefilesize, it will begin writing to the next file in the list.
    filesize The maximum file size, specified in bytes.
    flashback_scn The system change number (SCN) that export uses to enable flashback.
    flashback_time Export will discover the SCN that is closest to the specified time. This SCN is used to enable flashback.
    full The entire database is exported.
    grants Y Specifies object grants to export.
    help Shows command line options for export.
    indexes Y Determines whether index definitions are exported. The index data is never exported.
    log The filename used by export to write messages.
    object_consistent N Specifies whether export uses SET TRANSACTION READ ONLY to ensure that the data being exported is consistent.
    owner Only the owner’s objects will be exported.
    parfile The name of the file that contains the export parameter options. This file can be used instead of specifying all the options on the command line for each export.
    query Allows a subset of rows from a table to be exported, based on a SQL where clause.
    recordlength Specifies the length of the file record in bytes. This parameter affects the amount of data that accumulates before it is written to disk. If not specified, this parameter defaults to the value specific to that platform. The highest value is 64KB.
    resumable N Enables and disables resumable space allocation. When “Y”, the parameters resumable_name andresumable_timeout are utilized.
    resumable_name User defined string that helps identify a resumable statement that has been suspended. This parameter is ignored unless resumable = Y.
    resumable_timeout 2h The time period in which an export error must be fixed. This parameter is ignored unless resumable = Y.
    rows Y Indicates whether or not the table rows should be exported.
    statistics ESTIMATE Indicates the level of statistics generated when the data is imported. Other options include COMPUTE and NONE.
    tables Indicates that the type of export is table-mode and lists the tables to be exported. Table partitions and sub partitions can also be specified.
    tablespaces Indicates that the type of export is tablespace-mode, in which all tables assigned to the listed tablespaces will be exported. This option requires the EXP_FULL_DATABASE role.
    transport_tablespace N Enables the export of metadata needed for transportable tablespaces.
    triggers Y Indicates whether triggers defined on export tables will also be exported.
    tts_full_check FALSE When TRUE, export will verify that when creating a transportable tablespace, a consistent set of objects is exported.
    userid Specifies the userid/password of the user performing the export.
    volsize Specifies the maximum number of bytes in an export file on each tape volume.

    Example: exp system/s file=C:\emp.dmp tables=scott.emp log=C:\emp.log (Windows)
    or exp userid=system/s file=C:\emp.dmp tables=scott.emp log=C:\emp.log (Windows)
    USERID must be the first parameter on the command line.


    11. Which are the IMP options ?

    IMP Option
    Default value
    Description
    buffer Specifies the size, in bytes, of the buffer (array) used to insert the data
    commit N Specifies whether import should commit after each array insert. By default, import commits after each table is loaded, however, this use a lot of the rollback segments or undo space for huge tables.
    compile Y Tells import to compile procedural objects when they are imported.
    constraints Y Specifies whether table constraints should also be imported with table data.
    datafiles
    (only with transport_tablespace)
    This parameter lists data files to be transported to the database.
    destroy N Overwrite tablespace data file
    feedback 0 Determines how often feedback is displayed. A value of feedback=100 displays a dot for every 100 rows processed. This option applies to the total tables imported, not individual ones. Another way to measure the number of rows that have been processed is to execute the following query while the import is active:
    SELECT rows_processed
    FROM v$sqlarea
    WHERE sql_text like'INSERT %INTO "%'
    AND command_type =2
    AND open_versions >0;
    file The name of the export file to import. Multiple files can be listed, separated by commas. When export reaches the filesize it will begin writing to the next file in the list.
    filesize Maximum size of each dump file
    fromuser A comma delimited list of schemas from which to import. If the export file contains many users or even the entire database, the fromuser option enables only a subset of those objects (and data) to be imported.
    full The entire export file is imported.
    grants Y Specifies to import object grants.
    help Shows command line options for importimp -help or imp help=y
    ignore N Specifies how object creation errors should be handled. If a table already exists and ignore=y, then the rows are imported to the existing tables, otherwise errors will be reported and no rows are loaded into the table.
    indexes Y Determines whether indexes are imported.
    indexfile Specifies a filename that contains index creation statements. This file can be used to build the indexes after the import has completed.
    log The filename used by import to write messages.
    parfile The name of the file that contains the import parameter options. This file can be used instead of specifying all the options on the command line.
    recordlength Specifies the length of the file record in bytes. This parameter is only used when transferring export files between operating systems that use different default values.
    resumable N When “Y”, the parameters resumable_name and resumable_timeout are utilized.
    resumable_name User defined string that helps identify a resumable statement that has been suspended. This parameter is ignored unless resumable = Y.
    resumable_timeout 2h The time period in which an error must be fixed. This parameter is ignored unless resumable=Y.
    rows Y Indicates whether or not the table rows should be imported.
    show N When show=y, the DDL within the export file is displayed.
    skip_unusable_indexes N Determines whether import skips the building of indexes that are in an unusable state.
    statistics ALWAYS Determines the level of optimizer statistics that are generated on import. The options include ALWAYS, NONE, SAFE and RECALCULATE. ALWAYS imports statistics regardless of their validity. NONE does not import or recalculate any optimizer statistics. SAFE will import the statistics if they appear to be valid, otherwise they will be recomputed after import. RECALCULATE always generates new statistics after import.
    streams_configuration Y Determines whether or not any streams metadata present in the export file will be imported.
    streams_instantiation N Specifies whether or not to import streams instantiation metadata present in the export file
    tables Indicates that the type of export is table-mode and lists the tables to be exported. Table partitions and sub partitions can also be specified.
    tablespaces When transport_tablespace=y, this parameter provides a list of tablespaces.
    to_user Specifies a list of user schemas that will be targets for imports.
    transport_tablespace N When Y, transportable tablespace metadata will be imported from the export file.
    tts_owners When transport_tablespace=Y, this parameter lists the users who own the data in the transportable tablespace set.
    userid Specifies the userid/password of the user performing the import.

    Example: imp system/manager file=/APPS/x.dmp tables=x fromuser=cs touser=cs (Unix)
    or imp userid=system/manager file=/APPS/x.dmp tables=x fromuser=cs touser=cs (Unix)
    Note: USERID must be the first parameter on the command line.


    12. Which are the common IMP/EXP problems?
    • ORA-00001: Unique constraint ... violated - Perhaps you are importing duplicate rows. Use IGNORE=N to skip tables that already exist (imp will give an error if the object is re-created) or the table could be dropped/ truncated and re-imported if we need to do a table refresh..
    • IMP-00015: Statement failed ... object already exists... - Use the IGNORE=Y import parameter to ignore these errors, but be careful as you might end up with duplicate rows.
    • ORA-01555: Snapshot too old - Ask your users to STOP working while you are exporting or use parameter CONSISTENT=NO (However this option could create possible referential problems, because the tables are not exported from one snapshot in time).
    • ORA-01562: Failed to extend rollback segment - Create bigger rollback segments or set parameter COMMIT=Y (with an appropriate BUFFER parameter ) while importing.

+ Reply to Thread

Similar Threads

  1. Oracle DBA Interview Questions
    By Hemant in forum Oracle Database Interview Questions
    Replies: 1
    Last Post: 06-06-2012, 04:01 PM
  2. Oracle Apps DBA Interview questions
    By devesh_ocp in forum Oracle Applications Interview Questions
    Replies: 0
    Last Post: 04-26-2012, 11:51 AM
  3. Oracle Apps DBA Interview Questions 2
    By Hemant in forum Oracle Applications Interview Questions
    Replies: 12
    Last Post: 03-08-2012, 10:12 PM
  4. Oracle Interview Questions (Contains DBA and Developer Questions)
    By Pradeep in forum Oracle Database Interview Questions
    Replies: 0
    Last Post: 02-29-2012, 05:13 AM
  5. Here are some possible Oracle DBA Interview Questions:
    By Akhil Kumar in forum Oracle Database Interview Questions
    Replies: 0
    Last Post: 02-12-2012, 04:47 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics