import table with CLOB
in Database
Summary:
We want to perform expdp/impdp of database having a large tables with CLOB datatype of size around 1 TB.
What is the fastest way to complete this ? since normal expdp and impdp are running very long. Planning to take full export of database exlcuding the two tables.
Content (please ensure you mask any confidential information):
We tried to perform expdp using parallel method but while performing import they are slow and getting locked with contention.
#!/bin/bash
chunk=10
for ((i=0;i<=9;i++));
do
expdp USERNAME/Password@DB_NAME TABLES=LOB_TEST QUERY=LOB_TEST:\"where mod\(dbms_rowid.rowid_block_number\(rowid\)\, ${chunk}\) = ${i}\" directory=DMP dumpfile=lob_test_${i}.dmp logfile= log_test_${i}.log &
echo $i
done
Tagged:
0