Maximum Columnsize for VARCHAR2 is now 32k! With Oracle12c you can define a column of data type VARCHAR2, NVARCHAR2 or RAW with a maximum length of 32768 Byte (but not CHAR!). But why is that useful? Datatype CLOB or NCLOB … Continue reading
Category Archives: Oracle(E)
Multi-Process Multi-Threaded Oracle If you are running Oracle databases on Unix or Linux you probably know that there are many processes even if no user is connected. But if you run Oracle on Microsoft Windows you only see one processes … Continue reading
Hi I just switched my blog to carajandb.wordpress.com Unfortunately all comments on current blogs have been removed.
As you might have read in my previous blogs I did some tests with Oracle 10g and 11g on Linu 6 Update 1 – and it works even though there is no official support from Oracle. Due to a presentation … Continue reading
Yes I know, it’s not supported and looks a bit crazy. But as I was using Linux 6 already with my RAC Database (see other blogs) and had to do some tests with an Oracle 10g database I tried to … Continue reading
It’s quite interesting that very many DBAs still use other methods than RMAN to backup their databases. I don’t mean the highend solutions like splitmirror but export / import or offline backups with OS-methods. But it’s so easy to backup … Continue reading