Link to home
Create AccountLog in
Avatar of monto1
monto1

asked on

DBMS_STATS.RESTORE_SCHEMA_STATS -ORA-01843: not a valid month

Hi ,

I'm trying to restore a schema stats and had set my session timestamp format also but still getting the below error.Can some please let me know what is it that i'm doing wrong here.

Version:11203,AIX

ALTER SESSION SET NLS_TIMESTAMP_FORMAT='MM/DD/YYYY HH24:MI:SS:FF'

select systimestamp from dual;

11/13/2012 10:52:02.724169 AM -05:00

exec dbms_stats.restore_schema_stats('WMBUSR','10/18/2012 10:03:58.986761 PM -04:00')

ORA-01843: not a valid month
ORA-06512: at line 1

Open in new window


Thanks
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account