ops-shd

2001-07-13 Thread MShahid
We need to set up the following env, if any one awares of any pathes, extra bit of details to be considered, please let me know: Oracle 8.5.0 enterprise edition with Oracle Parallel server option on a compaq cluster machine FA-200. OAS4.0 Oracle Forms 5 Operating System is Windows NT 4, service p

Re:whic one to choose

2001-07-12 Thread MShahid
Thanks for the info about fragmentation. The n here is rather small in lenght like 5,10,15,25. For large n we are using varch2 like 100, 200 As for the nature of expansion, we do not know to be precise, but in general, the files will expand later rather than shrink. So for example if we have an r

ORACLE APPS PROBLEM

2001-07-11 Thread MShahid
We had configured long time ago Oracle Aps-Fixed Asset management on NT4.0 under local "ADMINISTRATOR" account. The server is connected to the network domain, but we did all installation by logging in as "ADMINISTRATOR". Now we have created another local user, grant him administrator role and res

whic one to choose

2001-07-11 Thread MShahid
The definition of char and varchar2 is clear from docu that one is used for fixed length and the other for variable. We are reviewing one database desgin given to use from our developers in that they have chosen to use CHAR(n) data types at many places, even though the field can have variable leng