FAQ's - APPX Software, Inc. : APPX Utility : APPX System Administration :
Importing big Oracle tables! | |
If your tables are large &/or have numerous indexes, the following can speed up the import significantly:
After using APPX to create the table in Oracle (and presumably other RDBMS's), use SQL PLUS or any other DBA tool to drop all the table's indexes. Then import the data -- it will import much faster. Important: Your Appx import should use the "merge" option. Otherwise, APPX scratches/creates before importing, recreating the indexes that you just dropped, and eliminating the performance boost you want during the import.
After importing, tell APPX to 3)Create the table again. APPX won't create the table since it already exists, but will create the missing indexes much more quickly than if you had built the indices one row at a time.
| |
[Append to This Answer] | |
2004-Jan-05 4:25pm |
Previous: | Where is Java/Client cache? |
Next: | What is my AppxODBC version? |
|