Hi Sreddy

[cravi]

Regarding the yesterday postage by somebody :

I've just imported a 22M attachment(as part of a table) by using an extremely large BUFFER in my import command:
imp file=cqdb.dmp.01.01.31 log=again buffer=30000000 fromuser=CQ06 tables=attachments_blob

Is there a limit to the size of the buffer ? Can you crash oracle this way ? If people keep putting in huge blobs will import just not be
able to create a big enough buffer to import them ?

Your's Reply :

Oracle will not crash for giving max buffersize. AFAIK, size is Hardware Dependent. Unfortunately, I forgot the command which is real
handy and gives me the max buffersize on the box. If some one knows it I would request 'em to post here.

For this box its 42131456
SunOS appserv7 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-4

I also need to import the entire data which is having LOB and BLOBS.If you find the command which gives the maximum buffer size on Box please let me know.My Os is windowsNT4.0 and Oracle 734.

Thanks
Ravi

[sreddy]

I`m sorry to say Iam not NT guy. So I don't know equivalent parameter that influence NT buffer size.NT experts would advise you better.

Unix(Solaris) command is:

$sysdef |grep -i buf