Importing and defining the nautical product library workspace (Maritime Charting)

This workflow provides steps for importing the preconfigured XML workspace that contains all the necessary feature classes and tables that can be used in a geodatabase in Oracle to manage nautical data and products.

Creating ArcSDE shared log file tables

Enterprise-Geodatabases verwenden Protokolldateitabellen, um eine Liste ausgewählter Datensätze zu führen. Datensätze werden zur späteren Verwendung in Protokolldateitabellen geschrieben, wenn eine Auswahl mit einer bestimmten Größe vorgenommen wird, wenn ein Abgleich oder Zurückschreiben für eine versionierte Datenbank ausgeführt wird oder wenn ein entkoppeltes Bearbeitungs-Check-Out in einer Client-Anwendung durchgeführt wird. In den Protokolldateitabellen werden die ObjectIDs der ausgewählten Features gespeichert, damit sie nochmals angezeigt werden können. Dadurch können Informationen schneller analysiert und verarbeitet werden.

In ArcGIS werden Protokolldateitabellen standardmäßig verwendet, wenn der Auswahlsatz mindestens 100 Datensätze enthält. Dieser Auswahlgrenzwert von 100 Features ist in der Registrierung eingestellt. Der Wert kann zwar geändert werden, dies wird jedoch von Esri nicht empfohlen. Es gibt keinen bekannten Leistungsgrund hierfür, tatsächlich kann eine solche Änderung zu Leistungsproblemen führen.

It is recommended to create the ArcSDE log file tables for the product library owner and editor users before configuring the product library since log files are expected to be present before performing certain functions like reconciliation and post.

Schritte:

1. If you haven't already done so, grant CREATE TABLE and CREATE SEQUENCE privileges to the product library editor user in Oracle (PLEDITOR).
2. Start ArcCatalog.
3. Double-click the product library administrator connection geodatabase to connect to it.
4. Copy a feature class with more than 100 features into the geodatabase.
5. Right-click the feature class and click Manage > Privileges.
6. Click Add.

   The User/Role dialog box appears.

7. Choose the CKB_USERS role and click OK.
   Tipp:

   If the role doesn’t appear in the list, type CKB_USERS into the User/Role text box and click OK.

8. Check the Select check box for the CKB_USERS role in the Privileges dialog box.
9. Klicken Sie auf OK.
10. Close ArcCatalog.
11. Start ArcMap.
12. Klicken Sie auf die Schaltfläche Daten hinzufügen .

    Das Dialogfeld Daten hinzufügen wird geöffnet.

13. Add the feature class from the product library administrator connection into the map.
    Tipp:

    Alternatively, you can drag and drop the feature class in the Catalog window from your geodatabase into the Table Of Contents window.

14. Select more than 100 features.

    This automatically creates the log file tables.

15. Right-click the feature class in the Table Of Contents window, and click Remove to remove the feature class from the map.
16. Klicken Sie auf die Schaltfläche Daten hinzufügen .

    Das Dialogfeld Daten hinzufügen wird geöffnet.

17. Add the feature class from the product library editor connection into the map.
    Tipp:

    Alternatively, you can drag and drop the feature class in the Catalog window from your geodatabase into the Table Of Contents window.

18. Select more than 100 features.

    This automatically creates the log file tables.

19. Right-click the feature class in the Table Of Contents window, and click Remove to remove the feature class from the map.
20. Close ArcMap.
21. Start ArcCatalog.
22. Delete the temporary feature class from the product library administrator user connection.
23. Revoke CREATE TABLE and CREATE SEQUENCE privileges from the product library editor user in Oracle.
    Achtung:

    Do not revoke these privileges from the product library administrator user.

Importing the product library schema workspace

The XML workspace contains the standard product library tables. It is also preconfigured with a solution node (Nautical) and many class nodes (ENC, Chart, and so on) and has the unit conversion, Element, and VST tables.

Schritte:

