csm.dba's blog
Submitted by csm.dba on Tue, 2012-09-04 05:52
Hi,
We all know that CHAR and VARCHAR2 are two different datatypes used for storing strings in Oracle. When I asked many people about what’s the difference exactly, all were saying VARCHAR2 can be used for variable sized character strings. As I’m not satesfied with the answer, as always, I’ve decided to do my own experiments on these two. Please find the exercise I’ve performed below.
SQL> create table t1 (col1 char(10), col2 varchar2(10));
Table created.
SQL> insert into t1 values(‘Oracle’,'Oracle’);
1 row created.
Submitted by csm.dba on Tue, 2012-09-04 05:48
Hi Geeks,
When I was doing a research on Oracle Database creation, through DBCA, last week, I came across a very interesting scenario which I couldn’t stop sharing with you :)
I have a cluster of machines (don’t confuse it with a RAC cluster but just a group of machines required for my application deployment) with 11.2.0.2 installed and a Database instance running.
I got a requirement to remove everything accumulated in the machine as a result of the Oracle installation and the Database creation: The installation directories, the datafiles, oratab entries etc…
Submitted by csm.dba on Tue, 2012-09-04 05:47
Hi Oracle geeks,
Last Friday, I’ve noticed a strange thing happening in my 11.2.0.3 Database: I’m able to create objects in a tablespace which is marked READ ONLY !!!
Don’t believe this?? See the below
SQL> create tablespace ro datafile ‘/xxx/RO.DBF’ size 10M AUTOEXTEND ON;
Tablespace created.
SQL> alter tablespace ro read only;
Tablespace altered.
SQL> select status from dba_tablespaces where tablespace_name=’RO’;
STATUS
———
READ ONLY
SQL> sho user
USER is “CSM“
|