I want to do a migration from one database to another database. The question here is, how do I actually deal with the import and export of data that uses BLOB/CLOB datatype? Normally for the rest of the datatypes, I could export them in a delimiter format and then import into the new database using SQL Loader. As for BLOB/CLOB, I don't have any idea to do so. Can any expert here, provide me the approach? If possible, please include them with a comprehensive example. The migration script is written in Shell Script in UNIX platform.
Both database servers are in ORACLE and same version. I
understand that the EXPort and IMPort can only be used if the table structure did not change. As for my situation is slightly different.
Here is an example : I have a table A which need to be exported to a new db server but before that, table A need to be alter to add a new column(field). So, I need to write all the rows(records) to a delimiter format and only datatype which are NOT in CLOB/BLOB are being able to do so. Therefore, I need a suggestion from you to guide
me on how to migrate the datatype which uses this CLOB/BLOB in this scenario.
I would have to prepare a control file and uses SQL Loader to load into the the db server.
Start Free Trial
