Exporting CLOB data in a file and importing using SQL Loader [message #642583] |
Tue, 15 September 2015 03:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
amit.sonar
Messages: 98 Registered: December 2009 Location: Mumbai
|
Member |
|
|
Hi All,
I am trying to import CLOB data from one instance to another instance. Following is my table structure
CREATE TABLE TEST_CLOB
(ID NUMBER,
ENTITY_NAME VARCHAR2(20),
XML_FIELD CLOB,
HTML_TAGS CLOB
)
I am trying to export the data from above table in csv or txt file but the clob fields are not exporting properly. Also I want to import the same file using the same export file by SQL loader.
Please let me know how should I export and import the table data including clob fields.
Thanks & REgards,
Amit Sonar
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Exporting CLOB data in a file and importing using SQL Loader [message #642791 is a reply to message #642649] |
Sat, 19 September 2015 06:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
amit.sonar wrote on Wed, 16 September 2015 04:53Hi Cookiemaster,
Sometimes to take datapump of online data require so many approvals and it is time consuming. To save the time, I am finding the other way to do the same.
Thanks & Regards,
Amit Sonar
I agree with Cookiemonster (msg #642655). datapump is just another client tool. As far as the database is concerned it is no different than sqlplus or Toad or SQL Developer or some Office app using ODBC. It is just another client process, connected to the database with whatever credentials (username/schemaname) you provide. It gives you no privileges that you don't have explicitly granted anyway, and unless you are doing a FULL export (which you are not) does not require any special privs.
Besides, the above statement regarding approvals seems to contradict your earlier statement, "datapump is an option. However, I am trying to do it via file."
And what did you mean by "do it via file"? ANY kind of export produces a file. That is the whole purpose of export. And Toad isn't bringing any "magic" to the process. There is no magic. Toad is just a GUI front-end. Everything it does with the database is done by issuing SQL. And while I haven't used TOAD in years, I strongly suspect that even its 'export' is just invoking oracle's own exp utility behind the GUI.
|
|
|
Re: Exporting CLOB data in a file and importing using SQL Loader [message #642796 is a reply to message #642791] |
Sat, 19 September 2015 09:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21808 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I suspect that the major issue here is the result (export file's) location. EXPDP creates file on a server, which means that person - who performs export - has to know directory name, as well as have access to that directory. If your DBA doesn't particularly like you (for some reason) or you maybe aren't even supposed to export any data, it is painful to ask the DBA for required privileges. Therefore, you look for another way of performing export so that you avoid DBA's assistance.
|
|
|