alter session set events '10046 trace name context forever, level 12';
<run your create statement>
alter session set events '10046 trace name context off';
check user_dump_dest for a resulting tracefile and check where exaclty an ERROR line is reported.
that will help you to track down the issue.
Stefan
On 6/19/06, Michael Ray <topshot.rhit@(protected)> wrote: > > Why would I get ora-01031 (See ora-01031.ora-code.com) on "create sequence pump_id_seq minvalue 10000 > nocache;" as the schema owner, which I verified has the DBA role and > (implicit?) create any sequence system privilege? I also tried with the > schema name specified. > > 10gR2 on Win 2003 > > -- > > Sincerely, > Michael Ray > Topshot Systems LLC > -- > http://www.freelists.org/webpage/oracle-l > > >
Michael,<br><br>alter session set events '10046 trace name context forever, level 12';<br><br><run your create statement><br><br>alter session set events '10046 trace name context off';<br><br>check user_dump_dest for a resulting tracefile and check where exaclty an ERROR line is reported. <br><br>that will help you to track down the issue.<br><br><br>Stefan<br><br> <div><span class="gmail_quote">On 6/19/06, <b class="gmail_sendername">Michael Ray</b> <<a href="mailto:topshot.rhit@(protected)">topshot.rhit@(protected) </a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Why would I get ora-01031 (See ora-01031.ora-code.com) on "create sequence pump_id_seq minvalue 10000 <br>nocache;" as the schema owner, which I verified has the DBA role and <br>(implicit?) create any sequence system privilege? I also tried with the<br >schema name specified.<br><br>10gR2 on Win 2003<br><br>--<br><br> Sincerely,<br>Michael Ray<br>Topshot Systems LLC<br>--<br><a href="http://www .freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a> <br><br><br></blockquote></div><br>
