I did the bdbpre on a table and trying to recreate the table on the exisiting server using bdbpost.But i got the problem "Can't create table error(3148)"
I executed bdbpost command with -f option. It created the table but not the indexes. While doing the reconfiguration of the tables it gives me the error
" Reconfiguration failed (error 102)" and " Create index 1 failed (error 3158)"
How can i overcome this problem?


Regards,
Query1

Hi there,

what often happens is that the table ist still locked, because you opened it (with ttaad4x00) and did not finish the bshell (leaving the ttaad-prog is NOT enough).
Why do you have to reconfig anyway? delete the table (you have the data in your bdbpre dump) and then either create it empty (leave the bshell after you did this) or create it with bdbpost anyway.
If you still hav probs then perhaps your index definition is faulty?

hth

Norbert

Hi there,

you have to subtract 1000 from the baan error no to get the corresponding oracle error, which is ORA 2158. If you use oerr, you get the following output:

02158, 00000, "invalid CREATE INDEX option"
// *Cause: An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS,
// MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE,
// UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified.
// *Action: Choose one of the valid CREATE INDEX options.

Basically this means, that you either use the wrong oracle driver or (more likely) have some rubbish options in your ora_storage file for the tables involved.

Regards

Markus