English

Error: Unable to create logfile system tables

Error Message

Using the DESCRIBE command like this:

C:\>sdelayer -o describe -u guest -p guest

May produce this error:

ArcSDE 8.0.1
Layer Administration Utility
-----------------------------------------------------
Error: Unable to create logfile system tables. User perhaps
lacks permissions or
resources to create tables (-288).
Error: Could not create a connection.

Cause

Most likely, the Oracle user lacks the RESOURCE role.

Solution or Workaround

Grant the RESOURCE role to the Oracle user.