What is the difference between Datapump & export/import?
Answer Posted / kittu_chintu2005
Export/Import: traditional backup of oracle database, we can't resume the export/import job if we stop the job in middle. We can't attach any job to running job @ exp/imp. We need not to create a file structure @ oracle level
Datapump: It's introduced from 10g. We can resume the datapump job if we stop the job in middle. We can attach a datapump job to running job. We need create file structure @ oracle level and OS level.
Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Can you redefine a table online?
What is a system database and what is a user database? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What happens on checkpoint? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Explain materialized views and how they are used.
how can you get actual data change values from previous transactions in oracle?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How do you open a cluster administrator? : sql server DBA