SQLULDR2 can run as fast as Oracle exp utility with default command line options. If you increase the buffer to 1 megabyte for exp, it's still 15% faster than SQLULDR2. And may be much faster in direct mode export. Due to the data type conversion in SQLULDR2, it's resonalbe performance downgrade.
For most cases, SQLULDR2 will be faster than exp, because it's hard to tuning the performance related parameters , while SQLULDR2 can easily get them done, such as parallel table scan and multiple block read count. It's time to use SQLULDR2 in data migration, because text load with sqlldr in direct mode is much faster than Oracle imp utility.
I also make some changes to the query option of SQLULDR2, you can just specify the table name for whole table unloading now.
C:\>sqluldr2 scott/tiger query=emp
0 rows exported at 2009-03-31 20:09:54
14 rows exported at 2009-03-31 20:09:54
output file temp.dat closed at 14 rows.
With the same effect with the full command.
sqluldr2 scott/tiger query="select * from emp" table=emp
And it will ommit the ending commo or slash char, as in SQL*Plus, we use it to ternimate the SQL statement.
sqluldr2 scott/tiger query="select * from emp;" table=emp
sqluldr2 scott/tiger query="select * from emp/" table=emp
If you just specify the table name for query option, by default, the table option will be set to the same value, and generate the SQL*Loader control file automatically.
Comments (1)
The repair tool for the corrupted SQL database and its objects comes in the name of SQL repair software. These software make an enhanced scan of the corrupted database and then extracts the valuable data from it. If you are suffering from the particular trigger corruption problem then be sure that the SQL database software that you are going to choose is able to solve your particular problem.
Posted by MySQL repair | April 2, 2009 4:31 PM