Hi, not 100% sure, as I do not have an Oracle db around at this moment, but I think it works the same as in the Postgres dialog, see screendump: in your list of tables in the connection dialog the cells in the column Feature id are changeable, click on it to be able to choose the right (integer?) column to be used as id. Same for setting the crs if it is not known from metadata.
Hope this helps, Regards, Richard Duivenvoorde On 7/24/21 3:46 AM, Yamen Tekaji wrote: > Hello.. > > Is my email getting through? > I don't get any reply from anyone. > > Can you please help me with the below request? > > Regards > Yamen > > > ---------- Forwarded message --------- > From: *Yamen Tekaji* <[email protected] <mailto:[email protected]>> > Date: Wed, Jul 21, 2021, 3:57 PM > Subject: Fix table unique column > To: <[email protected] <mailto:[email protected]>> > > > Dears, > > I connected QGIS to Oracle DB which contains tables with GEOMETRY and spatial > data. > > When trying to add some tables to the layer window, I saw this error message: > > 2021-07-13T16:48:15 WARNING Primary key field 'INSERT_DATE' for view > not unique. > > > This INSERT_DATE is not my primary Key column. I have a column called ID > which is the primary key. How can I tell QGIS which columns are the primary > keys in the tables I want to add to layers? > > > Please advise. > > > Regards, > > Yamen > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
