From: Henrik (M. J. <hp...@gl...> - 2004-06-30 17:36:31
|
Replies below: David Hiltz wrote: > Environment: Using 'tora-alpha-1.3.14-static.tar.gz' on a Mandrake 9.2 box. > > A few things I've noticed with the new 1.3.14. > > - After I authenticate to a Oracle 9.2 database, I get a warning message > window: > > Exception in alert polling: > ORA-06550: line 1, column 7: > PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared > ORA-06550: line 1, column 7: > PL/SQL: Statement ignored > > BEGIN <ERROR>SYS.DBMS_ALERT.REGISTER(:name ); END; > > > This is probably because you haven't installed the DBMS_ALERT package in the database in combination with having a messed up default tool (Most people don't want to start with the Alert Messenger). To change the default tool go in to settings and select the "Tools" tab and choose either SQL Editor or Schema browser which are the most common startup tools. > - Inside the Schema Browser when I right click and 'Truncate' a table, I > answer yes and get this error: > > ORA-03290: Invalid truncate command - missing CLUSTER or TABLE > keyword > > TRUNCDATE scott<ERROR>.emp > > Fixed for the next release. > - Clicking on 'Create New Table' under the 'Columns' tab, the Name, > Datatype fields should be bigger and maybe Datatype could be a > pulldown with an extra column for precision. I apologize if this > is experimental stuff. > > When I try to create a new table 'XYZ', I get: > > Error in toExtract > Operation: Migration script > Object: SCOTT TABLE XYZ > Error: Invalid type TABLE to migrate > > I get the same thing when I try to Drop a table. > > I have so far only implemented the dialogs for this for Oracle databases so this is what should be expected so far. I'm working on it. Hopefully it will be done in 1.3.15. > - Clicking on 'Server Tuning', 'Current Sessions' or 'Sessions' crashes Tora > > When the Windows version is fixed (libmysql.dll), I could try these things > in that environment to compare. > > Hmm, weird. What kind of priviledges do you have to your Oracle database. /Mauritz Quest Software |