database admin tool

[CrijnsYves]

- Where is the information stored that we can see in the database administrator.


Problem is that we want to increase the size of the ValueString in the feature table amFVPortfolio to 255.
We should do this via the ACDBAdmin tool because otherwise the system isn't taking into account the increased size.
Second problem that we have with this is that we have more than 4000000 features in the table -> an update will take more than 2 days.
Third problem we have is the fact that the update crashes and continues with his processing. Result is that we lose all the data in the table.

So we now want to make the changes directly in oracle, without going via the database administrator. When we increase the size in oracle, ACDBAdmin tool isn't updated and AssetCenter takes the old values into account

I tried to update some xml files and database.txt file but without any result.

[maxbrod]

I suggest you, the following procedure:

1) By Oracle duplicate table amFVPortfolio,
create table amfvportfolioDUP as SELECT * FROM amfvportfolio
2) truncate table amfvportfolio
3) via the AC DBAdmin tool change size to 255
4) INSERT INTO amfvportfolio SELECT * FROM amfvportfolioDUP
wait and hope....

I think that it'run. Attempt, naturally must be done a db dump.
To early.