Oracle 10.2.1, ArcCatalog 10.2.1, try to convert all the feature classes in afeature dataset to the same projection. Then simply copy this to another oracle database with ST_GEOMETRY and you will see the output is messed up.
SQL> select table_name,srid from sde.st_geometry_columns;
TABLE_NAME SRID
-------------------------------- ----------
WHYDRANTVALVES_1 3857
PRIMARYOVERHEAD 3857
TRANSFORMER 3857
WMAIN_1 300004
WHYDRANT_1 3857
WATERDIST_NET_1_JUNCTIONS 3857
WFITTING_1 3857
WCONTROLVALVE_1 3857
WPUMP_1 3857
WLATERALLINE_1 300004
WSERVICECONNECTION_1 3857
WSYSTEMVALVE_1 3857
WCURBSTOPVALVE_1 3857
GDB_ITEMS 4326
If we ignore GDB_ITEMS, it is an out of the box table used for internal storage of information only, then we note that even though the projection was the same on the source system, it is different after a copy paste.
To find out what is different, I look at the ST_COORDINATE_SYSTEMS table:
SQL> desc sde.st_coordinate_systems;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME NVARCHAR2(128)
TYPE NVARCHAR2(128)
DEFINITION VARCHAR2(2048)
ORGANIZATION NVARCHAR2(128)
ID NOT NULL NUMBER(38)
DESCRIPTION NVARCHAR2(256)
So we see:
set pagesize 1000
set long 1000000
SQL> select * from sde.st_coordinate_systems where ID in (3857,300004);
NAME
--------------------------------------------------------------------------------
TYPE
--------------------------------------------------------------------------------
DEFINITION
--------------------------------------------------------------------------------
ORGANIZATION
--------------------------------------------------------------------------------
ID
----------
DESCRIPTION
--------------------------------------------------------------------------------
WGS_1984_Web_Mercator_Auxiliary_Sphere
PROJECTED
PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_W
GS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],U
NIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAME
TER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meri
dian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type
",0.0],UNIT["Meter",1.0]]
EPSG
3857
WGS 1984 Web Mercator Major Auxiliary Sphere
Only the 3857 is returned at all. The 300004 entry is completely missing.
So in my case I have a bug. One feature dataset is only supposed to have one projection type. Expecially if eveything is part of the same network. I am going to go look for patches in my case. But I was just debugging this and wanted to post how I matched up the projection to an SRID to sort out what string is used for which number in your database.