Oracle Step 1 - Define a user for the 3D City Database A dedicated database user should be created for your work with the 3D City Database. This user must have the roles CONNECT and RESOURCE assigned and must own the privileges CREATE SEQUENCE and CREATE TABLE. If you plan to do a migration from the 3D City Database v2.1 (see chapter 3.4), the privilege CREATE SYNONYM is also necessary. The privileges CREATE SEQUENCE and CREATE TABLE are required for Note: enabling and disabling spatial indexes. It is to inherit these privileges not sufficient through a role. Step 2 Connect to the Oracle database via SQL*Plus or SQL Developer – The script for setting up the database can be invoked from the command line tool SQL*Plus or from the software. For SQL*Plus, first start a shell environment of Oracle SQL Developer your preferred operating system and navigate to the directory where the CREATE_DB script is located. Then, a connection to the Oracle database is established, for instance, with the following command using the ezconnect functionality of SQL*Plus: sqlplus [USER]/[PASS]@\“[HOSTNAME]:[PORT]/[SID]\“ Figure 50: Connecting to Oracle using SQL*Plus and ezconnect. If you use a SQL*Plus client prior to version 11, ezconnect may not be available. In Note: this case, you have to edit the file in order to specify the connection tnsnames.ora parameters. Please refer to your Oracle documentation for details. Step 3 - Execute the CREATE_DB script: Once the connection to the Oracle database is established, the setup script can be executed with the following command at the SQL prompt: SQL> @CREATE_DB.sql; Figure 51: Command to execute the CREATE_DB.sql script. When using SQL Developer, directly execute CREATE_DB2.sql. Under the menu Note: > Preferences > Database > Worksheet > Default path to look for item ‘Tools the path to the CREATE_DB2.sql script. Then call the script from scripts’, enter within an SQL sheet with the command @CREATE_DB2.sql.
Oracle Step 1 - Define a user for the 3D City Database A dedicated database user should be created for your work with the 3D City Database. This user must have the roles CONNECT and RESOURCE assigned and must own the privileges CREATE SEQUENCE and CREATE TABLE. If you plan to do a migration from the 3D City Database v2.1 (see chapter 3.4), the privilege CREATE SYNONYM is also necessary. Note: The privileges CREATE SEQUENCE and CREATE TABLE are required for enabling and disabling spatial indexes. It is not sufficient to inherit these privileges through a role. Step 2 – Connect to the Oracle database via SQL*Plus or SQL Developer The script for setting up the database can be invoked from the command line tool SQL*Plus or from the Oracle SQL Developer software. For SQL*Plus, first start a shell environment of your preferred operating system and navigate to the directory where the CREATE_DB script is located. Then, a connection to the Oracle database is established, for instance, with the following command using the ezconnect functionality of SQL*Plus: sqlplus [USER]/[PASS]@\“[HOSTNAME]:[PORT]/[SID]\“ Figure 50: Connecting to Oracle using SQL*Plus and ezconnect. Note: If you use a SQL*Plus client prior to version 11, ezconnect may not be available. In this case, you have to edit the tnsnames.ora file in order to specify the connection parameters. Please refer to your Oracle documentation for details. Step 3 - Execute the CREATE_DB script: Once the connection to the Oracle database is established, the setup script can be executed with the following command at the SQL prompt: SQL> @CREATE_DB.sql; Figure 51: Command to execute the CREATE_DB.sql script. Note: When using SQL Developer, directly execute CREATE_DB2.sql. Under the menu item ‘Tools > Preferences > Database > Worksheet > Default path to look for scripts’, enter the path to the CREATE_DB2.sql script. Then call the script from within an SQL sheet with the command @CREATE_DB2.sql.
3DCityDB_Documentation_v3.3.docx