|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by Joeller in Oracle 11.x Database
I know I am piggy backing on another question, but the guys have been very good at providing answers. I am running an export script generated by SQL Developer in SQL developer on a different database. I first I kept getting a lot of table not found errors until I realized that SQL Developer had generated the script to create each table without placing them in order so that the tables to which the foreign keys were related were created first. (i.e. it made a script that tries to make table B which has a foreign key relationship to Table a before making table A.) So I went into the script and moved the create table statements so that depedencies were created first. Then when I ran it SQL developer locked up. I can see what is wrong because the output window is scrolled down and not visible. I can't find the log file to see if anything was logged. (For all I know nothing was logged due to the lockup of SQL Server.) Does anyhone know how I can find out what went wrong.
20091111-EE-VQP-92 - Hierarchy / EE_QW_Related_20080208