Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> NT Personal 7.3 - Navigator acting up?

NT Personal 7.3 - Navigator acting up?

From: Mr R Hamilton <csrax_at_csv.warwick.ac.uk>
Date: 1997/08/21
Message-ID: <5th8k5$j03@crocus.csv.warwick.ac.uk>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US