oracle forms 6i, export, import

5 pts.
Tags:
Export
Import
Oracle Forms 6i
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

is it possible for you to use the COMMIT option, at least for testing ?

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rockskater
    Hi, I'm beginner in what is pl / sql and oracle forms, I was watching the issue of importing data from excel files to oracle ... what is that complicates me how I can call or file, or some source code to proceed to import the file into oracle .. if I could help ... they are GRATEFUL thank you very much
    30 pointsBadges:
    report
  • Rockskater
    Hi, I’m beginner in what is pl / sql and oracle forms, I was watching the issue of importing data from excel files to oracle … what is that complicates me how I can call or file, or some source code to proceed to import the file into oracle .. if I could help … they are GRATEFUL thank you very much
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following