Thursday, March 8, 2012

Application-defined or object-defined error 40002

I am using 6.5 .
Here is the error that i get
Think that tempdb is small how do i change that or what is this error about'

--------
AIMSMan
--------
Application-defined or object-defined error 40002

37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object '##RevByNetSALIMJUMMA' in database 'tempdb' because the 'default' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.( 1105)

ODBC

--------
Abort Retry Ignore
--------You'll have to increase the data device where tempdb resides (I do hope that you have it on a separate device) and then expand the database. I do not recommend to use segments on tempdb.|||How , i am new from oracle

i have set 2 devices as

1) Data
2) log

Pls tell me in detail

Tks
SEJ|||Default segment corresponds to data device.

No comments:

Post a Comment