archives

calculate size of a data type used in a create table stmt

Hi, I would like to know if there is any way to find out the length of datatype mentioned in a create table stmt. For example: create table employee(empno number(3),empname varchar(10)); in the above DDL i have mentioned the size of my number datatype as 3. is there a way to retrieve that info.? apart from desc<table_name>???????

Discovery of newly added disk in ASM without bounce

Hi, Is there any way to add/discover new disk to ASM instance while instance is running. I needed more space for some DG and there were no disk available to my Server. I asked my Sys Admin and he added new Disks/partition/LUN to my server. I created new VOL_9 using oracleasm createdisk Vol_9 - but I can not use this vol_9 until ASM discover this, And I knew only

Discovery of newly added disk in ASM without bounce

Hi, Is there any way to add/discover new disk to ASM instance while instance is running. I needed more space for some DG and there were no disk available to my Server. I asked my Sys Admin and he added new Disks/partition/LUN to my server. I created new VOL_9 using oracleasm createdisk Vol_9 - but I can not use this vol_9 until ASM discover this, And I knew only

IT -Jobs, Interview Questions, Certification

Hi, In the very fast moving IT Industry, there is a need for the people to keep a note of what is happening in the field, what are the latest Jobs available and in which technologies they are available and what companies and also in which cities. And also when applying for Jobs, it is obvious for people to look for