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
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
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
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
Hi, Currently, I am using Oracle 9i (version 22.214.171.124) 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
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
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
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