Latest Contributions by VinceAngelo

What are SRIDs involved in the respective tables, and what are the parameters associated with those tables? - V ... View more

Each new release requires a new keycode file.  Have you used this ECP file to create 10.0 instances on this host before? Customer Service is the best contact for resolving keycode issues (I've occasionally had files that were invalid, and regenerating the file addressed the issue). - V ... View more

You should only connect to the database as user SDE if you are doing an upgrade (at which time, a whole lot more than SELECT ANY TABLE will be necessary). SELECT ANY TABLE is NOT necessary for the ArcSDE application server to function. The ArcSDE data dictionary tables are hidden when you connect through ArcGIS (intentionally, since you shouldn't ever be changing them), but access to them is necessary for ArcSDE to function. You should also see all the other tables to which you have been granted at least SELECT access.  In addition, you will see aa list of all featuredatasets, since these are not database objects and there is no way to determine access without walking the member list and testing the permissions of all the tables of all the member featureclasses (very slow). Nothing you have described matches the "wrong tables" in the title. - V ... View more

So would I, but I don't see the 300-400 hours it would take to write one opening up in my schedule anytime soon. - V ... View more

The KnowledgeBase has a number of articles on ST_SHAPELIB configuration and troubleshooting. - V ... View more

There are several dozen possible tuning parameters (both Oracle- and ArcSDE-specific), and scores of configuration options for thousands of possible use cases.  I haven't ever changed a tuning parameter that had a even a fraction of the positive impact of increasing the default 1/10th millimeter precision of ArcGIS-generated coordinate references to something in the 5 centimeter range.  Next most significant was optimizing the features in spatial index order. All database tuning options (for all databases) pale in comparison to making sure the system has robust I/O performance with multiple independent disks tuned to the database transfer blocksize, organizing the data to utilize parallelism in disk access, keeping the redo logs and temp tablespace apart from each other and data tables, and organizing the data in the tables for optimal query performance. - V ... View more

You might want to try fashioning the view in SQL with a tuning hint, then registering the view with 'sdelayer -o register' ( 'sdetable -o create_view' isn't really intended for use with ST_GEOMETRY or SDO_GEOMETRY storage). I wonder why you need to join a table with a view of itself when you can simply rename the columns with aliasing.  In theory, the optimizer should be able to work that out, but I try to make the queries as easy as possible. - V ... View more

The documentation provides an overview on locks, but one of the key points is that locks aren't ever overridden. Once you aquire a lock, you must relinquish it before you lose it (unless your session is disconnected). That said, SQL edits don't pay any attention to ArcGIS locks, so realtime updates can still be performed on layers with non-exclusive read locks. I wish I had a better answer for you, but RDBMSes have a fundamentally flat architecture; when you use them you need to be using naming conventions for organization. I've used a number of paradigms at different sites, but many of them have taken source, class, scale topology, and/or projection into account: NGA.DTED_LEVEL1_NW NGA.VPF_WATER_RIVERS_1M_L USGS.SRTM_3METER_WGS84 - V ... View more

There are many ways to organize, but best practice includes: + Reserve the 'SDE' user for administration of the instance; keep the password closely held + Create "data ownership accounts" to actually own spatial data layers + Use DBTUNE keywords to distribute tables and indexes across the available independent disks (treat a RAID array as one disk [or partition thereof]) + Individual users should have their own login to the database + Use database roles (groups) to manage access to the tables, granting users that need access the role(s) necessary to make edits + Web service(s) should use independent logins granted the minimum necessary (often read-only) access to reduce the risk of DOS attacks. + While feature datasets appear to be an easy way to organize tables into folders, they exist for managing complex data relationships that require all- or-nothing access -- use them sparingly, and only for data that must be edited with a shared long transaction across many tables. Making fundamental schema changes (like versioning a table) requires exclusive access to the table(s) involved. If the tables are part of a service, that service must be stopped before the changes can be made. Shutting down the server can be an acceptable way to get exclusive access, but Direct Connect connections will also need to be taken offline to obtain some locks. - V ... View more

Actually, you can jump that chasm using the 'sde2raster' and 'raster2sde' utilities of se_toolkit. First, you'd have to create new empty catalog(s) using ArcGIS.  Then you'd need to export the rasters (one tile at a time, using the '-r' option or a 'where' clause) with 'sde2raster'.  While it's possible to "pipe" between 'sde2raster' and 'raster2sde', in my experience, it's better to batch the process with discrete intermediate steps, so if you need to stop processing, you can start up again without having to delete a row from the target database (there's also fewer games to play when executing a 9.1 binary with 9.1 SDEHOME and a 10.0 binary with a 10.0 SDEHOME). I'd highly recommend that you change the tile size for 8-bit rasters on import to a 96x96 tile size (with '-t 96,96' ), or consider changing the compression type so that the nominal 8K page size of Oracle 11g is honored (without chaining the BLOB in *every* row).  If you prototype the process by exporting from the fourth tile level  ('-L 3'), it will take a fraction of the time for "whole table" trials. The one issue you'll have to watch for is a bug where partial tiles (those with NODATA near tile boundaries) are exported so that the last non-NODATA value "bleeds" south on import.  I haven't been able to reliably reproduce this issue since 9.3 came out (which is why it never got fixed) and haven't run 9.1 in ages.  I have worked on some masking tools to "repair" broken images, but not an automation tool to look for bleeding values. I did a number of these upgrades between 9.0/9.1 and 9.2/9.3 but it's been a long time since it was last needed.  In the long run, the Image Server extension capability of ArcGIS and ArcGIS Server caches have eliminated the need to implement rasters in databases, and disk sizes have changed to the point that a 600Gb catalog rattles inside the average firewire drive, making the database overhead to manage the storage wasteful. Good luck. - V ... View more

The .NET wrapper is a part of the VS2010 API release (only).  Which did you download? - V ... View more

How many users do you have connecting as SDE?  In an ideal world, the the number of users that hold the SDE password is quite limited.  The SDE user should not ever own spatial data, and should only be used to administer the ArcSDE installation. Once a session is killed, it cannot ever be restarted.  Killing all sessions is generally a rare occurance -- I wouldn't recommend using 'sdemon -o kill -t all' except under exceptional conditions. - V ... View more

The main problem with using UUIDs is that they're randomly allocated.  This means that when you drive a join through them, the index will be an inefficient lookup value.  It's not a large deal with small tables but with a very large table it can have a significant cost. You also need to be careful when copying tables with UUID values, because many of the copy methodologies are likely to assume you want new values in the target table. You'd probably be better off using an integer sequence of your own allocation or a base-36 string sequence (AAAA-9999 stores 1679616 discrete values in 4 human-readable bytes). - V ... View more

That "license has not been initialized" message is generated by ArcObjects.  This forum is for the File Geodatabase API, which has an independent code tree from ArcObjects (and really is free). If you have ArcGIS, you should probably use ArcObjects (or Python) to access file geodatabases (nothing extra to install; you just need to use the programming interface correctly [checking out a license at the top of your code]). - V ... View more

The documentation covers all those case -- there's even several ways to accomplish them (I recommend multiple ArcSDE install directories, not sharing one by changing the naming of $SDEHOME/etc files).  Use the upper-right search bar to look for "arcsde unix install" and the two top results should be Oracle install docs.  All you really need is a second /etc/services entry (I prefer to include the port number in the name, e.g., sde_prod5152 or sde_test5161). I don't generally recommend using remote server configurations (you can configure them for administrative purposes, just use Direct Connect for connections instead). You should still install ArcSDE media on the remote ArcSDE server so that the listener can be configured for ST_GEOMETRY (and the DLLs can be patched when it's time to apply an SP). - V ... View more