RE: TEXT FILE

It depends. What version of Oracle?

You can also create a file via Java Stored Procedure (requires at least v8.0, possibly 8i?). If you're able to grant JAVA_SYSPRIV to the account creating the file, you can also avoid the hassle of being restricted to directories specified by the UTL_FILE_DIR init.ora parameter for OS file access.

For extensive searches and indexes, you may also want to consider Oracle's ConText/InterMedia/Text cartridge (names depend on your version).

Rich

Rich Jesse                           System/Database Administrator
[EMAIL PROTECTED]                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Seema Singh [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 4:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: TEXT FILE
>
>
> Hi,
> Is there any other packages thru which we can generate text
> file except
> UTL_FILE?
> I want to generate text file dump into another server ,that
> server will
> indexes and processing that data and improve search.
> How to do that?
> Thanks
> -Seema
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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).