Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> NT Personal 7.3 - Navigator acting up?
I'm having a hard time getting to grips with Oracle Navigator. I've created a load of tables both using the create table wizard, by hand, and directly by typing SQL statements in SQL*Plus. For some strange reason, just one of my tables refuses to be modified in Navigator. I can type changes and tell them to commit, but when I refresh the table the changes haven't been applied.
Can someone please offer some advice?
For reference, here's the description of a table that I *can* edit in Navigator:
SQL> describe DIALTEST
Name Null? Type ------------------------------- -------- ---- COMMONKEY NOT NULL NUMBER(22) IAPNAME NOT NULL VARCHAR2(40) TIME NOT NULL DATE TESTBOX NOT NULL VARCHAR2(30) SUCCESS NOT NULL NUMBER(1) TOTALTIME NOT NULL NUMBER(10,4) CONNECTSPEED NOT NULL NUMBER(10)
And here's the one that I can't:
SQL> describe EVALQUEST
Name Null? Type ------------------------------- -------- ---- KEY NOT NULL DATE ISPNAME VARCHAR2(50) EVALUATOR VARCHAR2(40) DATETESTED DATE DIALUPNUMBER VARCHAR2(30) USERNAME VARCHAR2(30) PASSWORD VARCHAR2(30) COMPUTER VARCHAR2(40) OS VARCHAR2(15) MODEMTYPE VARCHAR2(150) MODEMSPEED VARCHAR2(30) CD VARCHAR2(3) FLOPPY VARCHAR2(3) DOCUMENTATION VARCHAR2(150) FLOPDOC VARCHAR2(3) CDDOC VARCHAR2(3) PRINTDOC VARCHAR2(3) READDOC VARCHAR2(3) REFDOC VARCHAR2(3) TIME VARCHAR2(3) PRODINF VARCHAR2(3) INSTINS VARCHAR2(3) TROUBGUIDDOC VARCHAR2(3) WORKED VARCHAR2(3) RESTROUB VARCHAR2(3) USEDHELP VARCHAR2(3) TROUBGUID VARCHAR2(3) RATEDOCS NUMBER(1) RATEHELP NUMBER(1) MINSTOWORK NUMBER(3) HOURSTOWORK NUMBER(3) DAYSTOWORK NUMBER(3) INSTCOMMENTS VARCHAR2(700) HOMEHELP VARCHAR2(3) HOMEWEB VARCHAR2(3) WEBSPEED VARCHAR2(6) EMAILINST VARCHAR2(3) EMAILDOCUSE VARCHAR2(3) EMAILUSED VARCHAR2(3) EMAILCOMMENTS VARCHAR2(700) CONDITIONS VARCHAR2(3) SATISCOND VARCHAR2(3) CONDCOMMENTS VARCHAR2(700) GENCOMMENTS VARCHAR2(2000) OWNER VARCHAR2(12) AFFILIATION VARCHAR2(200) EMAILADDR VARCHAR2(40)
Thanks for any advice,
Ross
.-------Ross Hamilton, PhD Student in the History of Computing-------.
| http://www.dcs.warwick.ac.uk/~ross | mailto:ross@dcs.warwick.ac.uk |
| Department of Computer Science, | 12 Newbold Place, Leamington |
| Uni. of Warwick, Coventry, CV4 7AL | Spa, Warwks, CV32 4HR, UK |
`-------------- Office: 01203 528043 | Home: 01926 886146 -----------'
Received on Thu Aug 21 1997 - 00:00:00 CDT