Robbie
That's not the answer I wanted to hear, but thanks for that.
Is that from personal experience of large table usage yourself ? If so what platform ?
It's possible that we may need to do this at least a couple of times a year to export the table from a live to development environment for testing purposes.
I am trying to ascertain if someone could confirm whether or not the time we have esitmated is correct or wildly inaccurate indicating we...
Thanks for the pointers so far gents. I think I should have given more info on the table size, here's the latest on the table size:
Number of columns = 104
Number of rows = 9864871
Size in Gb = 6.8
Index size in Gb = 18.4Gb - combined 34 indexes!!!
The failure does not matter that much, it's the fact that we believe it will take so long.
I was jsut wondering what other users have experienced with tables of this size ?
AIX 4.3.3 running on a IBM RS6000 SP - 8-way
Oracle 8.1.7
Using Oracle commands.
Estimate of timing was taken from total number of records that were processed during an attempt to do the export about a month or so ago, which failed after 12hrs.
We would like to export a large table from one environment to another, but as the table is 7.5 million rows in size our current estimate is that it will take approx. 34 hrs !!!
Is this correct ?
Or are we doing something wrong ?
Any of you guys running JDE OW using an SP as the Enterprise server, with Oracle 8.1.7 ?
If so I work for a company which is part way through a OW implementation and we are suffering some performance, Oracle and application type problems.
I am looking for a company who would like to share and...
To saolivei & misercord,
I work for a company that is part way through a OW implementation and we are having some performance, Oracle and applications issues.
I am looking for another corporation that is either implementing or have implemented OW, with a view to sharing some knowledge about...
We have a requirement for the OW monitoring tool and have been in touch with BMC. The plug-in yopu discribe is actually developed by JDE but so far as BMC are aware no one has implemented it yet. (Probably because it doesn't work then !!!)
I have spoken to a guy @ JDE's GATS, and he advised me...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.