Export Buffer size [message #324671] |
Tue, 03 June 2008 11:08 |
thorin666
Messages: 144 Registered: March 2007
|
Senior Member |
|
|
i am about export a table and i wanna know if this size is good for do it
SQL> desc USR_SIST_NEGOCIO.HIS_PAD_VOU_DETALLE
Name Type
----------------------------
HVD_NUMERO_VOUCHER NUMBER(10)
HVD_SEG1 VARCHAR2(8)
HVD_SEG2 VARCHAR2(2)
HVD_SEG3 VARCHAR2(5)
HVD_SEG4 VARCHAR2(4)
HVD_SEG5 VARCHAR2(5)
HVD_SEG6 VARCHAR2(8)
HVD_SEG7 VARCHAR2(2)
HVD_SEG8 VARCHAR2(2)
HVD_MONTO_DEBE NUMBER(20,8)
HVD_MONTO_HABER NUMBER(20,8)
HVD_PERIODO DATE
It has aprox 13kk of rows
can the buffer size be 1.6G?
i followed this formula to calculate the buffer size
http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005586
|
|
|
|
Re: Export Buffer size [message #324674 is a reply to message #324672] |
Tue, 03 June 2008 11:22 |
thorin666
Messages: 144 Registered: March 2007
|
Senior Member |
|
|
Michel Cadot wrote on Tue, 03 June 2008 11:16 | If you have the memory enough.
Regards
Michel
|
Michael, i think i have this memory
but if i dont have it... what do you think i must to do? maybe is better to dont put the buffer parameter in the parfile?
or you have any suggestion?
thank you a lot
|
|
|
|