Oracle Compare and contrast exp vs expdp vs rman backup statergies

Could you please compare and contrast exp vs expdp vs rman ...

Oracle IMPDP, EXPDP vs IMP, EXP

Oracle 10.2 on Win2k3Correct me if I'm wrong ... expdp and impdp requires a data_pump_dir. I like the whole speed thing on expdp as well as impdp versus exp&imp respectively. However, recently find it annoying because:1) we expdp (expdp.dmp) to a directory that was created, say d:\dp nightly2) w ...

Oracle Data pump export (expdp) vs. data consistency

We've searched Oracle documentation for the equivalent of the "consistent" option from the old export (exp) to the new data pump export (expdp). What we've found seemed ambiguous to us:How Data Pump Export Parameters Map to Those of the Original Export Utility (reference: http://download.oracle.com/ ...

Oracle datapump performance question: network_link vs exp/imp on same node

We are converting the characterset for a 430gb database and obviously want to do it as fast as possible. We are going from 10.2.0.2 WE8ISO8859P1 to 10.2.0.3 AL32UTF8. I have read a few documents about the various expdp and impdp parameters and am in the middle of testing right now.Theoretically, wou ...

expdp or exp from Oracle 11.2 and impdp or imp into Oracle 10.2.0.4

Is it possible to import a dump file from Oracle 11.2 into Oracle 10.2.0.4 ? ...

Oracle Datapump vs exp&imp - statitics

I like to know what is the equivalent parameter for STATISTICS in datapump.many ...

Oracle Expdp slower than exp utility

HiI am doing a simple test with a 6G database using expdp and exp and the timing is as shown below:expdp: 6 minsexp: 1 min!!!Why is it that expdp is slower than exp?? ...

Oracle Exp and Expdp

I have oracle 10G Standard - 32 bit on Windows server 2003 - 32 bit with total 6 GB of RAM.I want to take expdp or exp, everytime the instance crashes and ORA-04030 error is coming up. Below is the copy of the log generated:Mon Jul 12 20:58:56 2010Errors in file c:\oracle\product\10.1.0\admin\pctl\b ...

Oracle ORA-31655 hit when pumping (expdp) sys.aud$ table

HiOur business requirement needs to dump sys.aud$ every day and only keep 30-day info in the sys.aud$. Environment OS: AIX5.3 (64)DB: Oracle RAC 10.1.0.4I created the directory owned by sys and grabt the privilege to system-- query the available directories for the current user who runs this command ...

Oracle export scheduling problem

please say to me what methods exists for scheduling export(expdp or exp)and what is beteri have tried to use dbms_scheduler package for scheduling export but i don't succeedi even maked shell file (under linux) with below contentsh1.sh******************************************************* time > ...

Exporting Data from Oracle v11 --> Importing into Oracle v10

I just took on a new client that has installed Oracle v11 DB on their servers.I currently have Oracle v10 DB on my servers.I want to export a schema from their database and import it into mine.Obviously, since it's coming from a v11 database it won't import directly. Does anyone know if I change the ...

transfer data from sql server to oracle

Can we use oracle datapumps or exp tools in oracle to transfer data from oracle to sql server database ? Is it possible to do this through use of these tools expdp or exp in oracle. Create dump files from oracle and import them to sql server ? I do know that there are third party tools available for ...

Oracle exp vs expdp

We recently had a problem in Oracle unrelated to imp/exp or impdp/expdp. In the course of discussing the upgrade from 10.1.0.3 to 10.2.0.3, the support engineer suggested a route which involved using imp/exp. When I asked him to be specific, did he mean imp/exp or impdp/expdp, he said imp/exp.His re ...

Oracle "exp vs expdp" & "imp vs impdp"

I have to use expdp and impdp utility for database export and import purpose . I have 2 questions & also have a problem regarding these utilities . Question :In Oracle10g Envionment :1) What is main difference and advantage using 'expdp/impdp' between 'exp/imp' utility . 2) Is it possible to use ...

Oracle EXP vs EXPDP

