Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: importing a split oracle dump into windows environment

Re: importing a split oracle dump into windows environment

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Fri, 1 Dec 2006 11:38:14 +0100
Message-ID: <457005be$0$49204$14726298@news.sunsite.dk>

<ganeshkeer_at_googlemail.com> wrote in message news:1164968124.047278.305790_at_j44g2000cwa.googlegroups.com...
> Hello,
>
> I am having a exported dump of oracle database in split files using
> unix. I want to import them to another oracle database on windows
> machine. But I want to unsplit the files and then import it as single
> file.
>
> Can we unsplit the files using windows??? and make one file again which
> was split by unix???

With "type":

type part1 part2 ... partn (or "*") > file (or file.gz, if the file is compressed).

For example:

>dir x*

30/11/2006  08.59         1.048.576 xaa.dat
30/11/2006  09.01         1.048.576 xab.dat
30/11/2006  09.03         1.048.576 xac.dat
30/11/2006  09.04         1.048.576 xad.dat
30/11/2006  09.02         1.048.576 xae.dat
30/11/2006  09.06         1.048.576 xaf.dat
30/11/2006  09.07         1.048.576 xag.dat
30/11/2006  09.08         1.048.576 xah.dat
30/11/2006  09.08           218.766 xai.dat
               9 File(s)      8.607.374 bytes
               0 Dir(s)  24.097.529.856 bytes free

>type x* > dmp.gz
>gzip -tv dmp.gz

dmp.gz: OK

Regards
Dimitre Received on Fri Dec 01 2006 - 04:38:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US