Hi, One of my friend is having a peculiar problem and will appreciate any help from this group.
Is it possible for 2 symbolic links to point to the same raw device and be able to create both datafiles ? The following is the situation, experienced by him: There is a tablespace having (staging_d_03.dbf) which is a symbolic link to a raw device (/dev/vg02/rlvol19) . This datatafile is a part of tablespace STAGING_D. By mistake, another link was created (appusr_d27.dbf) pointing to the same raw device. 17 May 7 17:01 staging_d_03.dbf -> /dev/vg02/rlvol19 17 May 15 15:09 appusr_d27.dbf -> /dev/vg02/rlvol19 Now, he has been able to add this (appusr_d27.dbf) to another tablespace (APP_USERS) WITHOUT using the "reuse" clause . Is it possible ? (I do not have any raw device to test this, but tried creating symbolic links to the same file (on filesystem) and was,as expected, unable to add the existing datafile to another tablespace ) Further, he took the dump of the control file (alter database backup controlfile to trace;) and it is showing both the datafiles. He actually does not need the staging datafile any more, so can he just go ahead and drop the datafile (by recreating the STAGING_D tablespace ? What must be happening ? Is it possible that the file has been overwritten/corrupt ? Thanks Sukumar Kurup __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sukumar Kurup INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).