Operating multiple geodatabases

Creating multiple geodatabases

• SDE geodatabases functions as master geodatabase

          Requires SDE schema and SDE user

• Create additional schema and user for new geodatabase

          User requires same privileges as SDE

          1、create user project1 identifed by project1 default tablespace sde;

          2、Grant all the privileges  of sde to project1

• Execute sdesetup command

          sdesetup -o install -d oracle10g -i 5151:project1 -u project1 -p project1

• Delete a project instance

          sdesetup -o delete -d oracle10g -i 5151:project1

Connect to multiple geodatabases(oracle)

1、Application Server Connection

      server:machine name

      service:5151:Project1

      database:

      username:project1

      Password:project1

      Connection details:Project1.Default

2、Direct Connection

     server:

     service:sde:oracle10g:/:Project1

     database:

     username:project1

     Password:project1@acf

     Connection details:Project1.Default

Managing multiple geodatabases

• Listing the instances

          sdemon -o info -i instances

• Delete a project instance

          sdesetup -o delete -d oracle10g -i 5151:Project1

• Drops all tables of geodatabase owner