Recent content by GRAYTech

  1. G

    PDE Import Failing with No Errors

    Did anything ever come of this ? Is the latest version capable of importing large tables ?
  2. G

    PDE Import Failing with No Errors

    Size of the uncompressed file is 3.4GB. I tried a export/import using uncompressed files and got different results. It appears not only the size of the .pde file matters but also what's in it. A single uncompressed .pde file with a single table 171MB failed yet a single uncompressed .pde...
  3. G

    PDE Import Failing with No Errors

    I used version 9.0.0.1601 for both the export/import and got similar results. If the PDE file is too large the import fails as in version 8.x. Will there be a resolution to this?
  4. G

    PDE Import Failing with No Errors

    I split up the import into 5 parts and got better results but still not 100%. The issue does appear to be related to the size of the export.pde file generated. If I limit the export file to something less than 200MB it appears to work ok in all cases. 1> 70MB, 100+ tables - worked as expected...
  5. G

    PDE Import Failing with No Errors

    The export that contains all files is just a little less than 1GB. I've also tried exporting/importing just one of the larger files and it was around 200 MB.
  6. G

    PDE Import Failing with No Errors

    I exported a number of tables from an Oracle 10G database and saved the export log. 3 of the tables are bigger than the rest with several million rows in them. When I import into a 9.2 database the import works as expected until I get to the first large table, About 10% of the rows are...
  7. G

    Automate Table Export

    Is there a way to automate exporting tables using the T)ools, E)xport Tables menu option? I've tried the macro recorder with limited success. I need select a bunch of tables, specify the where clause, output file etc. Ideally, there should be some way to save all the options to a file, then...
  8. G

    Compare Table Data Different Schema

    I'm trying to compare table data from a different schema owner. It's possible to select a different 'user' in the source database but not in the target session. Is there a way to do this in version 8.0.2.1505 ? Thanks.
  9. G

    Database Timeout ?

    I should have also said when I run the same stored procedure via PL/SQL Developer it runs normally. PL/SQL waits for the proc to omcplete (several minutes) and produces the correct results.
  10. G

    Database Timeout ?

    DOA 4.01, Delphi 6-SP2, Oracle 9+. ASTA 3.1 (Stateless), RBServer 10.03 I've got a timeout error when running a stored procedure for longer than 30 seconds. I'm calling a stored proc voia an ASTA client (tastaclientdataset) which connects to an asta server using DOA components to ultimately...
Back
Top