We made the new company setup for test company. We are unable to create any table. we are getting following error messgae
"Cannot create table (error 2950)" .

Can some one help us?

Infor ERP LN Enterprise Server error messages
This section describes the Infor ERP LN Enterprise Server error messages that can occur. There are three categories of Infor ERP LN Enterprise Server errors:

Error numbers 1-99 are operating system errors.
error numbers 100-899 are database errors.
900-999 are network errors.
If an error code greater than 1000 appears, the error can be retrieved by subtracting 1000. For example:

Error number: 1510
Error: 1510-1000=510

Error 510 indicates a EDBNOTON - Database not on message gives DB
error When a fatal error occurs, more information is stored in the log files in the $BSE/log directory. For example, if bdbpost causes an error, it is reported in the log.bdbpost file.

01950, 00000, "no privileges on tablespace '%s'"
// *Cause: User does not have privileges to allocate an extent in the
// specified tablespace.
// *Action: Grant the user the appropriate system privileges or grant the user
// space resource on the tablespace.

Thanks for reply. we already checked at oracle error log & it is showing that ora-01959:no privileges on tablespace 'USERS'. we granted the privileges also but still we are facing same error message.

Check in $BSE/lib/defaults/db_resource
use_shm_info:1
dbsinit:01
ora_init: 0111000
ora_max_array_fetch:5
ora_max_array_insert:5
nls_lang:american_america.we8iso8859p1
nls_sort:binary
oracle_home:/app/common/oracle/product/10.1.0.4
ora_default_tablespace:USERS
ora_temporary_tablespace:TEMP
audit_mask:007
ora_timeout:{120,60,60,60,60}
lock_retry:0
ora_use_nchar:0

Thanks for reply. we already checked at oracle error log & it is showing that ora-01959:no privileges on tablespace 'USERS'. we granted the privileges also but still we are facing same error message.

who did you grant the privileges to?

Guessing you did it to bsp or whoever you're logging into baan as.

But what you really need to do is grant it to 'baan' (or whatever your group user is)

Dave

also - do you really want your tables going into the "User" tablespace?

you might want to put together an ora_storage file before you go any further and lay these tables out correctly.

Problem has solved. Now we are able to create the tables.

Thanks for help.