Oracle to SQL Server Migration – User Defined data types
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

Answer Question   |  August 28, 2008  1:38 AM
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle

ORA-27101 error when migrating Oracle 9i to AD domain
We are running Oracle 9 on a Windows 2003 box. We moved the server from a Windows domain to an AD domain. We then get an error messages looking like this: ORACLE not available ORA-27101 When we back out of the changes, everything works fine again. Any ideas? Thank you.

Answer Question   |  August 5, 2008  5:22 PM
Active Directory, ORA-27101, Oracle 9i, Oracle migration, Windows Server 2003

Migration from Oracle 8 to Oracle 10g
I have a database of 80MB in Oracle 8 and want to migate to 10g. OS is Solaris. Pl guide ?

Answer Question   |  June 13, 2008  2:48 PM
Oracle 10g, Oracle 8, Oracle migration, Solaris

upgrading oracle 8i to 10gR2 with 3.5TB database size
sirs, what is the best way to migrate a 3.5TB database from oracle 8i to 10gR2 on the same machine? the OS is AIX L5, with 10TB storage size

Answer Question   |  June 16, 2008  3:36 AM
AIX 5L, Oracle 10g, Oracle 8i, Oracle migration

Conversion or Migration from Oracle 9i to Oracle 10g database on Windows 2003 64 bit
Hi, Currently, I am using Oracle 9i (version 9.0.1.1) database now as per my business requirement, I need to upgrade it to Oracle 10g database. It has several database procedures and triggers stored with it. Operating System : Windows 2003 Server, 64 Bit I am looking for some help on this, what are the problems [...]

Answer Question   |  June 4, 2008  11:58 AM
Oracle 10g, Oracle 9i, Oracle migration

What’s the best way to import an Oracle database?
I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each time [...]

Answer Question   |  August 23, 2008  2:16 PM
Database, Oracle, Oracle error messages, Oracle import/export, Oracle migration, Oracle replication

Calling a report from a form
Hello experts I hope you all are fine & enjoying good health. I am facing a problem after migration from oracle 6i to oracle 9i, I wonder if someone can help me in calling a report from a form. I have used RUN_REPORT_OBJECT instead of RUN_PRODUCT but I am getting error FRM-41214 unable to run [...]

Answer Question   |  March 5, 2009  4:07 AM
FRM-41213, FRM-41214, Oracle 9i, Oracle error messages, Oracle migration

Moving oracle database
HI, We have planned to move our oracle 10g production database from Solaris to Aix bix. So experts, please suggest any best practices that you follow or any scripts that should be run before moving it or any documentation or case study that will help us to do the work more efficiently. Thanks a lot.

Answer Question   |  March 28, 2008  8:38 AM
AIX, Database, Oracle 10g, Oracle migration, Solaris