walter01
18th January 2006, 16:50
Hi all,
In the past my predecessor created 8 tables from the TC, TD and TI packages in the tools company 000.
How can I remove those tables ?
When I use session ttaad4231m000 I get a "Company not allowed" message.
I login with the tools package combination.
Walter
NPRao
18th January 2006, 21:17
You can do it from Oracle -
Drop table from database -
Drop baan.tfmfoc201200
Drop index from database -
For each index
Drop index baan.tfmfoc201200$IDX1
...
walter01
19th January 2006, 09:56
Thanks NPRao,
I was afraid that would be the solution. I think I also have to clear
the ttadv420 and ttadv421 an other tables that are associated with these tables.
Walter
NPRao
19th January 2006, 10:31
I think I also have to clear the ttadv420 and ttadv421 an other tables that are associated with these tables.
You don't have to. They contain the Table Definitions and not the physical tables in a company/database. You can delete them if you no longer need those table definitions.
walter01
19th January 2006, 10:58
Oh yeah, your'e right. We still need those definitions for our other companies.
So, just a few Oracle drops in company 000 and that's it.