Home / server / Questions / 48427
In Process
Sopolin
Asked: 2009-07-31 21:48:32 +0800 CST

Move Data on Oracle 11g

  • 772

I am doing migration to move data from Ms SQL Server 2000 to Oracle 11g on HP Server machine. I don't know why it is very slow when I load data from file xxx.dat into table in oracle 11g.

Do anyone help me to solve my problem?

Thank, Ung Sopolin

oracle-11g

3 Answers

  1. You might want to consider using the NOLOGGING clause when inserting bulk data from files.

    ALTER TABLE[SPACE] name NOLOGGING;

    This would turn off logging of DML and DDL actions on the specified table or tablespace. What this basically means is your inserts won't write to the redo logs, which should speed up the whole process. Don't forget to later turn redo logging back on using

    ALTER TABLE[SPACE] name LOGGING;
    • 1

  2. Yes it is slow. You might want to use an SQL Migration tool one way or the other.

    • 0

  3. If the two Oracle machines are similar in hardware specification I'd suggest looking at the built in Enterprise Manager website site (DBCONSOLE) that should be part of each 11g instance.

    There should be a "Performance" tab that will give you a good idea of what is causing the performance difference between the two databases.

    • 0