Hi ,
I was checking our baan tables and saw 3 new tables in company 400 without any rows .
ttadv400
ttadv401
ttadv998

I know these tables are from tools company 000 but How can they come into 400 . the original tables are still in 000 .
Is there a way to see which user created them .
and will it harmfull to drop them .

Thanks

Caner

Probably created by someone using ttaad4100, and no harm in removing them.

If so, then you could see that in log.aad4100 in $BSE/log

Else try:
grep adv400 $BSE/log/* >> read.log
grep adv401 $BSE/log/* >> read.log
grep adv998 $BSE/log/* >> read.log

Maybe some other log will tell you where the tables were made and by whom.

Hi,
I tried to drop these tables but could not drop them with session
ttaad4231m000 delete tables .Is there any other way to drop them .


Thanks

Caner

What error message you are getting while deletingthis tables ?

Which Database are you using ?

If it is Tbase, then it is quite simple. go to the unix directory where the tables for the particular company is located and remove the .bdt and .bid files

For the other databases, you can delete the tables through the respective DBA module

Regards

Hi,
It is not a real error message . it just says "0 tables deleted"
but I can reach the tables through GTM and informix

thanks

Caner

may be it is a permission problems (in the databse) to drop the table. check the error log file. you will get some clue

Regards

Make sure your current company number is set to the same company as the company you wish to delete the tables from. (You sometimes get "0 tables deleted" when there is a data dictionary mis-match.)

You can drop the tables from ttaad4100, programmers mode, last choice (DBActions) db.drop table...) No need to say that you'd better think twice first!