Error: Insufficient permissions (-25). Error: Unable to create MV view

[JosephBrentano]

I am trying to create multi-versioned views in ArcSDE 9.3 running on a Sun server with Oracle 11g and I am getting the following error message:

Error: Insufficient permissions (-25).
Error: Unable to create MV view rep_RCL_VALVE_mvu for table RCL_VALVE.

The command line is:

sdetable -o create_mv_view -T rep_RCL_VALVE_mvu -t RCL_VALVE -i esri_sde -s malibu -u fmoper -p fmoper

Any help would be appreciated.

Thank you,
Joseph Brentano Jr
EMWD

[anthonysanchez]

Verify that your fmoper  user has the "create view" system privilege.

Good luck.