Oracle People:

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 ?

Thanks,

Roger