Schema export invalid

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Posts: 10
Joined: Tue 23 Mar 2010 19:50

Schema export invalid

Post by midnit » Thu 23 Feb 2012 19:55

I just exported a schema that resulted in a 6.5gig file. It was quick enough but when I tried to import I got an Oracle error "ORA-02024: data link not found" which if I ignore goes to "ORA-00933: SQL command not properly ended". The offending generated code is:

Code: Select all

-- Definition for database link "DB2GW.WORLD"
CONNECT TO PSRP01 IDENTIFIED BY /*Encrypted password*/
I assume its the password part? But its a bit of a pain to have errors in a such a large sql file that you can't open through normal means.

Also, it would be nice if dbForge could open the file it creates. Luckily there are programs that can. I could definitely see it not highlighting and giving intellisense but at least let us open it and goto line for debugging purposes. LTF Viewer works well for this but my wish would be to do it without another tool :)

Devart Team
Posts: 2229
Joined: Fri 24 Jun 2011 14:17

Post by alexa » Tue 28 Feb 2012 14:01

Yes, as you noticed, the problem lies in creating the database link as the password appears to be encrypted, so dbForge Studio for Oracle can't decrypt it.

To work it around, you would need to execute the script despite the errors by clicking the 'Ignore All' button in the dialog box. Once the script has been executed, you would need to create the database link manually specifying the correct password in the script.

It appears to be quite difficult for any software to open large scripts for editing. Please note that the LTF Viewer you have specified should have opened the script only for viewing but not for editing.

Generally, in dbForge Studio for Oracle you should be able to execute large scripts with no problems by either of the following ways:

1. Select 'Database -> Execute Large Script' from the main menu.
2. Select 'Database -> Export & Import -> Schema Import' from the main menu.

Post Reply