Coulmns in oracle tables in alphabetical order (again)

system · October 7, 2003, 3:25pm

Hi All,
I appended about this some time ago…and got it working…but now it seems to be ‘broken’ again.

I have some universes where I am using oracle as the BO repository and Oracle connections for designer. I am looking at some universes that I have not used for a while (development universes) and all the columns in the tables are in alpha order 9I don’t konw how they got to be like that, it’s been 5 months).

I have set ColSort=13 on my oracle.sbo file and I have even tried reimporting the universe from the repository. I have also tried refreshing tables…Is there any way I can get my columns back into column order?

Thanks
Peter Nolan

peternolan9 (BOB member since 2003-02-01)

system · October 7, 2003, 3:33pm

Did you look at this thread Columns in alphabetical order in Oracle Repository - in particular the VBA solution from Dwayne?

Also, please feel free to continue an “old” thread" if your topic is so closely related instead of opening a new thread

Andreas (BOB member since 2002-06-20)