| doing parallel export's [message #73892] |
Fri, 30 July 2004 03:44  |
KARTHICK
Messages: 1
Registered: July 2004
|
Junior Member |
|
|
I want to do a prallel exports of a table which has say 20 million records.
Can i run the export parallely in 10 shells for different conditions of the same table.
say 5 million records for jan month and 5 million for feb month which is the condition for export.
So i require to know whether doing parallel export on the same table for differnt condition will produce a lock on the table.
|
|
|
|
| Re: doing parallel export's [message #73897 is a reply to message #73892] |
Sun, 01 August 2004 10:54  |
ilver
Messages: 50
Registered: January 2004
|
Member |
|
|
Maybe you should consider partitioning the table before exporting it.
If your 20 mill. row table have to be "sorted" / "partitioned" by the export utility, you could run into some challenges that could give some troubles.
Anything is possible, but the circumstanses will have a major impact on the right choice.
/ilver
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
