Re: equivalent Unix file for Oracle table

why in the world would you want to?

oracle puts security on the .dbf files(or at least u should have perms on them for 750), there is NO REASON for anyone to grep the .dbf files that doesn't have the oracle password(and no one should login in as oracle except for installs or patches).

have a different unix acct to do those kinds of things.

i have played around with grep the .dbf files but never as oracle and I never have write permission on the file or directory, it only takes one slip of a finger and the .dbf file is gone.

joe
Sanjeev Jha wrote:
>
> Hi all,
>
> May be it's very easy question but as a system admin asked me -
> " With an example - create a table, make some entry, commit it and now exit
> to Unix shell. Now where can you "grep" (or something else) the values I
> enter in the table without using SQL prompt ?" Say, I entered 'Sanjeev' in
> the table, #grep Sanjeev *.dbf (might be this file) didn't work out.
>
> Thanks,
> Sk
> --
> Author: Sanjeev Jha
> INET: sjha_at_livevault.com
>
> 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: ListGuru_at_fatcity.com (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).

-- 
Joe Testa  http://www.oracle-dba.com