Q:
oracle forms 6i, export, import
I am a SAN architect. Our test Oracle 6i forms import exports fail intermittently and tables that should fill in 30 – 45 mins run for over 10 hrs without completing. Refreshing the tablespace seems to be the only way to clean this up. For me this is an egregious way of handling the import export table build scenario. Any suggestions? On inquiry there do not seem to be any error codes ORA??? Generated when this happens, only the import export from hell.
Thanks in advance
Thanks in advance
ASKED:
Oct 1 2008 8:51 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Specifying COMMIT=Y prevents rollback segments from growing inordinately large and improves the performance of large imports, but it is only advisable if the table has uniqueness constraints, so if the import fails and it is restarted, any rows that have already been imported are rejected and the data does not get duplicated.
I would also try using the FEEDBACK parameter, which could help seeing if the import performance decreases gradually.
For example, if you specify FEEDBACK=100, Import should display a dot each time 100 rows have been imported.
It could also be useful specifying a log file (LOG=filename.log), but I guess if you don't see any error messages on screen, no error is going to be logged either.
