|
1
|
<h3>Create a New Oracle Connection</h3>
|
|
2
|
This dialog allows you to define the settings for a connection to a Oracle database.
|
|
3
|
<p>
|
|
4
|
<ul>
|
|
5
|
<li> <label>Name</label> A name to identify the connection settings.
|
|
6
|
|
|
7
|
<li> <label>Database</label> SID or SERVICE_NAME of the Oracle instance.
|
|
8
|
|
|
9
|
<li> <label>Host</label> Name or IP address of the computer hosting the database server.
|
|
10
|
|
|
11
|
<li> <label>Port</label> IP port used by the database server (1521 is Oracle's default).
|
|
12
|
|
|
13
|
<li> <label>Username</label> Database user name.
|
|
14
|
<li> <label>Password</label> Database password.
|
|
15
|
|
|
16
|
<li> <label>Save Username</label> Indicate whether to save the user name in the connection settings.
|
|
17
|
|
|
18
|
<li> <label>Save Password</label> Indicate whether to save the password in the connection settings. <font color="red">Passwords are saved in <strong>clear text</strong> in the system configuration and in the project files!</font>
|
|
19
|
|
|
20
|
<li> <label>Only look in meta data table</label> Restricts the displayed tables to those that are in the <strong>all_sdo_geom_metadata</strong> view. This can speed up the listing of spatial tables.
|
|
21
|
|
|
22
|
<li> <label>Only look for User's tables</label> When searching for spatial tables, restrict the search to tables that are owned by the user.
|
|
23
|
|
|
24
|
<li> <label>Also list tables with no geometry</label> Indicates that tables without geometry should also be listed.
|
|
25
|
|
|
26
|
<li> <label>Use estimated table metadata</label> For each layer that is setup, various metadata is required by QGIS for the Oracle table.
|
|
27
|
This includes information such as the table row count, geometry type and spatial extents of the data held in the geometry column.
|
|
28
|
If the table contains a large number of rows, determining this metadata is time consuming.
|
|
29
|
By activating this option the following fast table metadata operations are done:
|
|
30
|
<ul><li>Row count is determined from <strong>all_tables.num_rows</strong>.</li>
|
|
31
|
<li>Table extents are always determined with the SDO_TUNE.EXTENTS_OF function even if a layer filter is applied.</li>
|
|
32
|
<li>The table geometry is determined from the first 100 non-null geometry rows in the table.</li></ul>
|
|
33
|
|
|
34
|
<li> <label>Only existing geometry types</label> Only list the existing
|
|
35
|
geometry types and don't offer to add others.
|
|
36
|
|
|
37
|
</ul>
|