Latest Contributions by George_Thompson

Hi Dustin, There is no tool to do this, I would not recommend removing the geodatabase objects (repository tables, stored procedures, triggers, etc...) from the database, especially if SDE or another user in the geodatabase owns any objects. If this occurred it could corrupt the database as a whole. I think the easiest and safest way it the process that Alex P. referenced: "You may still be better off porting the tables and views that you want to save to a new database." Hope this helps... -George ... View more

Ronald, Can you connect to the Oracle database in SQLPlus (32 bit version)? Try uninstalling both the 32 and 64 bit clients, then re-install the 32 bit administrator full client. I have seen where the re-install and configuring of the TNSNAMES corrects the issue. I would recommend starting with the 32 bit client, then after that is successful add the 64 bit client, if needed. -George ... View more

Hi Diego, I have no way of knowing what was previously changed and why. I would recommend you log a Esri Technical Support‌ case if you need further clarification. -George ... View more

I replied in the in the Poll location also. It basically says the same thing as Asrujit! -George ... View more

The versions that we used to provide where from the Oracle site. We just made it easier to locate and install. -George ... View more

Hi Simon, You will need to download the Oracle client from Oracle's website. Here are a few links that I found when I searched in Google: Be sure to install the correct bit level for your ArcGIS client. Oracle Instant Clients Oracle Full Clients -George ... View more

Glad this helps! I would recommend navigating to a 10.3 help page and scrolling to the bottom. There is a "Feedback for this Topic?" link and send them information. This will go directly to the documentation team and let them know about the google search information you found. -George ... View more

Hi Anand, I think I would contact you Esri Account Manager or Esri Customer Service with licensing specific questions. This may limit possible incorrect responses. -George Customer Service‌ ... View more

Adding this to the Geodatabase group Geodatabase‌ ... View more

It looks like the ST_PixelData that is available at 10.2.x is also available at 10.3. Is this the ST_Pixel that you are referencing? I cannot speak for future release of Esri software and support plans. But support for these functions would extend till the version is moved to the "Retired" status. ... View more

Yes, ST_Raster is still supported at 10.3. The ST_Raster spatial type is created with a GP Tool or Python script: Create Raster Type Here is the documentation for ST_Raster for Oracle: http://desktop.arcgis.com/en/desktop/latest/manage-data/using-sql-with-gdbs/install-st-raster-oracle.htm There is also a list of functions that return the properties of an ST_Raster value Hopefully this will help.... -George Geodatabase‌ ... View more

Hi Jose, The upgrade process should not touch the versions in the geodatabase. The upgrade process is usually upgrading the geodatabase repository table, stored procedures, triggers, etc... to add the latest functionality. I would also recommend a reconcile/post on as many versions as possible, then run a compress to clear out the delta tables as much as possible. This will help improve the upgrade process. With that being said, it is recommended that you test the upgrade on a DEV machine first to make sure that everything appears correct after the upgrade and works as expected. Here is some documentation that cover the steps for a successful upgrade to 10.2.x: Preparing to upgrade an Oracle geodatabase Upgrading a geodatabase in Oracle Hopefully this helps. -George ... View more