Is This Content Helpful?
We're glad to know this article was helpful.
This error occurs when using ArcSDE commands that call the SE_layer_create function, such as "shp2sde -o create ... -k ...", if LD_TBLSP and LF_TBLSP parameters are defined in the dbtune.sde file:
SDE Code (-51): Underlying DBMS error (Error in SE_layer_create())
Extended DBMS error code: 959
ORA-00959: tablespace 'P' does not exist
In dbtune.sde, LD_TBLSP and LF_TBLSP parameters are used to specify in which tablespace the SDE_LOG_FILES and SDE_LOGFILE_DATA tables should be stored.
These parameters should be used under the specially named keyword that begins with "##LOGFILE_ ", and should not be stored under any other user defined keyword. This problem can be solved in three different ways.