Select Oracle Data dialog
This dialog is used when importing data from an Oracle database via the Open Data Import Centre, or exporting data to an Oracle database via the Open Data Export Centre.
The dialog is displayed when browsing for a file in the Open Data Import Centre or Open Data Export Centre.
Field | Description |
---|---|
Net Service Name |
The name that was used to identify this particular Oracle database instance on your PC. (There are a variety of ways of setting this up and Oracle software and documentation refers to this in a number of different ways. One way this may have been set up, for example, is using the Oracle Net Configuration Assistant, where it is referred to as the network service name.) |
Username |
Database user name for the connection. |
Password |
Database password associated with the specified database user. |
Save Encrypted Username and Password |
Enabled when connected to Oracle database. Check this option to remember the Username and Password for the next time the dialog is opened. The Username and Password will be saved in encrypted form. |
Connect / Disconnect |
Use this button to Connect / Disconnect from the Oracle database. |
Show Tables Created by User |
Enabled when connected to Oracle database. Select a user name from the Created by User dropdown list. The tables created by the selected user will be made available for selection from the Feature dropdown list in the Open Data Import Centre when OK is clicked. |
Use Oracle SRID |
Enabled when connected to Oracle database. Either type in a projected Oracle Spatial Reference Identifier or click the Select button to select a projected SRID from the Select Oracle Projected SRID dialog. |