HiPlease how do I rewrite this full export database using EXPDP?exp system/*******@database file=E:\object\BD\full_export_md.dmp log=E:\object\BD\full_md.log full=y consistent=y grants=y direct=yI'm using Oracle 10g R1 on Windows 2003 Server. ...

Oracle expdp slower than exp utility!

I need to compare the exp vs expdp utilities and get timings for the schemas in my application...I started today with one small schema which is of 1.5 gb. Using export utility it took 3 mins and 51 seconds to export it. but using expdp it takes 6 minutes and 16 seconds to do the export!! Expdp is su ...

exp and expdp command

I recently started exploring the oracle 10g database. While working on server machine I want export my database to a dump file. Now I have two options as exp and expdp command.Can anybody please tell me which command is more beneficial one to use and why? Does it having any beneficial criterion as s ...

Oracle tablespace vs transport tablespace exp

i am confuse in both caseswhat the diffrence between these twotablespace exp vs transport tablespaceacc to metablespace export is much easer then transport tablespace just as table exportbut in transport tablespace we can also copy dbf file.which one is more appropriate?kuljeet pal singh ...

Oracle Conversions between character sets when using 'exp' and 'expdp' utilities

When I make export with exp utility with NLS_LANG environmentvariable not set, export is done with US7ASCII character set,but when server uses some other character set e.g. EE8ISO8859P2,there can be some national specific characters lost with such a conversion.But when I use expdp utility and have n ...

Oracle diff b/w expdp/impdp and exp/imp

Can anyone tell me the difference between expdp/impdp and exp/imp.i have seen in some threads that expdp/impdp is used for Cross-Platform Transportable Tablespaces and also exp/imp is for Cross-Platform Transportable Tablespaces.so what is the mail difference. can u tell me the abbreviation of expdb ...

Oracle Possible cmdline parms for exp/imp.exe the same as for expdp/impdp.exe ?

Are the possible cmdline parameters the same for the (older) exp/imp as for the newer expdp/impdp commands?If not: what are the differences?Peter ...

Oracle Identify EXP/EXPDP Dump file

Is there any method for identifying the dump file generated by EXP or EXPDP without checking the log files. Can we check wheather xyz.dmp is created by EXP or EXPDP. ...

Oracle expdp/exp

Please help. I'm running Oracle 10GTrying to export a schema to a new one. I experience data errors on one of the tables, error attached below:EXP-00015: error on row 9026759 of table BULKACCOUNTACTIVITY, column PRICE_DT, datatype 12I then tried to exclude the table using a parameter file wth select ...

Oracle expdp is faster than exp

how expdp is faster than exp, what oracle internally change to speed up datapump?how impdp is faster than imp, what oracle internally change to speed up datapump? ...

Oracle Export 50K tables using exp/expdp command

I am trying to export around 52,000 tables using parfile in oracle 10g/Solaris machine. But I am not able to do that....IS there a limitation to specify for the number of tables in a parfile ??? If so, how much..I get the error "LRM-00116: syntax error at <table_name> followed by <table_nam ...

Oracle EXP doesnt work EXPDP does work in 11g

I tried exporting a table with exp in 11g and it wont export the table. I then tried exporting the table using data pump and it does export the table. Is there some situations in which exp wont return the correct obecjts in 11g? SQL> select * from v$version;BANNER Oracle Database 11g Enterprise E ...

Oracle exp works fine but expdp does not..!!!!

Well I used exp to export my database on 10g and it works absolutely fine but when I use expdp with the respective syntax i get this errorORA-39002: Invalid OperationORA-39070: Unable to open the log fileORA-29283: Invalid file operationORA-06512: at SYS.UTL_FILE line 475ORA-29283: Invalid file oper ...

Oracle exp or expdp

on 10g R2is there any way to know if an export dump file is generated by EXP or by EXPDP command ? ...

Oracle Database Migration best option exp/expdp

As a part of an EBS upgrade we need to migrate the DB in 10.2.0.4 from AIX to Linux .The target DB version would be 10.2.0.4 also.The database size is around 900 GB.I know I can use exp or expdp.I need to know as per the experience what you people say is the best approach considering the size of the ...

Oracle Compress=Y in Exp and Expdp

I have been using oracle export/import as well as datapump export/import on a regular basis in building our database environments. I noticed the difference between the normal export and the datapump export.Export(exp) has the compress=Y/N option whereas i didnt see the option in Datapump.I was looki ...

Oracle EXP and IMP vs. spool scripts

I am looking for a solution to do a full deployment of our preprod environment.Only the structure of the database is of interest.Now there are 2 ways, which I as far found.Solution 1I create n number of SQL*Plus scripts (For every object type one).Within the scripts I generate scripts, which at the ...

Oracle expdp estimate_only=y vs dba_segments

I'm calculating the schema size for the export. I have run expdp estimate_only=y. This has given the estimated size as 8G. I have also run the query under dba_segments.select sum(bytes)/1024/1024/1024 as size_gig, segment_typefrom dba_segments where owner='TEST' group by segment_type;The query has r ...

Oracle expdp 10.2: parameter file VS command line

DB 10.2.0.4client 10.2.0.3trying to export using parameter fileDIRECTORY=DATA_PUMP_DIRDUMPFILE=sh.dpdmpLOGFILE=sh.logSCHEMAS=shand getting error messageC:\Projects>c:\oracle\product\10.2.0\db\BIN\expdp hr/hr@ora10g hr.parExport: Release 10.2.0.3.0 - Production on Monday, 05 October, 2009 13:38:41 ...

Oracle rman duplicate vs. imp/exp

I try to use rman duplicate database to bring entire databse form Windows XP system to another Windows XP.I have been trying to use rmain duplicate database without success.I failed on "startup force nomount......". The system always promptme an error as "ORA-12514: TNS:listener does not currently k ...

Oracle DUMP by EXP or EXPDP

1 - how can I find out if the DMP file which I got it from somebody else, has been created using exp or EXPDB ? ( I just have a <....>.DMP ) 2- what will be the syntax for IMP or IMPDB if there are more than 1 dmp ? ( like <....1>.dmp and <....2>.dmp ) ( i mean the person who has g ...

Oracle EXP or EXPDP for a specific Schema

I know how to exp a schema using it's userid : exp scott/tiger file=emp.dmp log=emp.log But if I want to exp SCOTT using the SYS login, how would be the command? I did not found the relevant switch/parameter of the command. ...

Oracle Are exp or expdp BACKUP reliable.

In my environment database running in noarchivelog and have only export backup beause the database cannot shutdown.Is this reliable or must go for offline backup or offline RMAN backup. ...

Oracle 10g exp/imp vs 9i exp/imp

i have export dump file from oracle 10g, and i woul like to import this to oracle 9i(9.2.0.7) and i have error IMP-00010: not a valid export file, header failed verificationIMP-00000: Import terminated unsuccessfullycan someone tell me how i can work arround. ...

Problem Building .exe in VS 2005

HiI've converted a VC++6 workspace to a VS "solution" with 3 projects: EasyB, EasyBUtils, EasyBWizards. All the programs in the projects compile without errors (there are a few warnings). I am unable to link and create a .exe file.*********************************************************** ...

link probleme while conversion projet from VS 2003 to VS 2005

I am trying to migrate my project to VS 2005 ( it was developped by VS 2003).Unfortunatily , i got this warning and errors :Linking...libiso.lib(isoint1.obj) : warning LNK4224: /COMMENT is no longer supported; ignoredlibiso.lib(isoint1.obj) : warning LNK4224: /COMMENT is no longer supported; ignored ...

Problem running expdp in a cron job

I wrote a script named $PATH_TO_SCRIPT/export.sh (the file is executable by everyone using chmod a+x). For some unknown reason I'm unable to run that script in a cronjob. I can run the script on the command line. Here's what I have in the script:#!/bin/sh ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01 ...

Calling expdp as sysdba

When I try to perform an "impdp full=y", the process errors out at a point because we have max_enabled_roles set to 148. Apparently, the user account running the impdp gets these roles assigned to themselves, and after 148, everything crashes. This param cannot be increased over 148.So I w ...

Oracle expdp and large database problems

having trouble getting myself set up with an automated backup using expdp. I have a database that is larger than the remaining space on the disk, so dmp files created with exp/expdp won't fit. in 8i we used to get around this using named pipes a la...mkfifo expdat.dmpexp sys/syspass full=y file=expd ...

Oracle DECODE Vs CASE Performance Issue

The comparison is on basis of performance. There are billions of records to be processed and millions to be updated.Please go through the folowing queried to have general idea because the actual query is 2 page long.DECODE(EXP,1,VAL1,VAL2)VsCASE WHEN EXP=1THEN VAL1ELSEVAL2END Update table1set column ...

Oracle DECODE VS CASE? Which one is better

Which one is better: DECODE(exp,1,val1,val2)VSCase WHEN exp = 1then val1when exp=0then val2end ...

Oracle Unable to use expdp

Can someone help please.Using Data Pump example in "Express Two Day DBA" page 10-13.After executing the first 5 Steps, In Step 6 I substitute the correct password in the followingexpdp SYSTEM/password SCHEMAS=hr DIRECTORY=dmpdir DUMPFILE=schema.dmp LOGFILE=expschema.logSP2-0042: unknown command "exp ...

Oracle expdp on 10gR2 and impdp on 10gR1

Is it possible to expdp on oracle 10gR2 and impdp on Oracle 10gR1?If not as I guess how may I cross over this problem?May be I should use exp and imp?or expdp and impdp with particular options?I need help ...

Oracle EXPDP not export the data

is must export a schema with expdp. The following errors come:############################################################expdp tango/tango12 PARFILE=parfile.txtparfile:FILESIZE=2GBDUMPFILE=ahs_prod%U.dmpDIRECTORY=EXPSCHEMAS=TANGOLOGFILE=tango_exp.logPARALLEL=2JOB_NAME=tango_exportLogfile:;;; Export ...

Oracle who can help regarding to exp par?

I am using 8.1.7.4 oracle DB, and I need to modfy a exp par file to exclude some tables, is like the following:FULL=YDIRECT=YGRANTS=YROWS=YINDEXES=YCOMPRESS=NCONSISTENT=YEXCLUDE=TABLE:"IN('CNT_PERSON_BAD_LOGIN','CNT_PERSON_LOG')"but when I check the exp utility help, I can't find 'exlude' option, be ...

Oracle expdp setup

I have a 10.2.0 database. I am trying to setup a data pump export by using EXPDP. Here is my command and errors. It looks like the DIRECTORY setup is incorrect. How do i setup this?Thanks a lot! sky% expdp system/manager DIRECTORY=/export/db43/oradata DUMPFILE=exp.dmp tables=abc.t1Export: Release 10 ...