1. Unzip the nautical product library file.

   The preconfigured workspace XML for ENC and Chart is available on the Resource Center. There is also one .gdb installed for DNC in the following location, based on your operating system.

   • On Windows XP, browse to <Installation location>\Documents and Settings\All Users\Application Data\Esri\Production10.2.2\Desktop\ProductLibraryFiles.
   • On Windows Vista, Windows 7, and Windows Server 2008, browse to <Installation location>\ProgramData\ESRI\Production10.2.2\Desktop\ProductLibraryFiles.
2. Start ArcCatalog.
3. In the Catalog window, expand Database Connections.
4. Double-click the product library administrator connection geodatabase to connect to it.
5. Right-click the geodatabase you just connected to and click Import > XML Workspace Document.
6. Click the Data option if it is not already selected.
7. Select the nautical product library located in the directory from step 1.
8. Klicken Sie auf Öffnen.
9. Klicken Sie auf Weiter.
10. Klicken Sie auf Fertig stellen.

Versioning within the product library

If you manually import the product library tables and feature classes, such as importing an XML file, you need to verify that all the tables and feature classes are registered as versioned. This allows the software to edit the tables as you create and work with your product library. However, you shouldn't create new versions of the product library tables; this can result in inconsistencies within the versions.

Schritte:

1. Click the Toggle Contents Panel button at the top of the window.

   The Toggle Contents Panel dialog box appears.

2. Select every table feature stored in the product library with the exception of the following:

   • ELM_CATEGORIES
   • ELM_ELEMENTS
   • ELM_PRODUCTS
   • ELM_SOLUTIONS
   • PLTS_UCE_CONVERSIONS
   • PLTS_UCE_MAPPINGS
   • PLTS_UCE_ROUNDINGRULES
   • PL_CHART_AOI
   • PL_ENC_AOI
   • PL_NIS_AOI

   Tipp:

   Press SHIFT and/or CTRL, and then the tables to make multiple selections.

3. Right-click within your selected tables and click Manage > Register as Versioned.

   Do not check the Register the selected objects with the option to move edits to base check box.

4. Klicken Sie auf OK.
5. Select the following feature classes stored in your product library and click Manage > Register as Versioned.
   • PL_ENC_AOI
   • PL_NIS_AOI
   • PL_CHART_AOI

   Do not check the Register the selected objects with the option to move edits to base check box.

6. Klicken Sie auf OK.

Granting privileges to the database role

You need to assign privileges to the components in the geodatabase in Oracle.

All features imported with the product library XML workspace need privileges.

All the tables in the product library need to have read/write privileges assigned to them, except the PL_Permission table. The PL_Permission table only needs read privileges assigned to it.

Grant the following privileges to the CKB_USERS database role.

Objects	Role	Privileges
PL_Permission	CKB_USERS	Select
All tables except PL_Permission	CKB_USERS	Select, Insert, Update, Delete

Schritte:

1. In the Toggle Contents Panel dialog box, select the PL_Permission table, right-click, then click Manage > Privileges.

   The Privileges dialog box appears.

2. Klicken Sie auf Hinzufügen.
3. Type CKB_USERS into the User/Role text box.
4. Check the Select check box to assign view privileges to the CKB_USERS for the PL_Permission table.
5. Click OK.

   The Toggle Contents Panel dialog box appears.

6. Select every table stored in the product library with the exception of the following:
   • PL_PERMISSION
   • PL_CHART_AOI
   • PL_ENC_AOI
   • PL_NIS_AOI
7. Right-click the selected tables and click Manage > Privileges.

   The Change Privileges dialog box appears.

8. Type CKB_USERS in the User text box.
9. Click the View (Select) (optional) drop-down arrow and choose GRANT.
10. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
11. Klicken Sie auf OK.
12. Select the following feature classes stored in the product library:
    • PL_CHART_AOI
    • PL_ENC_AOI
    • PL_NIS_AOI
13. Right-click the selected feature classes and click Manage > Privileges.

    The Change Privileges dialog box appears.

14. Type CKB_USERS in the User text box.
15. Click the View (Select) (optional) drop-down arrow and choose GRANT.
16. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
17. Klicken Sie auf OK.
18. Close ArcMap.