Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Question Unanswered: NLS_TERRITORY problem

    Hi All,

    when i execute this

    begin
    dbms_stats.gather_table_stats( ownname=>user,tabname=>'FT_Q_BEIN',cascade=>TRUE,e stimate_percent=>dbms_stats.auto_sample_size,degre e=>dbms_stats.default_degree );end;


    I am not getting any errors
    but when I change the NLS_TERRITORY to 'SWITZERLAND'

    ALTER SESSION SET NLS_TERRITORY= 'SWITZERLAND';

    and run 'dbms_stats.gather_table_stats......' , I am getting this error

    ORA-00933: SQL command not properly ended
    ORA-06512: at "SYS.DBMS_STATS", line 9375
    ORA-06512: at "SYS.DBMS_STATS", line 9389
    ORA-06512: at line 4

    The default NLS_TERRITORY is AMERICA.

    Can somebody guide me
    Regards
    Ganesh

  2. #2
    Join Date
    Sep 2004
    Posts
    2

    Additional Information

    Hi,
    I further found out that when
    begin
    dbms_stats.gather_table_stats( ownname=>user,tabname=>'FT_Q_BEIN',cascade=>TRUE,e stimate_percent=>dbms_stats.auto_sample_size,degre e=>dbms_stats.default_degree );end;

    estimate_percent needs value from 0.00001 to 100 but dbms_stats.auto_sample_size is 0 - so may be thats the cause

    But strangely it works fine when the NLS_TERRITORY Is AMERICA

    Regards
    Ganesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •