Migrating NCLOB data

Rob

Member
We are upgrading from Oracle 10 to 11 and have 4 databases to convert. One of the databases contains NCLOB fields. The usual PL/SQL dump and load methods don't seem to support NCLOBs. Also, if we try the odbc importer we receive an error whenever selecting a table with an NCLOB in it. Is there some way within PL/SQL developer to move the data in tables with NCLOBs?
 
If you are having problems then you may want to try the Oracle imp/exp format of the Export/Import table tools.
 
We did manage to get it to work with the Oracle export / import through pl/sql developer. Thanks.
 
Back
Top