how to import 10gb?

Printable View

05-31-2002, 03:32 AM
aj_usa

hello all,
I have a 10gb dump export file, how do i import that?

thanks
05-31-2002, 03:43 AM
jmodic

imp un/pwd file=my_10G_file.dmp blahblah.....

You import it the same way as you would do 100K dump file, absolutely no difference (except that the time to complete import will be much longer with 10G).

Or have I musunderstood the question?
05-31-2002, 04:45 AM
amka78

Is it possible to directly take the import into a DAT. I dont have space 10GB Space on my HD then how do i do the same
05-31-2002, 04:55 AM
SANJAY_G

Quote:

Originally posted by amka78
Is it possible to directly take the import into a DAT. I dont have space 10GB Space on my HD then how do i do the same

Import into DAT ??????

Sanjay
05-31-2002, 05:12 AM
jmodic

Quote:

Originally posted by amka78
Is it possible to directly take the import into a DAT. I dont have space 10GB Space on my HD then how do i do the same

You probably mean reading the dump file directly from DAT and importing it into the database?

On unix you can do it using pipes. I don't know how would this be possible on Win platform.
05-31-2002, 05:18 AM
aj_usa

I have the compressed export dmp which is 1.5gb

now i do
Reading a compressed export file
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
% mknod /tmp/imp_pipe p # Make the pipe
% uncompress < export.dmp.Z > /tmp/imp_pipe & # Background uncompress
% imp file=/tmp/imp_pipe

i get pipe errors, thi sis on sun solaris

any suggestions?
05-31-2002, 05:29 AM
denevge

It may be necessary that you have to give an option to the uncompress command to tell it that the result must be write to stdout.

On HP-UX I have :

uncompress -c
Force compress and uncompress to write to the standard output; no files are changed. The nondestructive behavior of zcat is identical to that of uncompress -c.
or use zcat :
zcat
Restore the compressed files to original form
and send the result to standard output. If no file is specified, or if - is specified, standard input is uncompressed to the standard output.

So on HP-UX it would be

% mknod /tmp/imp_pipe p # Make the pipe
% uncompress -c < export.dmp.Z > /tmp/imp_pipe & # Background uncompress
% imp file=/tmp/imp_pipe
or
% mknod /tmp/imp_pipe p # Make the pipe
% zcat export.dmp.Z > /tmp/imp_pipe & # Background uncompress
% imp file=/tmp/imp_pipe

Hope this helps
Gert