Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?
It is your plan to "add a sde.st_geometry user-defined type" that means you will need ArcGIS Server (of which ArcSDE is a component) licensed.
If that is a mandatory requirement then your most cost effective (but still very expensive, for personal budgets) option may be the EDN.
For an effectively free Database Server (Desktop) (formerly called Personal ArcSDE), which comes as part of ArcGIS Desktop Advanced (and Standard), I think you will need to drop your requirement for Oracle XE and use SQL Server Express.
While Oracle XE is the Oracle equivalent for SQL Server Express it is not accessible via a Personal ArcSDE.
ESRI.ST_Geometry:
To my surprise, I was able to use the Create Spatial Type tool to create st_geometry in an Oracle XE database. This worked, despite the fact that my database was not a geodatabase.
The Create Spatial Type tool adds or upgrades the ST_Geometry SQL type, subtypes, and functions to an Oracle or PostgreSQL database. This allows you to use the ST_Geometry SQL type to store geometries in a database that does not contain a geodatabase. This tool also can be used to upgrade an existing ST_Geometry installation in an Oracle or PostgreSQL database.
Geodatabase:
Unfortunately, I was not able to create a geodatabase in the database. I believe the only way to create a geodatabase in an Oracle database is to use the Enable Enterprise Geodatabase tool. One of the parameters of the tool is authorization_file, which of course, I don't have, because I have not purchased ArcGIS Server.
Provide the path and file name of the keycodes file that was created when you authorized ArcGIS for Server Enterprise. This file is in the \Program Files\ESRI\License\sysgen folder on Windows and /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License/sysgen directory on Linux. If you have not already done so, authorize ArcGIS for Server to create this file.
As a result, I do not have extended geodatabase functionality in my database, such as domains, subtypes, topology, etc..
ArcGIS Server/Enterprise Geodatabase/EDN:
With regards to purchasing a license for home use that would include ArcGIS Server, I think @PolyGeo was probably on to something with the Esri Developer Network (EDN) subscription:
...your most cost effective (but still very expensive, for personal budgets) option may be the EDN.
However, like @PolyGeo suggested, the EDN license is cost prohibitive for personal budgets:
- EDN costs between $2,500-$6,000 + tax (Canadian Dollar), depending on the options required (date: 2017).
- The main options to consider are if a license of ArcGIS Desktop is required and if so which one: Basic, Standard and Advanced.
- Annual subscription (must be paid yearly), it is for development purposes only, and is for one named user.
- There is no home or personal use pricing option.