Simultaneous Export and Import

Advertisement
Hi,
I would like to know a way wherein I can kick off the export and then simultaneously read the export dmp file and start importing.
I am using source database 9.2.0.4 Solaris and
target databse 9.2.0.8 64bit Linux 4AS X86_64.
I tried using pipe for export and started export.
Same time, I used another pipe to read from that file and import it in another database.
Problem is since new database is on a faster server, import reaches the end of file much faster than the export. And gives an error,
"IMP-00009: abnormal end of export file
Import terminated successfully with warnings."
Can anybody guide me on how can I make the pipe wait and make it understand that export is not yet over?
Thanks in advance
regards
Makarand
Advertisement

Replay

What's the command and parameter you used?
You could try
##create the two pipe
mknod exp_pipe p
mknod imp_pipe p
##start import
imp system/[email protected] file=imp_pipe log=imp_pipe.log ...
##start export
exp userid=scott/tiger file=exp_pipe ..
##connect the pipe
cat <exp_pipe | cat >imp_pipe

Export and import of an table data

Hi All, I have a situation where i need to append/import  the production table ( X )  data to test table ( X ) which has some data already in it and should not be lost  during the operation. The record count is around 6 million . Any expert suggestio

Exporting and Importing Destination Controls Error

When I export table within destination control and import the table to another Ironport again within destination control I receive error - "Wrong format of the destination config file: ip_sort_pref is required for the global settings." We are up

WSUS - Server 2012 R2 - Export and Import

Greetings, I have a Server 2012 R2 system with the WSUS role installed.  This server resides on a disconnected network so we must bring updates from an online WSUS server.  I have experience performing successful exports and imports in the past with

Export and import of 3 Gb table

Dear , I have table with more than 3 million records, i need to export this table and import into a different database . can you please help me with the export and import options options so that i can speed up the process... for you information this

How I can Export and Import tables using BRTOOL ?

Dear All, Since we upgrade the oracle from 9.0.2 to 10.2.2 we not using SAPDBA any more. please help me if you now how to export and import tables in sapr3 using brtools? thanks and Best regards, ChrisnaDear Chrisna, first of all you should get the r

Export and Import of mappings/process flows etc

Hi, We have a single repository with multiple projects for DEV/UAT and PROD of the same logical project. This is a nightmare for controlling releases to PROD and in fact we have a corrupt repository as a result I suspect. I plan to split the reposito

Data Export and Import

Hello, I need a suggestion. I have two databases namely DB1 and DB2 and they are on different servers S1 and S2 respectively. What could be my approach to move data from DB1 to DB2. 1:-Do i need a database link to do this. 2:-Can i do this without DB

Possible to convert Raw to JPEG without exporting and importing?

I have about 4,500 raw photos that I need to print on contact sheets (or print contact sheets to a PDF). I took the photos all in Raw format. Aperture, or my computer, is not powerful enough to process all of these photos onto contact sheets from the

Steps to export and import oracle 10g databse from AIX to AIX and LINUX

Hi, I need the steps to export the oracle 10g database from AIX server to AIX server and LINUX server. Please give me all the steps as this is my first exort an import activity. thanks,For 10g there exist two ways to do so. 1) Regular exp/imp. 2) Dat

Export and import XMLType table

Hi , I want to export one table which contain xmltype column form oracle 11.2.0.1.0 and import into 11.2.0.2.0 version. I got following errors when i export the table , when i tried with exp and imp utility EXP-00107: Feature (BINARY XML) of column Z

Require help in understanding exporting and importing statistics.

Hi all, I am bit new to this statistics. Can anyone please explain me in detail about these commands. 1) exec DBMS_STATS.GATHER_TABLE_STATS (ownname => 'MRP' , tabname => 'MRP_ATP_DETAILS_TEMP', estimate_percent => 100 ,cascade => TRUE); 2) ex

XML Export and Import

Hi      I knew that BW  metadata can be trasformed using XML Using export and Imoport but how to make selection of set of  BW objects through metadata export and import in XML format.      For example i would like to export some 10 infoobjects to the

Query on Database Export and Import

Hi Techies, Currently we are running our Database on Oracle 10g and SAP on4. and OS is HP UX 11.11. We have a plan to migrate our HW from PA-RISC to Itanium and at the time of Production migration we are planning to use Export and Import method to ge

Scripting Oracle export and import dumps

Hello, I would like to know if it is possible to script oracle export and import dump commands in a PL/SQL package rather than at command prompt. Also, how can i copy the export dump files across the network to a specific location. I would really app

How export and Import ADF-BC

Hi all, How i do to export and import ADF-BC, of one project to other ? Thank's AlexandreHi, may be this thread helps: Linking two projects TimoRead other 2 answers

Export and Import of Schemas (PY and TM)

Hi All, Is there a way to Export and Import Schemas (PY and TM)? Do exist a report standard, or custom , to do it? Or if somebody knows all the tables behind a schema. Because we have tried to load some tables but when we see the schema some descript

Export and import the windows phone contacts as .vcf file to the application

Hi, I need to export the windows phone contacts as .vcf file and import it to my windows phone application. I'm unable to import the full details of a contact. Is there any sample code to export and import phone contacts programmatically. Please help

Exporting and Importing OIM Groups

Hi I am trying to export and import OIM Groups from one environment to another. It looks like some of the details of the groups (such as Administrative Groups details) are missing after the import. Any ideas? I will assign Points. Thanks Regards Vija

How to export and import from AIX to solaris a whole schema with different

how to export and import from AIX to solaris a whole schema with different character set import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses WE8ISO8859P1 character set (possible charset conversion) Import termin