Could you please compare and contrast exp vs expdp vs rman ...
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 ...
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/ ...
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 ...
Is it possible to import a dump file from Oracle 11.2 into Oracle 10.2.0.4 ? ...
I like to know what is the equivalent parameter for STATISTICS in datapump.many ...
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?? ...
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 ...
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 ...
I try to use data pump to export a core application schema. (10Gdb 10.2.0.4)I use 'estimate' parameter of expdp before real export, and get future dump file size will be 235GB.the only issue is that my largest file system size is 34GB, so seems like I have to usepipe to zip while exporting...the act ...
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 > ...
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 ...
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 ...
I have 11.1.0.7 database and am using expdp to export a schema. The schema is quite huge and has roughly about 4 GB of data. When i export using the following command, expdp owb_exp_v1/welcome directory=dmpdir dumpfile=owb_exp_v1.dmpi get the following error after running for around 1 hour.ORA-39126 ...
I’m about to transfer a database to a different platform using data pump. Up to now I’ve always done such jobs via full export / import without any hassle. This database however is much too big ( > 2 TB) to do it the standard way. The time of outage involved is just not acceptable.I wonder wh ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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? ...
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 ...
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 ...
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 ...
on 10g R2is there any way to know if an export dump file is generated by EXP or by EXPDP command ? ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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. ...
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. ...
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.*********************************************************** ...
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 ...
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 ...
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 ...
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 ...
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 ...
Which one is better: DECODE(exp,1,val1,val2)VSCase WHEN exp = 1then val1when exp=0then val2end ...
How can I kill an expdp job if I can not attach to it ? My job name is expdp_asdb and, when I try to attach to it with 'expdp attach=expdp_asdb', the system raises the next messages:ORA-39002: invalid operationORA-39000: bad dump file specificationORA-31640: unable to open dump file "/exportdb/exp_a ...
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 ...