Originally posted by: SystemAdmin

Hi every body,
i am newbie to aix
To create a new schema in oracle9i i contact my sys admin to create a raw file of 10 gb he has created 2 files with size of 5 gb each,i wish to know what is the command to view the size of raw file.

In oracle with os linux to create a new schema i just create a datafile like 'create tablespace TBSNAME datafile '/u01/oradata/name.dbf' size 1gb and ill assign this as a default tablespace to a particular schema,but in aix to create a new schema i came to raw file is must but i dunno how to assign that raw file in oracle to create a new tablespace can u pls help me out from this,

Thanks in advance

Originally posted by: hdkutz

Hello ramsdba,
first - ask your System Administrator!
He should support you with the name of the raw-Volume he just created.

Second:
In AIX a "raw" Volume is a logical Volume.
It will be addressed by oracle like "/dev/rname_of_the_lv".
Notice the r-name in after the "/dev/" for the raw-Volume.
To find out the Size of a lv use:
lslv name_of_the_lv
Notice the missing r in the name of the volume. Look for the PP-Size and multiply it with the count of LP-Size to get the Size of the lv.

Additional hint:
Look for the right permissions of /dev/rname_of_the_lv and /dev/name_of_the_lv. Oracle-User should own these files.

Cheers,
ku

Originally posted by: orphy

It seems to me that you not only have confusions dealing with AIX, you also have difficulties working with raw LVs. I suggest you go to MetaLink and do some reading. They have plenty of docs there that show you how to create DBs on raw logical volumes.
Orphy