Vince,
Thanks very much for the reply. Please can I just confirm that the process I need to follow would be something like:
1. Load the data into Oracle using the SRID 81989.
2. Use sdelayer -o register with the correct params e.g. -x etc.
3. Use the sdelayer -o describe_long to find the SRID key that the layer was registered with SDE.
4. Open the SPATIAL_REFERENCES table in the SDE schema and change the SRTEXT entry to match watch it should be for 27700 e.g.
PROJCS["British_National_Grid",GEOGCS["GCS_OSGB_1936",DATUM["D_OSGB_1936",SPHEROID["Airy_1830",6377563.396,299.3249646]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",-100000.0],PARAMETER["Central_Meridian",-2.0],PARAMETER["Scale_Factor",0.9996012717],PARAMETER["Latitude_Of_Origin",49.0],UNIT["Meter",1.0]]
As an alternative I presume I could also add a new entry into the SPATIAL_REFERENCES table first and then use the -R <SRID> option on sdelayer -o register specifying the key to the record I just added to the SPATIAL_REFERENCES table e.g.
sdelayer -o register -l <table,column> -e <entity_mask> -t <storage_type>
{[-C <row_id_column>[,{SDE|USER}[,<min_ID>]]]} [Spatial_Index]
[-E <{empty | xmin,ymin,xmax,ymax}>] [{-R <SRID> | [Spatial_Ref_Opts]}]
[-S <layer_description_str>] [-k <config_keyword>]
[-i <service> | <port#> | <direct connection>] [-s <server_name>]
[-D <database_name>] -u <DB_user_name> [-p <DB_user_password>] [-q]
Cheers
Andy