Dumping data

gerie

gerie

Member
Everyone teels me I can't dump data via data administration to files larger then 2 gig. The ascii dump is to have a limitation of 2 gig. I have tables from 14 gig I want to dump and load in our DWH that runs on oracle.
It would be simple if I could just send over the ascii files.
When I make an ascii dump I get some large files there. So the system can handle creating dump files that are larger. I am wondering now, what the problem is with files that are larger then 2 gig.

Can someone explain this to me?

BTW OS W2003 server.
 
or ...

/* splitLargeTable.p */
DEFINE VARIABLE liMax AS INTEGER INITIAL 10000 NO-UNDO.
DEFINE VARIABLE liCnt AS INTEGER NO-UNDO.
DEFINE VARIABLE liFileNum AS INTEGER NO-UNDO.


OUTPUT TO VALUE("/tmp/Customer.d") .
FOR EACH Customer NO-LOCK:
liCnt = liCnt + 1.
EXPORT Customer EXCEPT City.
IF liCnt > liMax THEN DO:
OUTPUT CLOSE.
liFileNum = liFileNum + 1.
OUTPUT TO VALUE("/tmp/Customer.d" + "." +
STRING(liFileNum)) .
liCnt = 0.
NEXT.
END.
END.
OUTPUT CLOSE.
 
gerie said:
Everyone teels me I can't dump data via data administration to files larger then 2 gig. The ascii dump is to have a limitation of 2 gig. I have tables from 14 gig I want to dump and load in our DWH that runs on oracle.
It would be simple if I could just send over the ascii files.
When I make an ascii dump I get some large files there. So the system can handle creating dump files that are larger. I am wondering now, what the problem is with files that are larger then 2 gig.

Can someone explain this to me?

BTW OS W2003 server.
Click to expand...

What version of Progress are you running?
 
The 2GB limit for the 4GL goes away in 10.1something. (It may still exist for the OS or the filesystem.) Have you actually tried dumping a large table?

If it doesn't work then you just break it up arbitrarily like rstanciu suggests.
 
another ideea is to start your progress database server using TCP/IP like:
proserve sports2000 -S 25000
and to use a Progress client who handle the 2,5Go limits as a win32/linux OS.
Connect from win32/linux Progress client over the network and dump large tables.
(CONNECT -db sports2000 -S 25000 -H yourhost) -> DataAdministration->Dump-> ...
I will be slow .. but it work's as well.
 
You must log in or register to reply here.
Back
Top