Hi, Many developer and DBA has an idea about the storing clobs. Basic rule is “if length of clob is higher tan 4000 then it will be stored in lob segment not in table segment” which is correct but sometimes misinterpreted! if you have a clob column in your table, your data might be in […]
Month: July 2019
ORA-00942: table or view does not exist and sequences as default value
Hello, after 12c or above we are able to set sequence’s nextval as the default value of an ID column. One of my customer started to complain about the ORA 00942 (table or view does not exist) error even if they have all necessary privileges on the table. After a quick investigation I realized that […]
Insert multi line text data using sqlldr
Hello Everyone, I just answered an OTN question about inserting multi line data using sqlldr and simply wanted to share it here (https://community.oracle.com/thread/4278952) so if have a data like this in your text file:
|
1 2 3 4 5 6 7 |
1,"this is two line data", 10 2,"this is three line data", 11 3,"this is one line data", 12 4,this, 13 |
you need to do some extra work to accomplish this problem. In my example I have 4 rows but 2 […]