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.
Thursday, March 8, 2012
Application-defined or object-defined error 40002
Labels:
application-defined,
database,
error,
microsoft,
mysql,
object-defined,
oracle,
server,
sql,
tempdb
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment