RE: equivalent Unix file for Oracle table

hmm I didn't know that. Thanks. But where * are those files which contains information entered in the table ? Also I can see some control files in ../oradata/unix/* ... What is the purpose of three file names with same size and timestamp ?

Thanks again.
sk

-----Original Message-----
From: Joseph S. Testa [mailto:teci_at_oracle-dba.com] Sent: Friday, September 08, 2000 9:10 PM To: Multiple recipients of list ORACLE-L Subject: 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
-- 
Author: Joseph S. Testa
  INET: teci_at_oracle-dba.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).