How to recover table from tabledef object.
we have baan4c4 with oracle database. and table object stored in /dict/vrc
we have that object but table defination not presenet in maintain tabledef..
can it possible to recover the same using object..

from
Amol

1. recreate the object manually, you still seems to have the runtime component so names/domains are known.
2. restore a complete backup.
3. try to retrieve the specific tools tables that store the table definition from a oracle dump.
4. export the table definition from another environment and import it. (ttiex1280m000 and ttiex1285m000)

Did I understand correctly:

You've lost your tabledefinition but the Oracle table is still there?


If you are using the Level2 driver I think it also could work this way:

Make a Backup :cool:

Create the table definition in Baan
Convert your tables to Runtime DD without reconfigure
Copy the DD.new files to the correct DD files
Remove the corresponding records in the ttaad50x tables (Company 000) manually
We use this way if our tables are too large for changing them regular but it should also work for creating them.

Maybe it helps

Regards
csecgn

I only have tabledefination object i.e /baan4c4/dict/
and their is no entry in oracle level as well as baan 000 level.
How can i restore the table from that object ???

Amolpk

I only have tabledefination object i.e /baan4c4/dict/
and their is no entry in oracle level as well as baan 000 level.
How can i restore the table from that object ???

OK, next question: The table is completely lost (Baan and Oracle) except of the dd-file?

The dd-file is an ascii file. You will find the whole table definiton in a readable format. Not easy to read at the first time, but at the second time its ok.

Example:

(...)
F
:NAME:tdsls045.cmba
:DBAS:0
:CHIL:tdsls045.orno tdsls045.pono
:REFR:tdsls041.cmba
:REFM:1 t1
(...)
F
:NAME:tdsls045.o.tour
:DEFA:001
:FILL:1
:DOMA:tcyesno
(...)
I
:IDNO:001
:KEYF:tdsls045.cmbb
:ACTI:1
(...)
You will find the domain, defaults, at combined fields the childs and so on. The indexes are at the end of the file. With this information you can recreate your table.

Hope this helps

Regards
csecgn