SyncSort is NOT a data unloader. It's purpose, and it does a damned good job of it, is to sort large text files to improve data loading with tools like SQL*Loader. Your user should have zero access to the datafiles, period. They need to be -rw-r---- so that an ipc dedicated server process will work. But under NO circumstances should that be changed. Doing so can make for a VERY long night of recovering a database.
Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Tuesday, January 13, 2004 5:14 PM To: Multiple recipients of list ORACLE-L Oracle data files are read BY ORACLE SERVER PROCESSES ONLY! The only unloader that reads files directly is the notorious DUL. I haven't had any experiences with DUL, but according to what I know, I wouldn't even want to have it. Now there is a system call named "chmod" and oracle takes care that only oracle RDBMS can access files. Nobody but the DBA can even sniff database files. Please, execute that user. On 01/13/2004 04:19:25 PM, [EMAIL PROTECTED] wrote: > Hello All, > > I have a question on data file permissions. > When i add a new data file, it gets created as -rw-r----- > Umask for oracle user is 022. > There is a unix user who wants read access to the data files since they > are read by fastunload process (syncsort). > When i do a touch on any file in that same directory the permission > reads as -rw-r--r-- which coincides with the umask set. > Could someone please tell me how the data files get -rw-r---- and NOT > -rw-r--r--. > > Oracle file permission reads -rwsr-s--x > > Thank You, > > Sathish. > > -- > http://www.fastmail.fm - Choose from over 50 domains or use your own > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
