Schema export invalid
Posted: 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:
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
Code: Select all
--
-- Definition for database link "DB2GW.WORLD"
--
DROP DATABASE LINK "DB2GW.WORLD";
CREATE DATABASE LINK "DB2GW.WORLD"
CONNECT TO PSRP01 IDENTIFIED BY /*Encrypted password*/
USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1526)(HOST =111.11.111.11))
(CONNECT_DATA=(SID=g))(HS=))';
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