Re: visual basic and oracle

Hi Steinar,

if you want to insert etc. an oracle table from Access or similar you have to create an unique index on your table on the host side.

Use: create unique index <index_name> on <table_name> (<index_element1>, ...) storage (...);

Use the whole row if you don't have an unique key.

I hope this helps,

Toni
In article <3kf2a8$rht_at_baugi.ifi.uio.no>, steinas_at_ifi.uio.no (Steinar Torset Skarsholt) wrote:

...
> 1)
> A table I have loaded with the SQL*LOADER turnes out to be read only.
 ...
> Greatful for any advice on the subjects
>

+--------------------------------------------------------------------+
| Anton Dischner, DBA and system-programmer    Phone: +49 89 70953202|
| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|
| Klinikum Grosshadern                         Home : +49 89 6254060 |
| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|
| 81366 Muenchen                                                     |
| Marchioninistr. 15                                                 |
| Germany                          Mail: dischner_at_med.uni-muenchen.de|
+--------------------------------------------------------------------+