Search results for query: *

May be a useful tip If you have scripts in 8i that use dbms_utility.analyze_database('COMPUTE') for updating stats for CBO in Oracle 8i, you may end up with a bit of shock when migrating to Oracle 9i. This is because although the above utility works fine in Oracle 8i, it can skew the...

I have raised an FAQ for setting up a SUN Solaris host for hosting Oracle instances. You may find it useful. All comments and suggestions are welcome

Dear friends, I hope you excuse me. However, I have been in Sybase business for a long time and I am a Sybase fan. Regrettably in the past couple of years and more recently with the current bad situation in the Financial markets I feel that Sybase is gradually losing its position as a strategic...

PLease see FAQ section "Recommendations for setting up SGA" for a multi purpose Oracle database"

I have seen a number of occasions when a Sybase or MS SQL Server stored procedure needs to be migrated to Oracle. A case in point very common with third part packages is to use a table called next rowid to get the consecutive values for id columns in Sybase or MSSQL. The package makers do this...

We have an application running using transact sql. This application is being migrated to Oracle9i. It uses the next rowid table to go and fetch value for the primary key of a give table. We will be modifying the design to be more appropriate to Oracle. The table holding the next rowid value has...

Hi, I came across this toolkit for Oracle called TOra (Toolkit for Oracle). Website http://www.globecom.se/tora/. I believe you can use it on windows privately for your own work. I am not a GUI fan but this toolkit looks good. You can download "Microsoft Windows installer zipfile...

Hi All, I am thinking of writing a series of FAQ about Sybase to Oracle and Oracle to Sybase transition. It will be mostly useful for those developers and DBAs who are new to Sybase and coming from Oracle Background. It may also help those who know about Sybase but need to start supporting...

Hi All, I am thinking of writing a series of FAQ about SQL Server/Sybase to Oracle transition. It will be mostly useful for those developers and DBAs who are new to Oracle and coming from SQL Server and Sybase Background. It may also help those who know about Oracle but need to start supporting...

This stored procedure can be used to create a sql script for all indexes for a given table (you need to provide the tablename) or for building indexes for all user tables in a given database (no tablename). Create it as 'sa' in sybsystemprocs database so you can invoke it from anywhere...

You can successfully install and run Sybase ASE 12.5.0.3 on version 8 and 7.2 of Red Hat Linux. I have not tried other releases of Linux yet. O/S versions Linux version 2.4.18-26.8.0 (bhcompile@daffy.perf.redhat.com) (gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Mon Feb 24 10:21:42...

In order to find out which tables have row level locking in a database you can try the following: use <DATABASE> go select name from sysobjects where type = 'U' and sysstat2 & 57344 = 32768 order by name go Note that values sysstat2 & 57344 =0 or 8192 refer to all pages locks and 16384 is data...