import /export

[newbie]

Hi,

Can we take an export file from AIX and import directly into NT
given that both o/s using the same Oracle version??

[jmodic]

Yes.

[anandharaj]

Hi,
Oracle Export/Import is platform generic.

So we can Export database from one platform and ftp to other OS and then import the dump file.

[pipo]

be careful to ftp in binary mode in going from NT to Unix (or UX > NT)

[anandharaj]

Hi

And also, if you are going to import the dumpfile to Unix based system... the export dump file size greater than 2gb, you will not import directly... you need to make node...compress the dump file... and then uncompress...and import the file...

[pipo]

or simply use the filesize option of exp/imp ...

[anandharaj]

Hi Pipo

Could you please explain with example about the usage of FILESIZE option ?

Thanks in Advance.

[pipo]

let's say you have 2.5 Gb of data to export. you know that you could have problems with a file that is over 2 Gb, so you export specifying filesize=1G, exp will export in a first dump file of 1 Gb, when it's full, exp will continue in another 1 Gb file, and you'll end with a 500Mb file ...

and you can now import normally these export files, you just have to specify the filesize parameter in your imp command

for example :

exp system/manager file=exp.dmp log=exp.log full=y direct=y filesize=1G

imp system/manager file=exp.dmp full=y filesize=1G

[anandharaj]

Thank you very much Mr.PIPO,
for the valuable explanation.

I wanted to know that if we give "file=exp.dmp and filesize=1GB" as you said ,

What I understand is that , the first file "exp.dmp" will be stored with only 1GB data.

and..after that What will be the second and third filenames....?

What is the sequence of filenaming...?

I am some what confused... pls. throw some light on it.

Thanks a lot.

[pipo]

there are 2 answers. either you specify all file names on the command line, or you are prompted each time this is needed :

exp user/pwd ... file=exp1.dmp,exp2.dmp,...,expn.dmp filesize=1G

will export in exp1.dmp, then exp2.dmp, and so on ...

or you can do :

exp user/pwd ... file=exp.dmp filesize=1G

and you'll be prompted for the next file name when exp.dmp is full ...