Create a New Oracle Connection

• Name A name to identify the connection settings.
• Database SID or SERVICE_NAME of the Oracle instance.
• Host Name or IP address of the computer hosting the database server.
• Port IP port used by the database server (1521 is Oracle's default).
• Username Database user name.
• Password Database password.
• Save Username Indicate whether to save the user name in the connection settings.
• Save Password Indicate whether to save the password in the connection settings. Passwords are saved in clear text in the system configuration and in the project files!
• Only look in meta data table Restricts the displayed tables to those that are in the all_sdo_geom_metadata view. This can speed up the listing of spatial tables.
• Only look for User's tables When searching for spatial tables, restrict the search to tables that are owned by the user.
• Also list tables with no geometry Indicates that tables without geometry should also be listed.
• Use estimated table metadata For each layer that is setup, various metadata is required by QGIS for the Oracle table. This includes information such as the table row count, geometry type and spatial extents of the data held in the geometry column. If the table contains a large number of rows, determining this metadata is time consuming. By activating this option the following fast table metadata operations are done:
  • Row count is determined from all_tables.num_rows.
  • Table extents are always determined with the SDO_TUNE.EXTENTS_OF function even if a layer filter is applied.
  • The table geometry is determined from the first 100 non-null geometry rows in the table.
• Only existing geometry types Only list the existing geometry types and don't offer to add others.